Integreat 04: Integrating Zoho Creator with Zoho Desk - Part 2

Hi folks,

We're hope the previous post on Zoho Desk integration was useful to you. In this post we will cover the rest of the tasks (task 5,6, and 7) that can be automated once you integrate your Zoho Creator application with Zoho Desk.

As mentioned in the previous post, once you've established a relationship between Zoho Creator and Zoho Desk, you can perform the following task:

1. Create new records in Zoho Desk

2. Fetch data from Zoho Desk

3. Fetch specific records using the record ID from Zoho Desk

4. Update specific records in Zoho Desk, using Zoho Creator

5. Search records by specifying criteria in Zoho Desk, using Zoho Creator

6. Fetch related records in Zoho Desk, using Zoho Creator

7. Create related records in Zoho Desk, using Zoho Creator

5. Search records by specifying criteria in Zoho Desk, using Zoho Creator

You can search records in Zoho Desk by specifying the criteria in Zoho Creator. This task can achieved by making use of the zoho.desk.searchRecords() task.

Syntax

<variable> =zoho.desk.searchRecords(<orgID>, <module_name>,<query>, <fromIndex>,<limit>, <connection>);

Use case

Let's say you want to search the list of tickets in Zoho Desk by specifying the subject.

Assume that the Ticket Subject Search form has the following field:

Subject(Single Line field type

We need to fetch all the tickets matching the subject ("testing") that's specified in the Zoho Creator form, from the Tickets module in Zoho Desk.

Example

response = zoho.desk.searchRecords(691803821, "tickets", {"subject":input.Subject}, 0, 10, "deskAuth");

6. Fetch related records in Zoho Desk, using Zoho Creator

You can fetch related records from a Zoho Desk module based on a specific record, by using the zoho.desk.getRelatedRecords() task.

Syntax

<variable> = zoho.desk.getRelatedRecords(<orgID>, <sub_module>, <parent_module>, <record_ID>, <fromIndex>, <limit>, <query_value>, <connection>);

The zoho.desk.getRelatedRecords task allows you to fetch the following information:

Tickets based on a contact
Tickets based on an account
Tasks based on a ticket
timeEntry based on a ticket
timeEntry based on a task
timeEntry based on an agent
Comments based on a ticket
Thread based on a ticket

Use case

Let's say you want to fetch the tickets of a particular contact and want to autopopulate the Ticket Number dropdown field.

Let's assume the Ticket Details form has the following fields:

Contact ID (single line field type)
Ticket Number (drop down field type)

Example

contact_id=input.contactid.tolong();
mp = Map();
y=zoho.desk.getRelatedRecords(<orgID>,"tickets","contacts",contact_id,<range>,<range>,mp,"<connection name>");//fetching ticket number and sorting it, list is created
y = y.getjson("data").toJSONList();
for each rec in y
{
input.Ticket_Number:ui.add(rec.getjson("ticketNumber").tolong());
}

7. Create related records in Zoho Desk, using Zoho Creator

You can create a related record in a sub-module belonging to a record in a parent module in Zoho Desk. This can be achieved by using the Deluge Task zoho.desk.createRelatedRecord().

Syntax

<variable>=zoho.desk.createRelatedRecord(<orgID>, <sub_module>, <sub_recordID>, <parent_module>, <parent_recordID>, <record_value>, <connection>);

This task allows you to create the following:

A timeEntry based on a ticket
A timeEntry based on a task

Use Case

The time entry can be created in the ticket by making use of the below script in the On success workflow of the form.

Example

recordValue = {"executedTime":"2019-10-18T07:38:48.000Z"};
response zoho.desk.createRelatedRecord(691803821,"timeEntry","tickets",406419000000271001,recordValue,"deskAuth");

Merge tickets

You can merge tickets by merging the values of the ticket ID to another ticket. Use zoho.desk.ticket.merge() task to perform this action.

Syntax

<variable> = zoho.desk.ticket.merge(<orgID>, <ticket_ID>, <param_value>, <connection>);

Use case

If you see any duplicate tickets created in Zoho Desk and you wanted to merge those tickets into one, the zoho.desk.ticket.merge() Deluge task in Creator do the job for you.

Example

paramValue = {"ids":{<ticketID 1>,<ticketID 2>}};
response = zoho.desk.ticket.merge(<org iD>,<ticket ID>,paramValue,"<connection name>");

//ticket ID=> where other ticket ID 1&2 in paramvalue variable will be merged to ticket ID.

Move a ticket

The ticket can be moved from one department to another department with the help of the zoho.desk.ticket.move() Deluge task in Creator.

Syntax

<variable> = zoho.desk.ticket.move(<orgID>, <ticket_ID>, <department_ID>, <connection>);

Use case

If you see any ticket assigned to the wrong department in Desk and wanted to reassign it to the correct department, you can make use of the zoho.desk.ticket.move() Deluge task.

Example

x = zoho.desk.ticket.move(<org iD>,<ticket iD>,<department ID>,<connection_name>);

// department ID is the ID of the department to which this ticket will be moved.

The ticketID and department ID can be fetched using fetch task.

Split a ticket

A ticket can also be split into multiple tickets based on the thread, by using the thread ID of that particular ticket.To get the thread ID of the ticket, use the getrelatedrecords task.

Syntax

mp = Map();

g = zoho.desk.getRelatedRecords(<orgID>,"threads","tickets",<ticketID>,<map variable>,"<connection name>");

//info g; (thread ID can be fetched from this response)

h = zoho.desk.ticket.split(<org ID>,<ticket iD>,<thread ID>,"<connection name>");

We hope this post on Zoho Desk integrations was useful to you. If you have any questions, feel free to add them as comments below. If you'd like us to cover any specific integration, please add them here in comments and we'll take it up.

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Sejal Dattani
simon

Sticky Posts
[SESSION ENDED] Ask the Experts #07| Live Q&A: Building workflows with Blueprint in Zoho Creator |
Hello, Post the release of Zoho Creator Blueprint last month, we're happy to tell you that we'll be launching a new 'Ask the Experts' session on 16th September (Thursday) this month focussing on creating blueprints in Zoho Creator. The session will be
Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Community Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. Customize
Community Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
[RECORDING: Community Webinar] | Build complex reports and documents with a Zoho Creator & Zoho Writer integration | March 23, 2021
Dear developers, Report generation is an essential activity to ensure decision makers have the best information available to be able to monitor and improve performance. Enterprises may need to generate and distribute stakeholder specific documents in