Extension Pointers for Integrating Zoho CRM with Zoho products #3: Keep track of your Zoho Desk tickets from within Zoho CRM

Extension Pointers for Integrating Zoho CRM with Zoho products #3: Keep track of your Zoho Desk tickets from within Zoho CRM

Operating a business necessitates complete management of all individual units in order to achieve smooth operations. Working with a CRM solution and handling support-related tickets are two critical units that must work together for a successful outcome.

In this post, we'll look at how you can use an extension to integrate Zoho Desk with Zoho CRM and track desk tickets from within your CRM. Consider a scenario where the contacts present in Zoho CRM have tickets in Zoho Desk associated with different products offered. Now, if those tickets appear as a related list in every contact, it's easier for sales representatives to keep track from within the CRM itself.

Creating a connector for Zoho Desk and adding connector APIs
  • Create a new connector in your extension for Zoho Desk using the Connectors feature under Utilities in the left panel of the Zoho Developer console.
  • Note: Zoho Desk follows OAuth2.0 protocols for authentication. You can refer to this post to understand the steps to register Zoho Desk and retrieve your client credentials.
                     
The connector details for our example are:


The Zoho Desk REST APIs added for our example are mentioned below.

Connector API Name
Method type
URL
Get tickets by contact
GET
https://desk.zoho.com/api/v1/contacts/${contactid}/tickets
Search Contacts
GET
https://desk.zoho.com/api/v1/contacts/search?limit=1&email=${email}


Note: You can refer to this post to understand the detailed steps involved in creating a connector, adding the connector APIs, and associating it with the extension.

Creating a related list and associating a custom related list function to it
  • Create a related list called "Desk Tickets" using the Related Details feature available in the Components section of the Zoho Developer console, then associate a custom function to perform the desired action. 
  • Note: In order to store the organization ID of the desk portal from which the tickets are to be fetched, a CRM variable is created named 'Orgid'. The value for the variable will be entered by the user during extension installation.


Desk tickets function code snippet

//Retrieving the record details and storing the email value
response = zoho.crm.getRecordById("Contacts",contact.get("Contacts.ID").toLong());
Email = response.get("Email");
orgid = zoho.crm.getOrgVariable("xxx__Orgid");
dynamic_map = Map();
dynamic_map.put("email",Email);
dynamic_map.put("orgid",orgid);
/*Invoking the search desk contacts api by passing the email id value retrieved from the get records*/
resp = zoho.crm.invokeConnector("xxx.desk.searchcontacts",dynamic_map);
responsedata = resp.get("response");
data = responsedata.get("data");
//Fetching the id of the desk contact
for each value in data
{
id = value.get("id");
}
dynamic_map = Map();
orgid = zoho.crm.getOrgVariable("xxx__Orgid");
dynamic_map.put("contactid",id);
dynamic_map.put("orgid",orgid);
//Invoking the get tickets by contacts api by passing the contact id value retrieved 
resp1 = zoho.crm.invokeConnector("xxx.desk.getticketsbycontact",dynamic_map);
responsedata1 = resp1.get("response");
data1 = responsedata1.get("data");
resp = "";
count = 1;
//constructing the record for related list
recordsXmlStr = "<record>";
for each value in data1
{
recordsXmlStr = recordsXmlStr + "<row no='" + count + "'>";
weburl = value.get("webUrl");
ticketNumber = value.get("ticketNumber");
recordsXmlStr = recordsXmlStr + "<FL val='Associated ticket list' link=\"true\" url='" + weburl + "'>" + value.get("subject") + "- #" + ticketNumber + "</FL>";
recordsXmlStr = recordsXmlStr + "<FL val='Status'>" + value.get("status") + "</FL>";
recordsXmlStr = recordsXmlStr + "</row>";
count = count + 1;
}
recordsXmlStr = recordsXmlStr + "</record>";
resp = resp + recordsXmlStr;
return resp;
  • The above code snippet retrieves the current CRM contact record details, from which the email address value is fetched and stored
  • This email address is then passed along with the value of the CRM variable 'Orgid' to the search desk contacts API, which retrieves the contact ID of the customer associated with that email address
  • The retrieved contact ID is passed to the get tickets by contact API, which returns a list of all available tickets for that customer
  • Now that we have seen the functionality and code, let's see a sample output of how this works. 
  • Enter the org ID value during installation.

  • Go to a Zoho CRM contact's detail page. Choose the related list 'Desk Tickets.'

  • The ticket details, such as subject and status, are populated

  • The ticket subject is also hyperlinked, redirecting to the ticket details page, so that the sales representative can easily keep track of available tickets and their status


