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

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



Hi folks,

We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Zoho Desk. Before we dive into this integration, let's quickly look at what Zoho Desk is and how you can use it in your organization.

What is Zoho Desk?

It's a cloud-based platform that helps businesses assign, track, and manage customer support tickets efficiently.

Integrating with Zoho Desk

With this integration you can push data automatically from your Zoho Creator application to your Zoho Desk account and perform various actions, without any manual effort. You can connect these services by mapping fields in your Zoho Creator form to a supported Zoho Desk module.

Integrate your applications with Zoho Desk and automate tasks like:
● Creating tickets, contacts, accounts, tasks, products, and contracts in Zoho Desk, using Zoho Creator.
● Access and search ticket details based on a contact and account, using Zoho Creator.
● Merge and split tickets and move them to specified departments in Desk, from Zoho Creator.

With Deluge, you can use the built-in integration task to connect with the different modules in Zoho Desk. These are the Zoho Desk modules that we support:
● Agents
● Departments
● Tickets
● Contacts
● Accounts
● Tasks
●  Products
●  Contracts
Note: First, you need to connect to Zoho Desk. Please check the help link to get the details about setting up the connection. You can directly create a record in Zoho Desk while creating a new record in Zoho Creator, just by creating a simple workflow. This eliminates the need for re-entering data again in Zoho Desk. 


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
Now let's look at each of them in more detail:

1. Create new records in Zoho Desk 

You can directly create a record in Zoho Desk while creating a new record in Zoho Creator, just by creating a simple workflow. This eliminates the need for re-entering data again in Zoho Desk.

Syntax 

response = zoho.desk.create(<orgId>, <module>, <MAP>, <connection>);

Use case
Let's say you have a Contacts form—when the user submits the form, the entered information can be automatically recorded in Zoho Creator and in the Contacts module of Zoho Desk, as well.

Let's assume the Contacts form has the following fields:
  1. Name (Name field type)
  2. Email (Email field type)
  3. Secondary Email (Email field type)

To create this record simultaneously in the Contacts module of Zoho Desk, you need to execute the zoho.desk.create() task in the On Success actions block of the Contacts form. 

You can achieve this using the following script:

  1. contactMap = Map();
  2. contactMap.put("firstName",input.Name.first_name);
  3. contactMap.put("lastName",input.Name.last_name);
  4. contactMap.put("email",input.Email);
  5. contactMap.put("secondaryEmail",input.Secondary_Email);
  6. response = zoho.desk.create(<ORG ID>,"contacts",contactMap,"deskAuth");


2. Fetch data from Zoho Desk

You can fetch data from Zoho Desk to autopopulate a Zoho Creator form. Use zoho.desk.getRecords() task in Zoho Creator to do it.

Syntax
response = zoho.desk.getRecords(<orgId>, <module>, <from>, <limit>, <optionalMap>, <connection>);

Use case

You can use this task when you want to fetch the list of all your tickets stored in Zoho Desk, and populate them in a dropdown field in Zoho Creator. You can also fetch the relevant contact details from Desk to populate the form fields.

Let's assume the ticket details form has the following fields:
  1. Ticket Number (Dropdown field type)
You can fetch the Ticket Number from the Tickets module in Zoho Desk, to populate the Ticket Nnumber (dropdown field) in the Creator form using the ui.add() task. Use the below script in the On Load action block of the Zoho Creator form. 

Example
  1. response = zoho.desk.getRecords(<ORG ID>,"tickets",0,10,{"":""},"deskAuth").getJson("data").toJSONList();
  2. for each ticket in response
  3. {
  4. input.Ticket_Number:ui.add(ticket.getJson("ticketNumber"));
  5. }

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

You can also fetch a single record from Zoho Desk by specifying its record ID, with the help of Zoho Creator form. You can make use of zoho.desk.getRecordById() Deluge task to get this job done.

Syntax
response = zoho.desk.getRecordById(<orgId>, <module>, <recordId>, <connection>)

Use case
For example, you have a record ID of the ticket you'd like to view the details of.

