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!

















    Access your files securely from anywhere







                            Zoho Developer Community




                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts





                                                            Manage your brands on social media



                                                                  Zoho TeamInbox Resources



                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner









                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • FSM - Timesheet entires for Internal Work

                                                                                                                Hi FSM Team, Several of my clients have asked how they can manage internal timesheets within Zoho FSM. Since their technicians already spend most of their day working in FSM, it would be ideal if they could log all working hours directly in the FSM app.
                                                                                                              • Add a way of clearing fields values in Flow actions

                                                                                                                It would be great if there was an option to set a field as Null when creating flows. I had an instance today where I just wanted to clear a long integer field in the CRM based on an action in Projects but I had to write a custom function. It would be
                                                                                                              • Role Management

                                                                                                                I am creating an analytics dashboard for a company that will be utilized by its various departments such as Finance, Marketing, and HR. My goal is to design the dashboard with separate tabs for each department. Additionally, I plan to implement role-based
                                                                                                              • Highlight a candidate who is "off limits"

                                                                                                                Hello: Is there a way to highlight a candidate who is "off limits"?  I would like to have the ability to make certain candidate and / or Client records highlighted in RED or something like that.   This would be used for example when we may have placed a candidate somewhere and we want everyone in our company to quickly and easily see that they are off limits.  The same would apply when we want to put a client or former client off limits so no one recruits out of there. How can this be done? Cheers,
                                                                                                              • Announcing new features in Trident for Windows (v.1.37.5.0)

                                                                                                                Hello Community! Trident for Windows just received a major update, with a range of capabilities that strengthen email security and enhance communication. This update focuses on making your mailbox safer and your overall email experience more reliable.
                                                                                                              • Early Payment Discount customize Text

                                                                                                                Hi, I’m currently using Zoho Books and am trying to customize the standard “Early Payment Discount” message that appears in the PDF invoice template. I’ve reviewed the documentation here: https://www.zoho.com/books/help/invoice/early-payment-discount.html
                                                                                                              • Deprecation of SMS-based multi-factor authentication (MFA) mode

                                                                                                                Overview of SMS-based OTP MFA mode The SMS-based OTP MFA method involves the delivery of a one-time password to a user's mobile phone via SMS. The user receives the OTP on their mobile phone and enters it to sign into their account. SMS-based OTPs offer
                                                                                                              • DKIM Now Mandatory - Changes to Zoho Forms Email Policies

                                                                                                                Hello Zoho Forms Users, This post is to inform you about an important update regarding the authentication of all email domains in your Zoho Forms account. This year, we are doubling down on our commitment to deliver a secure, seamless, and empowering
                                                                                                              • Call description in notes

                                                                                                                When completing a call, we type in the result of the call in the description. However, that does not show up under the notes history on the contact. We want to be able to see all the calls that have taken place for a contact wihtout having to go into
                                                                                                              • Email Address for Contact not Populating

                                                                                                                When I click "Send Mail" from a Contact's page, their email address does not auto populate the "To" field. How do I make this happen?
                                                                                                              • New in CRM: Dynamic filters for lookup fields

                                                                                                                Last modified on Oct 28, 2024: This feature was initially available only through Early Access upon request. It is now available to all users across all data centers, except for the IN DC. Users in the IN DC can temporarily request access using this form
                                                                                                              • Why hybrid project management might be the best fit for you?

                                                                                                                Project management techniques are designed to equip teams with proven methods for easy and efficient project execution. While management teams may have apprehensions about adopting the hybrid method of project management, we’ve compiled the top reasons
                                                                                                              • Allow all Company Users to view all projects, but only owner/admins can change projects

                                                                                                                I was wondering if there was a permission setting I could adjust to allow all our company users to see all projects created. Then, only the project owners and admins with the change permission. Thanks
                                                                                                              • Fail to send Email by deluge

                                                                                                                Hi, today I gonna update some email include details in deluge, while this msg pops up and restrict me to save but my rules has run for one year. can you tell me how to use one of our admin account or super admin account to send the email? I tried to update
                                                                                                              • Seeking help to be able to search on all custom functions that are defined

                                                                                                                Hello I have a lot of custom functions defined (around 200) and i would like to search some specific strings in the content of those. Is there a way to accomplish that? If not, is there a way to download all existing custom functions in some files locally
                                                                                                              • Totals for Sales Tax Report

                                                                                                                On the sales tax report, the column totals aren't shown for any column other than Total Tax. I can't think of a good reason that they shouldn't be included for the other columns, as well. It would help me with my returns, for sure. It seems ludicrous
                                                                                                              • Add Bulk Section / Grid Layout Duplicate Feature in Zoho Forms Builder

                                                                                                                Currently in Zoho Forms, users can only duplicate individual fields. There is no option to duplicate an entire section or two-column/grid layout with all internal fields. This becomes inefficient when building structured forms such as Family Details,
                                                                                                              • Leistungsdatum in Rechnungen (Zoho Books)

                                                                                                                Hallo, ist es irgendwie möglich den Leistungszeitraum in der Rechnung aufzuführen? Beste Grüße Aleks
                                                                                                              • Zoho Trident Windows - Streams Not Visible

                                                                                                                Namaste We’re having an issue with Streams not being visible in Trident (Windows), which is important for us as we share many emails internally. It appears that the feature to show Streams above the Inbox folder, as seen in the default mailbox view, is
                                                                                                              • Sales IQ Chat Widget is Only Displaying Last Name

                                                                                                                Can anyone suggest why the widget is only displaying "last name"?! We have the latest version of the wordpress plugin installed. Thanks Thanks!
                                                                                                              • Shopify - Item sync from Zoho Inventory

                                                                                                                Hi team, We’ve connected Shopify with Zoho Inventory. We want that when an item is created in Zoho Inventory, it must create a product in Shopify. But currently, new items created in Zoho Inventory are not getting created in Shopify even after clicking
                                                                                                              • Bulk upload image option in Zoho Commerce

                                                                                                                I dont know if I am not looking into it properly but is there no option to bulk upload images along with the products? Like after you upload the products, I will have to upload images one by one again? Can someone help me out here? And what should I enter
                                                                                                              • Is it possible to setup bin locations WITHOUT mandating batch tracking?

                                                                                                                Hi fellow zoho users, I'm wondering if anyone else has a similar issue to me? I only have some products batch tracked (items with shelf life expiry dates) but I am trying to setup bin locations for my entire inventory so we can do stock counting easier.
                                                                                                              • Kill zoho meeting

                                                                                                                Saying the quiet part out loud. Can zoho please just give up on the idea that they can make a meeting platform and just make our workplace licenses cheaper when you remove it so people can switch to zoom or teams. Tired of the excuses, you guys cant make
                                                                                                              • Utilisation de Zoho en conformité avec l’article 286 du Code général des impôts (CGI)

                                                                                                                Cher(e) client(e), Conformément à l’article 286 du Code général des impôts (CGI) impose aux entreprises assujetties à la TVA d’utiliser des systèmes de caisse ou de gestion commerciale certifiés lorsqu’elles enregistrent des ventes à des particuliers.
                                                                                                              • Unable to Create Task as a Support Administrator

                                                                                                                Hello! I want to ask for help regarding creating tasks within the tickets. I am by default the Support Admin. I should be able to create tasks or activities right? But there's a prompt that I need to contact the Administrator. See photos for reference.
                                                                                                              • Introducing Forms in Zoho Sheet

                                                                                                                We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
                                                                                                              • Layout one survey question in a time & redirect next Page based on previous response

                                                                                                                I have doubt while, I am scripting survey on the Zoho where I redirecting to next page based on my previous response but didn’t get success on this. Please help me on this and tell me how I layout one survey questions in a time when I submit response
                                                                                                              • Zoho Bookings form pre-filled with Zoho Forms in

                                                                                                                Hi, I've got a contact page on my website and I'd like to have the option to book an appointment (redirected to zoho bookings page) after an option is submitted on the contact form. how would I go about doing this? thanks
                                                                                                              • Support “Other” Option with Free Text in Dropdown Fields

                                                                                                                Hello Zoho Bookings Team, Greetings, We would like to request an enhancement to the registration form fields in Zoho Bookings, specifically for dropdown fields. Current Limitation: At the moment, dropdown fields do not support an “Other” option that allows
                                                                                                              • Sending automated messages that appear in the ticket's conversation thread

                                                                                                                Good morning, esteemed Zoho Desk community, warm greetings Today I am here to raise the following problem, seeking a solution that I can implement: I need to implement an automation that allows me to send reminder messages to customers when I am waiting
                                                                                                              • 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
                                                                                                              • Please verify my account

                                                                                                                Hi, We have just launched our website and received media coverage in our country. Hundreds of users are signing up for our platform every day. We would like to send them a welcome email, but we are unable to do so because our ZeptoMail account has not
                                                                                                              • Payment Card or Identity form-fill from Vault?

                                                                                                                Hello! I'm working on replacing Bitwarden with Vault and one issue I've run into is that I can't find any option to fill address and payment forms from Payment Card or Identity info that has been saved in Vault. Is there a way to do this? Is it a planned
                                                                                                              • Ability to add VAT to Retainer Invoices

                                                                                                                Hello, I've had a telephone conversation a month ago with Dinesh on this topic and my request to allow for the addition of VAT on Retainer Invoices.  It's currently not possible to add VAT to Retainer Invoices and it was mutually agreed that there is absolutely no reason why there shouldn't be, especially as TAX LAW makes VAT mandatory on each invoice in Europe!   So basically, what i'm saying is that if you don't allow us to add VAT to Retainer Invoices, than the whole Retainer Invoices becomes
                                                                                                              • Time Log Reminder

                                                                                                                Tracking the time spent on tasks and issues is one of the most important functions of a timesheet. However, users may forget to update the time logs because they have their own goals to achieve. But, time logs must be updated at regular intervals to keep
                                                                                                              • [Early-access] Introducing Zoho's CommandCenter - Cross-Zoho business process automation

                                                                                                                  Resources to help Webinar recording | Documentation  Feature Restrictions Currently available on early-access only for US data center accounts Features Role CommandCenter as a Service uses signals across Zoho services to propel the movement of records
                                                                                                              • Tip #58- Accessibility Controls in Zoho Assist: Learning- 'Insider Insights'

                                                                                                                Learning should be clear and interruption-free for everyone. Timely feedback plays an important role in helping users understand actions as they happen, without breaking their focus. In this post, we’ll explore the final section of Accessibility: Learning.
                                                                                                              • ZIA "Generate Content" action doesn't have contexual data from the ticket

                                                                                                                "Generate Content" action doesn't have contexual data from the ticket. I try to get AI to help me with this ticket but it doesn't seem to have any ticket information as context. Although the ticket has a lot of information in it.
                                                                                                              • Zoho Desk - Zoho FSM Integration issue on Mobile and iPad

                                                                                                                Hello Team, I am trying to create a Work Order (WO) using the Zoho FSM integration (Add-on Service) that is integrated with Zoho Desk. The issue is that the integration is not working on mobile devices and iPads. While I am able to create the WO, Request,
                                                                                                              • Next Page