This way you can integrate Zoho CRM with Zoho Desk and the functionality can be enhanced based on your business requirements. We hope you find this information useful. Keep following this space for more tips and recommendations.


SEE ALSO


Next>>

    Access your files securely from anywhere






                      Zoho Campaigns Resources


                            Zoho Developer Community



                                Bootcamp
                                Community
                                Pricing
                                Webinars
                                What's New
                                Integrations
                                Contact Support
                                Contact Sales

                                  Zoho Survey Resources
                                    Features
                                    Survey Templates
                                    Integrations
                                    Community
                                    iOS Mobile Surveys
                                    Pricing
                                    Android Mobile Surveys
                                    Insurvey Blogs
                                    Insight Blogs
                                    Tips & Tricks





                                                Latest Feature Updates
                                                  What's New in Zoho Desk

                                                  Use cases

                                                  Make the most of Zoho Desk with the use cases.

                                                   
                                                    

                                                  eBooks

                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                   
                                                    

                                                  Videos

                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                   
                                                    

                                                  Webinar

                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                   
                                                    
                                                  What's New in Zoho Desk

                                                  • Desk Community Learning Series


                                                  • Meetups


                                                  • Ask the Experts


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner





                                                      Zoho SalesIQ Resources

                                                            • Sticky Posts

                                                            • Kaizen #197: Frequently Asked Questions on GraphQL APIs

                                                              🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

                                                            • Kaizen #198: Using Client Script for Custom Validation in Blueprint

                                                              Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

                                                            • Celebrating 200 posts of Kaizen! Share your ideas for the milestone post

                                                              Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQs

                                                            • Kaizen #193: Creating different fields in Zoho CRM through API

                                                              🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

                                                            • Client Script | Update - Introducing Commands in Client Script!

                                                              Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands


                                                            Manage your brands on social media
                                                            Access Zoho Social

                                                              Zoho Pagesense Resources


                                                                  Zoho TeamInbox Resources

                                                                    Zoho DataPrep 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 Writer

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ








                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                            • Recent Topics

                                                                                                            • Optimizing Task Handling: Auto-Remove Recurrence for cancelled Tasks.

                                                                                                              Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:

                                                                                                            • Important updates to your connectors

                                                                                                              Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of the

                                                                                                            • Create, collaborate, and manage agreements with Zoho Sign

                                                                                                              Agreements drive business. We launched Zoho Sign in 2017 as a simple digital signature tool to sign agreements from anywhere, at any time. Over the years, we've learned that most agreements go through last-minute changes before they're signed. Our users

                                                                                                            • Function #25: Automatically generate purchase orders from a sales order

                                                                                                              We kicked off the "Function Fridays" series with the goal of helping you automate your everyday accounting tasks. As we delve into today's post, I'm delighted to announce that we're here to present the 25th custom function in this series. While it is

                                                                                                            • Has Anyone successfully integrated Zoho and Sage Intact?

                                                                                                              Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,

                                                                                                            • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (9/25)

                                                                                                              ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 9月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 ▷▷参加登録はこちら：https://us02web.zoom.us/meeting/register/6OSF2Bh6TumsMIlDwaY_PQ ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho

                                                                                                            • hiding a topic from all but one segment (or list)

                                                                                                              My organization sends out a number of newsletters using Zoho Campaigns. One of those newsletters is for volunteers. In order to become a volunteer, a person has to first go through our volunteer orientation (training). After that, they can receive newsletters

                                                                                                            • How do I set up this automation correctly?

                                                                                                              When contacts enter my Subscribers list, I want it to reference a custom field to see if it is empty. Then I want it to do two things: If empty: Assign a tag based on a different custom field. If that custom field is empty, assign a different tag. If

                                                                                                            • Function #62: Display associated Quote on Invoice details screen

                                                                                                              Hello everyone! Today, we are sharing a Related List script that makes it easy to view and access the quote from which an invoice was created right from the invoice details screen. This Related List displays the Quote number and Amount, allowing you to

                                                                                                            • Custom confirmation message

                                                                                                              How can I change the message that users see after they submit the booking form? I have to confirm some details before their appointment is officially "confirmed", so I want to change it where it doesn't say their appointment is "confirmed" but rather

                                                                                                            • Desk x CRM Integration

                                                                                                              Howdy! We currently use SalesIQ but we are considering moving across to Desk as it seems to have more functionality that we want. One of the pulls is the ability for our customers to self serve. But, I might be getting over excited and not actually need

                                                                                                            • Function #53: Transaction Level Profitability for Invoices

                                                                                                              Hello everyone, and welcome back to our series! We have previously provided custom functions for calculating the profitability of a quote and a sales order. There may be instances where the invoice may differ from its corresponding quote or sales order.

                                                                                                            • Issue with Save & Share Link – Works for Others but Not Creator

                                                                                                              I’ve enabled the "Save and Share" feature in Zoho Forms, and it works correctly for all users accessing the public link—except for me (the form creator). Issue Details: When I save and share the link, recipients see a “no permission” error. The form is

                                                                                                            • Save the pdf report from a registration form in a Folder

                                                                                                              Through Zoho Forms I created a registration form with quite a lot of rules to handle different variables (TEAM types, payment in installments, etc.), and the result is pretty good. The automatic PDF that is sent to the respondent upon submission is already

                                                                                                            • zoho forms integration to zoho work drive

                                                                                                              Scenario: A user fills out a Zoho Form, entering details such as email, mobile number, and other required information, and uploads supporting documents like PAN, Aadhaar, etc. Upon submission, the data is available in Zoho Forms Reports. Requirement:

                                                                                                            • Zoho Forms to Zoho CRM Integration failed - can I restart it?

                                                                                                              The integration of Zoho Form to Zoho CRM has failed. Is there a way for me to restart it for the impacted entry?

                                                                                                            • insert an equation, but in document, it shows an image not available.

                                                                                                              I'm new to Zoho writer and used Zoho writer in desktop app version . When I inserted an equation, I got an image not available sign. Any help is appreciated. Thanks, Charles

                                                                                                            • Zoho Desk Android app update - Swipe action customization

                                                                                                              Hello everyone! We have brought in support for the swipe action customization in latest version(v2.9.13) of the Zoho Desk Android app update, enabling you to configure left and right swipe gestures on tickets to carry out the actions swiftly without opening

                                                                                                            • Import KB template OR Export template for zoho desk?

                                                                                                              Greetings. Can you tell me if there is a way to get an EXPORT of my KB articles? OR is there a template you supply for importing KB articles into my zoho desk? I am looking for a method of understanding what fields can be imported, and what their possible

                                                                                                            • XML format to import knowledgebase into Zoho Desk

                                                                                                              Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.

                                                                                                            • Zoho Desk integration with Power BI

                                                                                                              Hi, I want to be able to create a Power BI report which has live updates of ticket data from zoho desk, is this possile at all? Thanks Jack

                                                                                                            • Arranging Ticket Templates

                                                                                                              Is there any way to arrange our ticket templates? It doesn't look very organised when it's just arranged according to when they were created. We want the list to look more organised, by arranging/grouping them by topics, or even just by alphabetical

                                                                                                            • What they mean with "Portal"?

                                                                                                              I just downloaded this app to take my personal notes on digital art studio because it seemed to me the most comfortable app to do it, I use it very often, what do they mean by “no activity on your portal”? I have about 1 year of work here and I don't

                                                                                                            • Inactive User Auto Response

                                                                                                              We use Zoho One, and we have a couple employees that are no longer with us, but people are still attempting to email them. I'd like an autoresponder to let them no the person is no longer here, and how they can reach us going forward. I saw a similar

                                                                                                            • favorites no longer listed

                                                                                                              Hello, I can no longer navigate to my Favorites from the pulldown at the top of my grid view (see attached screenshot). I wasn't able to find it anywhere! Please help me display my Favorites. Thank you!

                                                                                                            • Notecards Disappeared

                                                                                                              Got a new phone. Downloaded and signed in Zoho Notebook. Not finding the Note cards. Just Empty Note books. Frustrating.

                                                                                                            • Table Errors

                                                                                                              Hello, I'm new to Zoho Notebook and using it on several Mac/Apple devices. My question is regarding tables: Why do they become broken, and how to fix the error without retyping all my data? (Please see the screenshot attached.)

                                                                                                            • Aggregating the First Value in the Group By of a dataset

                                                                                                              Hi I am trying to get the following Aggregate Formula to work in my chart, but cannot seem to get the right format. I have a series of data that I am running an include_groupby and want to SUM only a column in the first row of each group. So for example.

                                                                                                            • Online Calculator with Zoho Forms?

                                                                                                              I'd like to build a custom calculator on my website. Zoho Forms seems to offer all the fields for basic calculations performed live without pressing any "Calculate" buttons. Unfortunately, there is still that "Submit" button at the bottom. There is nothing

                                                                                                            • Zoho Tables instead of Zoho Creator Spreadsheet reports <3

                                                                                                              That would make my day for sure. Zoho Creator is create, but miss data entering as AirTable/Spreadsheet can. Seeing Zoho putting effort in this makes me think maybe one day we could see a similar interface for Zoho Creator spreadsheet reports. B.

                                                                                                            • 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.

                                                                                                            • Notebook Stack

                                                                                                              Hi Everyone I Hope you´re fine, I´m sorry if this idea was posted before (I made a search but I haven´t find anything related). So, Having the possibility of stacking notebooks would be an interesting way to order notebooks that correspond to the same

                                                                                                            • Writing on sketch cards is bugged when zoomed in

                                                                                                              When zoomed in, it writes a noticeable distance above or to the side of where you're actually trying to write. The further you're zoomed in, the more noticeable it is. Zooming is also entirely absent on the desktop version.

                                                                                                            • Swipe between notes on iPhone

                                                                                                              It'd be convenient if I could move from one note to the next in a notebook simply by swiping left to right.

                                                                                                            • Sales IQ chat is not working in signed android apk

                                                                                                              I have integrated ZOHO sales IQ support chat and i have followed each step and its working fine in my development build but when i create signed APK for it. Chat does not work in it and showing awaiting for detail. I previously asked the same query but

                                                                                                            • COQL order by COUNT not working

                                                                                                              Dear community, I am trying to get a list of deal amounts per planner working on it and sorted to get see who has the least amount of deals. For some reason, I am unable to use sort by in combination with a COUNT. My original code was: query = "select

                                                                                                            • I want to duplicate a report and name it something else

                                                                                                              Hi, I have created a report, and now want to reproduce it and call it something else. so that I will end up with TWO separate reports with different titles. Please tell me how do I copy / reproduce a report please

                                                                                                            • Zoho CRM: Sales Rep Professional Certification Program on Coursera

                                                                                                              We are happy to share that we have published the Zoho Sales Representative Professional Certificate in partnership with Coursera, a leading platform for online learning and career development that offers access to courses and degrees from leading universities

                                                                                                            • OS X Notebook quits immediately upon launch

                                                                                                              NoteBook for OS X (Sequoia, but also under Sonoma) always quits immediately upon launch (so I cannot use the "Attach user log" option). I've restarted my MacBook but the problem persists. If it helps, attached is a diagnostic report from Library>Log

                                                                                                            • Can External users upload files or images to WorkDrive?

                                                                                                              I want to know if it is possible for someone externally through a link and PW be able to upload files and images onto WorkDrive?

                                                                                                            • Next Page