Let's assume the Ticket Search form has the following fields:
  1. Ticket ID (Single line field type)
  2. Ticket Number (Single line field type)
You can fetch the ticket number of the specified ticket ID from the Tickets module, and populate the ticket number field with the same details. Use the script below in On User Input of the ticket ID field's action block on the ticket search form. 

Example
  1. resp = zoho.desk.getRecordById(691803821,"tickets",input.Ticket_ID.toLong(),"deskAuth");
  2. input.Ticket_Number = resp.getJson("ticketNumber");



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

You can automatically update records in Zoho Desk by simply submitting a form with the relevant details in Zoho Creator. You can perform this action by using the zoho.desk.updateRecord() task.

Syntax
response = zoho.desk.update(<orgID>, <module>, <record_ID>, <MAP>, <connection>);

Use case
Let's say you want to simultaneously update the ticket number in Zoho Desk when it's edited in Zoho Creator. You can configure a workflow to automatically update the same record in Zoho Desk.

Let's say the Ticket Search form has the following fields:
  1. Ticket ID (Dropdown field type)
  2. Ticket Subject (Single line field type)

You can update the subject of a specific ticket in the Tickets module with what's entered in the ticket number field (Single line field type) of the Ticket Search form. You can use the script below in On Success of the form workflow. 

Example
  1. ticketMap={"subject":input.Ticket_Subject};
  2. response = zoho.desk.update(691803821, "tickets", Ticket_ID.toLong(), ticketMap, "deskAuth");


