Fetch extra products data from invoice in one query with invoice record
Hello, community Is it possible to fetch extra products data from invoice in one query with invoice record? With /crm/v6/Invoices/{some_invoice_id} we could get Invoiced_Items with some products data in Invoiced_Items field If we need extra data we should
Invalid OAuth Token
Hi, I'm currently attempting to retrieve Contacts field metadata for testing as documented here: https://www.zoho.com/crm/developer/docs/api/v7/field-meta.html At https://api-console.zoho.com/, I have created a Self Client application, and generated a
Message Id of emails from IMAP is not the same as Gmail's message id
Hi, I'm working in deluge functions that get all emails of a module (zoho.crm.getRelatedRecords("Emails","Contacts",contact_id,1,200,{"type":5});), but the response message id of the email is not the same as Gmail's message id, Can you explain to me why
Chronic Bugs in their search API
Hi, I'd like to hear from other developers who are having problems using the Zoho CRM API. Very simple things, universally accepted search practices, simply don't work in the Zoho API. For instance, If you have a CRM Account with the name "My__Account"
Kaizen #184 : Using Widgets in ZET CLI and ZDK CLI
Hello all, Welcome back to the Kaizen Series! ZDK CLI is a set of command tools that you can use to manipulate Zoho CRM metadata including widgets. ZET CLI helps developers build and package widgets in Zoho CRM. In this Kaizen post, we will explore using
How can i get parameters using Zoho Widget?
I would like to know how I can pass parameters (for example: the ID of a financial proposal), to a Widget? I intend to host the widget externally, however I need to obtain the Proposal ID so that it can react dynamically.
Automate Zoho CRM Export to pdf
Is there any way to automate through Deluge or another language the 'Export to PDF' or the 'Send Email' task? When the individual in charge of invoices marks the invoice as 'Finished', there would be a process enabled to download the PDF or email the
Unable to create custom functions in Node.JS / Java in Zoho CRM
Pretty much the title I'd like to create Node/Java functions to automate and process some actions. Done that in Deluge but I would like to switch. The docs say there's a way, but the cold reality of using CRM through Zoho One with org/app admin rights
False Positive Responses When Creating Leads via API
I’ve integrated my website with Zoho CRM to create Leads when new accounts are registered. However, some users aren’t being created as Leads, even though the API returns a success response. I added error logging, but these missing Leads don’t appear in
Querying COQL Multi-Select field
Hello, I added to the Price_Books module 2 simple multi-select fields: Countries and Devices, and a few other fields. I tried the following COQL queries: select id,Price_Book_Name,Active,Countries,Devices,Link,Created_Time from Price_Books where Countries
Kaizen #183 - COQL API's Enhancements in Zoho CRM API Version 7
Hello everybody! Welcome back to another post in our Kaizen series. In this post, we will discuss the latest COQL API enhancements introduced in Zoho CRM Version 7. COQL API Query API lets you query for records based on queries using the CRM Object Query
Custom Module missing SDK function fetchRelatedRecords(...) in a Client Script
Good day, We have added a new module with a Multi-Lookup relation to Contacts. When we tried to use the fetchRelatedRecords(id, related_list_api_name) function to get Related Records it is missing for our new custom module. https://js.zohocdn.com/crm/5124797/documentation/DotSDK/Modules.html
Kaizen #126 - Circuits in Zoho CRM - Part 1
Hello everyone! Welcome back to another week of Kaizen! Today, we will discuss an exciting topic—Circuits in Zoho CRM. For starters, we will discuss what Circuits are, how beneficial they are for businesses, different views of a Circuit, and the different
Client Script field.setCriteria need the list of possible operators for criteria or the opposite of "equal"
The gist is to just filter the lookup the countries not listed in the multiselect field. I've been using a client script and this time I would like to set this criteria for the lookup: op.setCriteria("((Specialty_Requirement:equals:" + spec + ")and(Countries_Excluded:not_equal:"
CRM Quotes- Delete tasks when status is changed
Hello. We have our quotes setup for approval process. We would like however to delete the tasks that are made when a different quote stage is selected. So when a quote stage is setup for "sent for review" we have the automation process to send out an
CRM
I have a portal set up where a contact can see other contacts within an account automatically. When a contact in the portal enters a deal, how do I make sure that deal is assigned to the account so other contacts in the account can see the deal was generated?
Merge field support in Field Update
Hi, We have a use case that requires values of certain custom fields in Deals to be copied back to corresponding custom fields in Contacts module whenever those fields are changed in Deals. The field update action on Workflow rules doesn't allow specifying
Circuite fail because www.zohoapis.com:443 refuse conection
Is anyone else experiencing this issue? A few weeks ago, I started having issues with circuits failing due to www.zohoapis.com:443 refusing the connection. The error message is quite clear and points to a problem on Zoho's API server, rather than with
Picklist reference value in REST
picklist options can be configured to have a different reference value than the displayed one, should be helpful in things like multilanguage: https://help.zoho.com/portal/en/kb/crm/customize-crm-account/translations/articles/translations is there a way
Custom Related List anchor tag with tel protocol
The following code worked great for about a year to create clickable tel and mailto links in a related list in the Deals module. Just this morning, it started displaying the HTML as text. For example: <a href='tel:8882490100'>8882490100</a> Zoho support
Kaizen #182 - Queries in Canvas List View
Hello everyone! Welcome to another week of Kaizen! We're back with another post in this series on Queries in Canvas List View. Queries in Zoho CRM allow you to dynamically retrieve data from CRM as well as third-party services directly within the CRM
Issue with Zoho CRM DELUGE Search – No Results Returned
Hi, I’m trying to run the following code, but it returns nothing. I have 4 records where the Next_Date field has the value "OK". I tried changing the date format to different types, like "2025-01-01", but I still get no results. Can you help me understand
Problem with currency field in Zoho CRM
Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration
Levenshtein Distance in Zoho Deluge (Because Why Not?)
Ever wanted to run a Levenshtein Distance algorithm inside Zoho Deluge? No? Me neither, but I did it anyway. I built a fully functional fuzzy matching system inside Zoho, brute-forcing a dynamic programming solution using Maps and recursive list generation.
Difference between the 'field_read_only' and 'read_only' fields exposed by the Fields Meta Data API.
The API documentation describes the 'field_read_only' field to indicate that a field is read-only always, implying that no user can ever get the write access for this field. The 'read_only' field's description states that its value can change depending
ZOHO CRM API Python SDK Convert Quote to Sales Order
I can see footprints that this may be possible through Inventory Conversion. But I am unable to locate any specific details or samples on how to do this. I am using the most current Python SDK. Any support or even sample code would be much appreciated
Kaizen #181 - Mandating Subform Data for Blueprint Transitions using Widget
Hello Developers! Welcome back to another week of Kaizen! This time, we are tackling a common challenge on how to enforce subform data from a different module before allowing a blueprint transition in Zoho CRM Deals module. Many CRM workflows require
Client Script $Crm.user.role returning undefined
Hey all! I have a client script I'm trying to run based off of the user's role. I'm able to use the following: var fname = $Crm.user.first_name; To properly return a first name when logging in the console, but whenever I try the same with $Crm.user.role
brackets to be used in COQL's Where.
I use version 7 COQL to get Deals. It seems that I need to properly enclose the criteria in brackets in the Where, but I don't know the criteria to enclose them. I need to specify quite a few criteria in Where, so I would like a clear explanation. I am
Kaizen #2 - OAuth2.0 and Self Client #API
Hi everyone! Welcome back to another week of Kaizen! In this post, we will shed some light on the OAuth2.0 protocol and how you can use Zoho's Self Client option to authenticate your application and generate the tokens. What is OAuth2.0? OAuth 2.0 is an industry standard protocol specification that enables third-party applications (clients) to gain delegated access to protected resources in Zoho via an API. Why should we use OAuth2.0? Clients are not required to support password authentication or
Kaizen #91: Dynamic Lookup filters using Client Script
Hello everyone! Welcome back to another captivating Kaizen post. In this post, we will explore the process of implementing lookup filters using Client Script. What is a dynamic lookup filter? A dynamic lookup filter is a feature that allows you to specify
setVisibility() not working for Subform Fields with Client Script
I am currently working on a Zoho CRM Client Script involving a subform and encountered a limitation that hinders my ability to fully control the visibility of specific fields within subform rows. The setVisibility() method, which works perfectly fine
Does Client Script work on Zoho CRM Portal?
Hi ! I create a new module to use at customer portal. But Client Script looks not work. Please help me clarify, thank you!
Authorization Issue While Fetching Items from Zoho
I am facing an issue while retrieving items from Zoho. The error message states that we are not authorized to perform this operation. We have tested this with different domains as well as with different Data Centers, but the issue persists. Despite ensuring
Canvas Blueprint - Refresh/Reload Section
I have a blueprint on a Detail canvas in CRM. When one of the blueprint buttons is pressed, the blueprint actions take place as normal but the actual blueprint options on the canvas dont change until the screen is refreshed. This doesn't happen when in
View As <Profile Name> for development
It would be great if we could have the ability to view a CRM as a particular profile other than the one that's assigned to the user account. Unless this feature already exists, we could quickly switch between profiles to validate field and module permissions,
Kaizen #180: Automating Data Transfer from Zoho Sheets to Zoho CRM Subforms
Hello everyone! Welcome back to another exciting Kaizen post! This time, we will discuss the solution for a use case—leveraging Client Scripts and Functions to get the job done efficiently by integrating with Zoho Sheets. In this kaizen post, Handling
Meeting schedule proposal
We are currently working on creating meeting invites for Outlook through Zoho Deluge. However, we have encountered an issue when a client sends a proposal for a new meeting schedule. In this case, we are only receiving the status of whether the client
Form and CRM Email Template url processing and/or prefill broke
Hi All, I have an open ticket with Zoho support on this, but it's so urgent I hope I can get help here, too. Today something in the Form data collection url processing broke and there were zero changes made by yours truly that touched any part of the
Has Anyone Else Built a State Machine into a Function?
I'm in the process of building a state machine for lead lifecycle management within Zoho CRM, and I'm curious if anyone else has tried integrating a state machine into their Deluge functions, especially considering Zoho’s 12-function cap. I’ve managed
Next Page