Extension Pointers for Integrating Zoho CRM with Zoho services #2: Handle and manage your Zoho CRM cases efficiently by integrating Zoho Projects and associating cases with tasks
Integrating customer relationship management and project management contributes to the development of an overall effective business management strategy.
You can integrate Zoho CRM and Zoho Projects through extensions to achieve your desired functionalities and manage your business from a single location. The previous post in the 'Integrating Zoho CRM with Zoho services' series described how to register your Zoho application and retrieve the client credential in order to connect Zoho CRM to the Zoho service of your choice through an extension. In this post, we'll look at how to integrate Zoho CRM with Zoho Projects, along with an example.
Let's consider a scenario in which support representatives handling cases in Zoho CRM need to forward cases that are registered as feature requests to the development team for further consideration and analysis. The representatives can create a task in Zoho projects with the necessary details from the Zoho CRM Cases module by clicking a button from within Zoho CRM. This will make the transition process easier and help to handle cases more efficiently. Now, let's see how this can be achieved using extension.
Creating a connector for Zoho Projects and adding connector APIs
- Create a new connector in your extension for Zoho Projects using the Connectors feature under Utilities in the left panel of the Zoho Developer console.
Note: Zoho Projects follows OAuth2.0 protocol for authentication mechanism. You can refer to this post to understand the steps to register Zoho Projects and retrieve your client credentials.
The connector details for our example are:
Request Token URL | https://accounts.zoho.com/oauth/v2/auth?scope=ZohoProjects.portals.READ,ZohoProjects.users.READ,ZohoProjects.tasks.CREATE,ZohoProjects.projects.READ,ZohoProjects.tasks.READ&access_type=offline |
Access Token URL | https://accounts.zoho.com/oauth/v2/token? |
Refresh Token URL | https://accounts.zoho.com/oauth/v2/token? |
Scopes | ZohoProjects.portals.READ,ZohoProjects.users.READ,ZohoProjects.tasks.CREATE,ZohoProjects.projects.READ,ZohoProjects.tasks.READ |
- Add the necessary connector APIs for your functionality. Please refer to the Zoho Projects REST API guide for details.
The Zoho Projects REST APIs added for our example are mentioned below.
Connector API Name | Method type | URL |
Get Portals | GET | https://projectsapi.zoho.com/restapi/portals/ |
Get Project Users | GET | https://projectsapi.zoho.com/restapi/portal/${portalid}/projects/${projectid}/users/ |
Create task | POST | https://projectsapi.zoho.com/restapi/portal/${portalid}/projects/${projectid}/tasks/?name=${name}&description=${description}&priority=${priority}&person_responsible=${person_responsible} |
Add comment for task | POST | https://projectsapi.zoho.com/restapi/portal/${portalid}/projects/${projectid}/tasks/${taskid}/comments/?content=${content} |
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 button in Cases module and associating the custom function to it
- Create a button called "Create Task for Case" using the Links & Buttons feature available in the Componentssection of the Zoho Developer console, then associate a custom function to perform the desired action.
Create Task for Case - Button function code
//Fetching the current record details and retrieving the necessary field information response = zoho.crm.getRecordById("Cases",case.get("Cases.ID").toLong()); Name = response.get("Subject"); Name = zoho.encryption.urlEncode(Name); Description = response.get("Description"); Description = zoho.encryption.urlEncode(Description); Priority = response.get("Priority"); Comments = response.get("Internal_Comments"); Comments = zoho.encryption.urlEncode(Comments); dynamic_map = Map(); /*Fetching the values for Portal ID and Project ID CRM variables which are obtained as part of the settings widget*/ portalid = zoho.crm.getOrgVariable("xxx__Portal_Id");//The api name of the CRM variable for Portal_Id projectid = zoho.crm.getOrgVariable("xxx__Project_Id");//The api name of the CRM variable for Project_Id dynamic_map.put("portalid",portalid); dynamic_map.put("projectid",projectid); //Invoking the connector API to retrieve the users present in the project resp1 = zoho.crm.invokeConnector("xxx.zohoprojects.getprojectusers",dynamic_map); response1 = resp1.get("response"); users = response1.get("users"); rolelist = List(); /*retrieving the ID of the user with admin role in the project to be assigned as the person responsible for the task*/ for each value in users { if(value.get("role") == "admin") { id = value.get("zpuid"); } } dynamic_map = Map(); portalid = zoho.crm.getOrgVariable("xxx__Portal_Id"); projectid = zoho.crm.getOrgVariable("xxx__Project_Id"); dynamic_map.put("portalid",portalid); dynamic_map.put("projectid",projectid); dynamic_map.put("name",Name); dynamic_map.put("description",Description); dynamic_map.put("priority",Priority); dynamic_map.put("person_responsible",id); /*Invoking the connector API with the necessary parameters passed to create a project task */ resp = zoho.crm.invokeConnector("xxx.zohoprojects.createtask",dynamic_map); response2 = resp.get("response"); tasks = response2.get("tasks"); //Retrieving the task id from the response of create task API for each ids in tasks { id1 = ids.get("id"); } dynamic_map = Map(); portalid = zoho.crm.getOrgVariable("xxx__Portal_Id"); projectid = zoho.crm.getOrgVariable("xxx__Project_Id"); dynamic_map.put("portalid",portalid); dynamic_map.put("projectid",projectid); dynamic_map.put("taskid",id1); dynamic_map.put("content",Comments); //Invoking the connector API to add a comment to the task response3= zoho.crm.invokeConnector("xxx.zohoprojects.addcommentfortask",dynamic_map); caseinfo = {"Solution":url}; response4 = zoho.crm.updateRecord("Cases",case.get("Cases.ID").toLong(),caseinfo); return resp; |
Note: In our example, the project's administrator is assigned as the person responsible for the task that is to be created in Zoho Projects. We have considered that there is only one admin for a project, who can then assign the task to the appropriate developer.
Obtaining Portal ID and Project ID
According to our example, cases from Zoho CRM need to be associated as a task to a particular project in Zoho Projects. You can find in the above code that the variables Portal ID and Project ID (dynamic variables used in connector APIs) are used while invoking APIs. The values of these variables are specific to a user and thus these values can be obtained from the user during extension installation and stored in CRM variables to be easily retrieved when required.
The variables Portal ID and Project ID are created as CRM variables with the Variable Status as Hidden in the extension.Their values are obtained as follows:
➤ Creating a Settings Widget: We have created a settings widget in our extension in order to retrieve the user-specific portal ID and project ID, and to set the values to the CRM variables.
Settings Widget js code snippet
Util={}; var portalidvalue; var projectidvalue; //Subscribe to the EmbeddedApp onPageLoad event before initializing the widget ZOHO.embeddedApp.on("PageLoad",function(data) { var data = { } //Invoking the connector API to get portals of the user and populate them in a select list ZOHO.CRM.CONNECTOR.invokeAPI("testextensioncrm.zohoprojects.getportals",data) .then(function(dataa){ response = dataa.response; responsejson=JSON.parse(response); portal=responsejson.portals; for (i = 0; i < portal.length; i++) { portalid=portal[i].id_string; portalname=portal[i].name; var portallist = document.getElementById("portallist"); var option = document.createElement("OPTION"); option.innerHTML = portalname; option.value = portalid; portallist.appendChild(option); } }) /*Fetching the projects associated to the portal selected on click of the "Get Projects" button*/ Util.getproject=function() { portalidvalue=document.getElementById("portallist").value; var data = { "portalid" : portalidvalue } /*Invoking the connector API to get projects of the user with respect to the portal chosen and populate them in a select list*/ ZOHO.CRM.CONNECTOR.invokeAPI("testextensioncrm.zohoprojects.getprojects",data) .then(function(dataa){ response = dataa.response; responsejson=JSON.parse(response); project=responsejson.projects; $('#projectlist').empty(); for (j = 0; j < project.length; j++) { projectid=project[j].id_string; projectname=project[j].name; var projectlist = document.getElementById("projectlist"); var option = document.createElement("OPTION"); option.innerHTML = projectname; option.value = projectid; projectlist.appendChild(option); } }) } /*Updating the values of the portal ID and project ID selected in the select list to the CRM variables*/ Util.getvalues=function() { portalidvalue=document.getElementById("portallist").value; projectidvalue=document.getElementById("projectlist").value; var variableMap = { "apiname": "testextensioncrm__Portal_Id", "value": portalidvalue}; ZOHO.CRM.CONNECTOR.invokeAPI("crm.set", variableMap); var variableMap = { "apiname": "testextensioncrm__Project_Id", "value": projectidvalue}; ZOHO.CRM.CONNECTOR.invokeAPI("crm.set", variableMap); }); }); } }) |
Now that the functionality is defined, the extension is published and installed in Zoho CRM account using the private installation URL.
Sample output:
Upon installation of the extension, click the Settings button to go the Settings Widget page, then choose your portal and project where you want the task to be created.
Choose the portal of your choice, then click the Get Projects button to fetch the projects associated with that portal.
Next, click Update Values to set the chosen portal and project ID values to the CRM variables Portal_ID and Project_ID,respectively.
Go to the Cases module. A case of type feature request is present in Cases module.
Click the Create Task for Case button available in the view page of the case detail page.
The necessary details as per the code logic are fetched and created as a task in projects.
The detailed task details page with all the information fetched from the case in Zoho CRM Cases module.
Using this method, you can integrate Zoho CRM and Zoho Projects via an extension and perform functionalities as per your business requirements. We hope you find this information useful. Keep following this space for more inputs!
SEE ALSO
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Nanditha Somasundaram Somasundaram
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 FAQsKaizen #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
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Package Geometry
how can i add the dimensions and weight capacity of the available boxes to be default in the system everytime we use it ?How to create a Master Kanban Board that syncs with Child Projects?
Hello, We're currently using Zoho Sprints for managing our interdepartmental teams, and we're looking to enhance our workflow using Kanban boards as part of a company-wide productivity improvement initiative. Our goal is to implement a project structureWriter.. Broken?
Hello, Writer has been really good to me during the months I've used it, up until now. I usually launch the app by tapping the icon and I could immediately pick up where I left off. Now I'm greeted by a loading circle not reaching 100% and I only have the option to create a new account. By pressing that button it now switches to a login screen and I can access my account. However, it seems (only speculating ofc) to be stuck in cell-phone mode? everything looks scrambled. I can't access any ofHow to access Recruit Variables in a Deluge function?
I have set up Recruit Variables in Zoho Recruit, and I would like to know how to retrieve these variables from within a Recruit custom function (Deluge). Could someone please explain the correct way to access them? I tried the following code, but it didUpon De activate a user what name doe sthe contacts candidates go under?
When deactivating a user, does the user name remain the same, as the candidate owner? If not what/who, does it change to? Do I need to change the user name in contacts and candidates before I deactivate the user?Weekly Tips: Customize alerts from your Priority Users
You might receive hundreds of emails daily, but messages from your manager, clients, or team leads often require immediate attention, as they may contain urgent requests or critical updates. How would you ensure you never miss important messages fromMaximum 100 records in Sheet View is limiting. How can I increase this?
Thanks in advance for any help with this. There was a similar post that showed answered but it did not help with increasing the number of records you see in a Sheet View. Editing in the Sheet View is fast and efficient but I have 3500 records and I needRevenue Management: #3 Revenue Recognition Simplified
In continuation of the previous post on how to compute revenue recognition, let's explore a solution that helps businesses handle real-world complexities. While the Accounting Standards provide a clear framework for recognizing revenue, the real challengeTip #40- Strengthen Remote Support with IP-based Restrictions in Zoho Assist– ‘Insider Insights’
Protecting sensitive data and preventing unauthorized access is a top priority for any organization. With IP-based restrictions in Zoho Assist, you can ensure that only users from trusted networks can initiate remote support sessions. Say your IT teamPush Invoices to Xero Manually
Hi guys, I'm wondering if anyone has wanted to do this and has a workaround or knows of an app that may be able to help with this. I sell B2B and B2C. The customers can purchase on our website or through marketplace, all of which send sales to zoho. TheOpenAI error code: 1010 in a Zobot
Please see short linked screen recording. Insights welcome. Please and thank you! https://workdrive.zohoexternal.com/external/f3247ba9c872639157b707700c0300c433c7664aea924a034f4da3c3ad2e355fAbility to Create Sub-Modules in Zoho CRM
We believe there needs to be a better, more native way to manage related records in Zoho CRM without creating clutter. Ideally, Zoho would support "sub-modules" that we can create and associate under a parent module. Our use case: We have a custom moduleInstalling EMAIL Setup in New Domain
Respected Support team, I'm facing an issue with cloudflare in Pakistan, I want to setup Zoho Mail Setup but I Don't know how to enable Zoho mail setup without cloudflare. My Website https://stumbleguymod.com/ is using CF, and I want a different ZohoDoes Zoho Sheet Supports https://n8n.io ?
Does Zoho Sheet Supports https://n8n.io ? If not, can we take this as an idea and deploy in future please? ThanksSignature change
I cannot see how to change signature or out of office details easily now in the new format.Inventory API - Retrieve all uploaded product / item images
I know that I can get the primary image for each product / item or composite item, by using the /image endpoint. https://inventory.zoho.com/api/v1/compositeitems/<item-id>/image?authtoken=<TOKEN> This will return only one photo, even if the item has multiple images uploaded. Is there a way to retrieve all images stored for an item via the Zoho Inventory API?Ebay Integration malfunction
My eBay integration in Inventory has always worked well. It suddenly malfunctioned. It is creating its own parts in Inventory that are unavailable instead of selling the parts I've always sold. Tech help was unable to resolve this. The latest sale attemptIntroducing Bin Locations In Zoho Inventory
Hello users, We are excited to let you know that your wait for the Bin Locations feature has now come to an end! Yes, you heard us right! We are here to introduce the much-awaited Bin Locations now in Zoho Inventory. But before we dive into the featurehow to get all the records in the custom View more than 200 records , Without using the page Concept
how to get all the records in the custom View more than 200 records , Without giveing page as default in the Loop Concept Pls help how We can Achive this void schedule.Lead_Attempt_To_contact_schedule_10_30() { pages = {1,2}; for each pg in pages { query_mapThe way that Users can view the ticket
I have created users. What I would like to achieve is the following: All users under the same company account should be able to view each other’s tickets.Zoho UAE SMS/WHATSAPP
Hello everyone, so I have a question as regards DC and their impact on automation, integration and app usage. For example I am working with a UAE clientniw but each time I tried to connect their WhatsApp and sms then automate their process I tend to receiveLooking to Flag or Tag contacts/ accounts on Zoho Desk?
I am looking for a way to flag certain accounts and make it obvious on the views pages. So for example if a has a certain package or needs extra attention it is clear before even clicking on the ticket. This could be via adding a tag or flag onto an account,setting date-time field from string
hello everyone, i hope someone could help me. i have a date-time field in a form that i want to fill in from two separate fields of date, and time. i need to combine the two fields to a one date-time field but can make it work. i tried to convert theCalendars and CRM Contacts
I'm finding having multiple calendars in Zoho One so confusing. I have a few questions so I can get this straight. We have a meeting room that we have set up as a resource in Calendar. Can this be set up in Bookings and the CRM Calendar? Using Zoho Calendar,Announcing new features in Trident for Mac (v1.23.0)
Hello everyone! Trident for macOS (v.1.23.0) is here with interesting features and thoughtful enhancements to elevate your workplace communication and productivity. Here's a quick look at what's new. Record your meetings. You can now record audio andApplying a record template
Hi all, I can't figure this out. I hope you can help. The scenario: We have learners who have to complete a 'digital' journal with tasks in order to qualify. Those tasks, once completed, need a final signature from their 'Mentor', which will trigger theirQuickbooks invoice with Zoho Creator
Is it possible to push data from Zoho Creator directly to an invoice on QuickBooks? If so, where can I find information on how to do this?Help: Capture full page URL in hidden field when same Zoho Form is embedded on multiple pages (iframe)
Hi all, Goal Use one Zoho Form across multiple pages and record the exact page URL (incl. subdomain + path + hash) where the user submitted it. Example pages: https://www.example.com/cargo/ https://www.example.com/cargo/containers/#contact https://cargo.example.com/auto/Automatically Populate fields - HELP!
There have been many discussions on this but I still can't seem to get it to work for me. I am trying to create a lookup field and have other fields automatically populate. Based on the instructions in the Help Center, I should be using the "on user input". It's just not working, here is the layout... Both forms are in the same application. Current form is called Add Note, form to fetch records from is called Add Client. Lookup field is called Select_Client_ID related field in fetch form is calledPush notifications to portal users
Hi all, it is possible to send push notifications to portal users?Rename the attachment from record template pdf in the sendmail deluge script
Hello Zoho, I urgently need a feature to rename record templates that I send via the sendmail feature. The program I created sends emails to clients with an invoices that have been created in the invoice database. If the user selects 3 invoice numbers,Alt Text On Multiple Images
I'm using Zoho Social to post to a charity website. Often the posts have multiple images, but it seems there is only one field for Alt Text. Does that mean I can only include it for the first image? Or is there a way to add alt text for all the imag[SOLVED] Getting 401 when trying to download ticket attachment via API
I'm able to use the API just fine to access ticket content. But I cannot download ticket attachment, keep getting 401 Client Error. Example: https://desk.zoho.com.au/api/v1/tickets/{ticket_id}/attachments/{attachment_id}/content?orgId={org_id} For headers,Zoho project – Workdrive integration.
Hello everyone, I was wondering something, we did the Zoho projects integration with Zoho Workdrive but nowhere during this integration we could set the location of the folders that would be automatically created in Workdrive. As I understand it, it createsScriptを埋め込みたくてOn User Inputを探しているのですが・・・
編集モードで、Scriptを埋め込みたい項目を選択し、「項目のプロパティ」パネルで、その下のほうに「フィールドアクション（Field Actions）」という見出しがあると聞いたのですが、そもそも、それが見つかりません。そのために、On User Inputなどのイベントが選べません。 画面の英語を日本語に訳しているためにわけわからん状態になっているのかも知れませんが、わかる方、いらっしゃいますか？Problem with cloud query exceeded
When making a call I get this error, It is associated with a function in node that calls external APIs This is the code //tokenConsultar = thisapp.ObtenerToken(); //input.token = tokenConsultar.get("output").toMap().get("token");Showing Total of Funnel Chart Legend (With Values) Items
Hi, We are using the funnel type chart for displaying our zCRM sales pipeline stages and associated sum of deals in each stage. We have configured the legend to show the associated value (Deal Amount (Sum)) for each stage adjacent to the legend items (Stages). Is there a way to display the total of the values in the same chart? For example, at the bottom of the legend or maybe as a #merge placeholder in the legend title?How to Convert VCF Contacts to CSV using Excel
Many users switch from traditional address books to digital formats like vCard and CSV. These formats allow users to easily manage their contacts. However, a difficulty comes when you need to transfer your contact information to another application orField authorization for Linking module in Zoho CRM portal
Hi guys! Currently building a customer portal for one of my clients, and I ran into a bit of a roadblock while using a multi-select lookup field. The issue is that there is no way to hide or define access in the linking module created by this multi-selectKaizen #63 - Layout Rules in Zoho CRM
Hello and welcome to another week of Kaizen! This week, we will be discussing Layout Rules in Zoho CRM. If you need to modify the layout of a module based on user inputs, or to show or hide sections based on the value of a specific field, we have gotNext Page