We hope this comprehensive post on Zoho Desk integrations was useful to you. We will be covering the remaining 3 tasks in the part two of this post. If you have any questions, feel free to add them as comments below. We'll be happy to address them all for you!

















    • Recent Topics

    • Add Full-Screen Viewing for Quartz Recordings in the Client Interface

      Hi Zoho Team, We would like to request an enhancement to the Zoho Quartz client interface when viewing submitted recordings. Current Limitation: When viewing a Quartz recording from the client (user) interface, there is currently no option to switch the

    • Not Receiving OTP • https://voters.eci.gov.in/home/family

      Hello Customer, Greetings from Zoho Mail. Upon a detailed review of our delivery logs, we can confirm that other Zoho Mail users are successfully receiving OTP emails from eci.gov.in. However, in your specific case, it appears that the OTP emails are

    • WorkDrive for Excel Add on

      Dear Sir/Madam Have installed Workdrive for Microsoft add on But unable to view the same added in Excel

    • Zoho Calendar s’enrichit avec une intégration à Zoho People et Zoho Cliq

      Les journées de travail ne se déroulent jamais exactement comme prévu. Une conversation informelle devient une séance d’échange d'idées, une absence modifie un planning, et votre agenda se retrouve vite décalé par rapport à la réalité. Chez Zoho Calendar,

    • Holidays

      Hi; For defining Holidays, you need to add logic to handle the year as well as the month & day. We need to be able to enter Holidays for the next year. I need to add a holiday for January 2, 2017, but I can't until January 1st, which is a Sunday and we

    • Zoho public comments are confusing and unnecessary

      Hi, we use zoho desk and have issues with public comments. We started using them because the "Reply" option just seemed very clumsy because of the following reasons: - the top "Reply" button starts what seems to be a regular email, showing the entire

    • Introducing parent-child ticketing in Zoho Desk [Early access]

      Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child

    • Zoho API - ticket creation - Validation failed for the condition : Ticket Status Info should not be empty

      Hi ! I'm trying to create ticket through Zoho API, and I'm getting a 422 response : "Validation failed for the condition : Ticket Status Info should not be empty" My request looks like this : curl --location 'https://desk.zoho.eu/api/v1/tickets' \ --header

    • How to create a two way Sync with CRM Contacts Module?

      Newbie creator here (but not to Zoho CRM). I want to create an app that operates on a sub-set of CRM Contacts - only those with a specific tag. I want the app records to mirror the tagged contacts in CRM. I would like it to update when the Creator app

    • 10GB Email Storage Limits in Zoho CRM

      We’ve had Zoho One for almost 5 years and have always synced our emails from Gmail via IMAP… As of late, we’ve run into issues with our emails not syncing, due to being over the 10GB storage cap… What’s very odd is that we haven’t changed a thing? I know

    • Zoho Books Sandbox environment

      Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need a

    • Deleting unwanted ticket replies

      Hello, In a Zoho Desk Ticket thread, sometimes one of the recipients has auto-reply activated. This creates a new message in the Ticket thread that not only pollutes the thread, but most importantly cannot be replied properly because usually auto-reply e-mails don't do "reply all", so the other recipients are not included. I want to delete such a message in the Ticket thread. I searched the help of Zoho Desk, but only found a way to mark as Spam (https://help.zoho.com/portal/kb/articles/marking-support-tickets-as-spam)

    • Desk DMARC forwarding failure for some senders

      I am not receiving important emails into Desk, because of DMARC errors. Here's what's happening: 1. email is sent from customer e.g. john@doe.com, to my email address, e.g info@acme.com 2. email is delivered successfully to info@acme.com (a shared inbox

    • System-generated support email added in CC on “Reply All”

      Hi, I recently set up Zoho Desk for a client and we are trying to prevent the Zoho Desk system-generated support email address (not the mailbox used as the department’s "From address") from being automatically added in CC when agents use “Reply All” on

    • Create & Update Zoho Vault Passwords via Zoho Flow

      Hi Zoho Flow / Zoho Vault Team, We’d like to request an enhancement to the Zoho Vault integration in Zoho Flow. Current Limitation: At the moment, Zoho Flow supports only the following selected Zoho Vault actions, such as: Fetch passwords, Share passwords

    • Applying Excess Payments & Conflict Invoices Due to Cancelled Items

      I’m running into several issues that appear to stem from deeper-than-expected overlap between Zoho Finance (Books/Inventory) and Zoho POS. The level of coupling between these systems seems greater than what was originally communicated, and it’s leading

    • Please, make writer into a content creation tool

      I'm tired of relying on Google Docs. I'm actually considering moving to ClickUp, but if Writer were a good content creation tool instead of just a word processor, I would finally be able to move all my development within the Zoho ecosystem, rather than

    • Zoho Sheet - Desktop App or Offline

      Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.

    • HTML Tags added to Reports with Notes

      Recently Zoho added the ability to markup text within notes. That way, users can change font size, colors, etc. It's a great change. However, since the change, reports that include a column for "Note Content" are printing HTML tags within the report.

    • New Feature: Audit Log in Zoho Bookings

      Greetings from the Zoho Bookings team! We’re excited to introduce Audit Log, a new feature designed to help you track all key actions related to your appointments. With Audit Log, you can maintain transparency, strengthen security, and ensure accountability.

    • Bill automation in Zoho Books

      Hi I am looking for 3rd-party options for bill automation in zoho which are economical and preferably have accurate scanning. What options do I have? Zoho's native scanning is a bit pricey

    • Restrict Payment Methods

      Allow us to restrict certain payment methods specific for each customer.

    • Introducing the Zoho Projects Learning Space

      Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,

    • Emails Getting Delay Error Messages - Status: 451

      Hi. Hoping someone can help. I've been using Zoho for over a year now with no problems at all. Today, the majority of my emails I send out or reply to are getting this error: This message was created automatically by mail delivery system. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. The original message was received at Sun, 22 Dec 2019 18:20:19 -0800 from wazza@amninjas.com [wazza@amninjas.com] ----- The following addresses had fatal errors ----- [Status: ERROR, Address:

    • Add Domain

      Hello Zoho Support, My Zoho Sites project accidentally auto-added domains with http:// prefix and duplicated domain entries. Current domains list shows: http://www.kinhtethethao.com.vn (Primary – cannot be removed) http://www.kinhtethethao.com.vn (verification

    • Kaizen #221: Workflow & Actions Reports APIs

      Over the last few weeks, we have joined Zylker Cloud Services as they restructured their automation ecosystem using Workflow APIs and Actions APIs. Along the way, we discovered how to audit workflows, update old rules, create new ones, and manage associated

    • Having an Issue with the Entity ID

      I'm having an issue when trying to use Zoho Flow and the notes function. I currently have it set up when a new response comes into a particular form, all of their responses will go into the notes section of their contact on the CRM. I'm currently mapping

    • For Each Loop in Zoho Flow

      I am using Zoho flow to create rows in an google sheets for every new order in Shopify but the issue is that it is creating one row per order and all line items are comma separated values but I want separate rows for each line item. Is there a way to

    • Debug and Test not receiving updates

      Hello, I've been trying to debug two of my simple flows between Zoho Projects and Clockify but it seems like the Debug and Test feature is not working for me. When I click the Play button on any of the flows and then perform the trigger actions nothing

    • How do people handle using Outlook and Zoho Project calendar at the same time?

      We have an ongoing problem in our organisation where we use Zoho Projects to plan all of our projects tasks and that also allows us to look forward using the workload report to see which of our consultants are overstretched etc and which are available.

    • Attendance, Reimagined: Smarter Views for Teams and Individuals

      Tracking attendance shouldn’t feel like a chore. With the revamped Attendance module UI, Zoho FSM makes it easier than ever to monitor work hours, check-in activity, and team availability—whether you’re managing an entire workforce or just keeping an

    • Logistics Industry: Learn to create amazing appointment scheduling sites

      In the logistics industry, the quality of service is something that cannot be shown to others unless they experience it.  Sure, there are metrics that show how you fare when compared to your competition, but then, it only communicates little with respect to quality. The usual route which firms in logistics took are advertisements, to which the internet has opened alternatives in today’s digital age like websites and appointment scheduling sites. A great online presence can help you communicate with

    • Customer Management: # 1 Pick a Convenient Way to Onboard Customer

      When Meera opened her bookstore, onboarding customers was effortless. A customer walked in, picked a book and left with a handwritten bill. As the store gained popularity, things changed. " Can I place an order over the phone?" a customer asked one day.

    • Tracking Emails sent through Outlook

      All of our sales team have their Outlook 365 accounts setup with IMAP integration. We're trying to track their email activity that occurs outside the CRM. I can see the email exchanges between the sales people and the clients in the contact module. But

    • Fetch ALL items from Inventory and send to Google Sheet using Flow

      The title says it all -- I want to fetch the Item name, SKU, Purchase rate, and Sales rate for ALL items in Zoho Inventory and have them populate a tab in an existing Google Sheet. I have already successfully made this work for one item, so the flow is

    • Why Document Integrity Matters at Every Stage of the Contract Lifecycle

      Contracts are legal records that must stay authentic and traceable from creation to expiry or termination. In Zoho Contracts, several design decisions focus on protecting the integrity of every document. These measures ensure that no important details

    • affichage pièces jointes impossible

      Bonjour, aujourd'hui je n'arrive pas à afficher ni à télécharger les pièces jointes dans ZOHO CRM. J'utilise Chrome, j'ai vidé les caches et les cookies. Mais cela ne change rien. Merci de votre aide

    • Reminder to renew subscription.

      Whenever I try to add to one of my notes a " renew your subscription" window pops out and won't Close disallowing me to edit. Why should I renew my subscription on an application with at best such bugs and at worse such underhanded ways to force ren

    • Fields not coming through, not pulling data

      Forgive the noviceness of my vocabulary. I am in Zoho flow connecting CRM and Projects. When an opportunity hits a certain stage, it will create the project in Projects, and bring in data from the opportunity. Everything is working, except for two fields

    • Smartsheet Integration

      Has any in the community been able to integrate Zoho Desk with Smartsheets using Zoho Flow? I am trying to get the Smartsheet Row ID based on ticket data and cannot find documentation on the Get Row function for Smartsheet. It is asking for a Query String

    • Next Page