Kaizen #53 - Sales Orders #API
Hello everyone! Welcome back to another week of Kaizen. In this post, we will discuss inserting, updating, and deleting a Sales Order via an API. What is a Sales Order? A Sales Order is a document sent to your customers to confirm the items and prices of a sale. It is usually created after a quote is accepted by your customers, and your items are ready to be shipped or delivered to them. Getting a Sales Order Use the Get Records API to get the record(s) from the Sales Order module. Request URL: {api-domain}/crm/v2/Sales_Orders
Multiline Rich Text Field truncates when used in a Related List
Hi all I am trying to use a Multiline Rich Text Field in a custom module to display note type information in a related custom module. It appears that there is some character limit (around 500) that limits the display of the field content as compared to
Kaizen #144 - Assigning values to different field types using Zoho CRM SDKs - Part II
Welcome to another week of our Kaizen series! In our last week's Kaizen post, we explored the various field types in Zoho CRM and their typical uses. We also discussed the utility of our SDK sample codes available in our GitHub repositories and how they
Problem with default value by using Bulk Write API
Hi guys, I have a problem with the bulk writing API. I have 2 modules. First module ("dataimport") is storing csv file uploads of users. The secound module ("Erzeugungsdaten") should store the data from those csv files. My goal is that each entry in "Erzeugungsdaten"
How to use COQL in Zoho CRM's Client script
Hi Community & Zoho Team, Can any one help me with the code for the below scenario. I need to get the records counts in Invoice module with applying two filters. 1) Mailing State = "Given State" 2) Invoice Date is Greater than "01-June-2024" I expecting
OAUTH_SCOPE_MISMATCH when attempting to find CRM User Record
In my App, I want to look for records owned by a Zoho CRM user. Therefore, I am attempting to find the relevant CRM user details for the logged in Creator App user. The lookup I am using is: userEmail = thisapp.permissions.loginUserEmailid(); userDetails
Security in zoho crm when using credit card info
Hi! In order to make online payments through zoho crm, I created a new kiosk with some input fields (card number, exp date, cvv ecc). Then, the information is sent (through an envokeURL function I created using API) to an external service that manages
error. undefined in Send Email Rest API on Zoho CRM
Hi, I've got a problem with sending an Email to new Leads that are added to the CRM. After creating connection in Make, I had an issue with the permission scope, but fixed this with manually adding scopes to second connection. But now, after trying to
Don't get Bulk Write API to work
Hi everyone, I'm facing current problem. I have csv files (+500 row) which I push into a custom module (each row is one entry). I thought its a good idea to use the Bulk Write API (https://www.zoho.com/crm/developer/docs/api/v6/bulk-write/overview.html)
Help needed with COQL query
Hi all, I'm facing an issue with the v2 COQL query. Can someone resolve the issue? Query select Dossier, Status, Toekenning_startdatum, Toekenning_einddatum, Created_Time from Bijzondere_bijstanden where Dossier in (640049000000603044,640049000000550726)
Get "un"related records function ?
I have a multiselect in Products to relate products to accounts. I use a custom function to relate them automatically based on a field. What I need to know is which products are unrelated to accounts. I can use getRelatedRecords to get the ones that are
Kaizen #143 - Assigning values to different field types using Zoho CRM SDKs - Part I
Welcome to another week of our Kaizen series! Today, we will discuss a critical aspect of working with Zoho CRM SDKs across various programming languages: assigning values to fields of different data types. Zoho CRM offers a comprehensive suite of SDKs
Website form want submit data show in zoho crm using api
I have a website in php i want some one fill out the form it show in zoho crm
I can't get if notification exists
Greetings. Thanks in advanced for your help. I am trying to make a request to the CRM API to find out if a notification exists by passing a channel ID as a parameter. All requests end with Bad Request. Here is my request https://www.zohoapis.com/crm/3/actions/watch?channel_id=10000000810244
how can I search mobile number of a record in all the MODULES (contacts and leads) using API and now making a call for every MODULE
hi I want to add new records to the lead MODULE, but I want to ensure that there will be no duplicates. I plan to use the mobile phone to check for it but I didn't find any way to search in 1 API call in all the MODULES. is there a way to search all the
Zoho CRM API Error AUTHENTICATION_FAILURE "Authentication failed"
I am trying to integrate a web app with the Zoho CRM API. Following the instructions in the API docs, I did the following steps: 1) Went to Zoho Developer console (https://accounts.zoho.com/developerconsole) to register my client application. It is a
Help with search record API
Greetings, thanks in advance all your help. I'm consuming the records API, specifically this endpoint https://www.zohoapis.com/crm/v3/contacts/search?email=thunderroy2013@gmail.com with these scopes: ZohoCRM.modules.contacts.ALL ZohoCRM.modules.leads.ALL
Associate SalesIQ visitor with lead created via REST API (PHP SDK)
Hello, I am working on a website that has SalesIQ embedded into it. This site also has some custom forms. Behind those form submissions, we are using the PHP SDK to create Leads in Zoho CRM. This is all working, however the "Visit Summary" is not being
Workflow Rule Triggered by a specific date
I'm struggling to find a script that will allow me to create a workflow rule that will send out an automatic email when all conditions are met on the 28th of every month.
Kaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script
Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.
How to read large text files in GB from S3 Bucket?
We need to use an S3 Lambda function with Python or any supported language code to divide the file into small chunks that can be read by Zoho using Zoho Deluge. By doing this, all the large files can be processed and the data can be pushed into Zoho.
Client Script: Undocumented new function/feature or it's a work in progress?
So I recently found out about client scripts and while messing around in Zoho CRM and in the client script editor when referencing a Field type, two of the available functions shown in the auto completion dropdown are .getSuggestions() and .addSuggestions().
How can i add a custom text in related list?
I'm trying to add static text to a related list in the Deals module. I tried to do this using deluge but it doesn't work. I did a small test but it didn't work. Basically I want to insert a sales script in text so the salesperson can consult it. Desculpe,
Wrong cache in API method searchRecords
Hi there. I found mistake on API method https://www.zoho.com/crm/help/api/searchrecords.html After changing the lead, I still get as a result of some time with changed lead (it no longer fits the search criteria and stores a field with a modified value). For example: Lead#1 (MyCustomField=aaa), Lead#2 (MyCustomField=aaa). Request: https://crm.zoho.com/crm/private/json/Leads/searchRecords?authtoken=AuthToken&scope=crmapi&criteria=((MyCustomField:aaa)) Result: Lead#1 (MyCustomField=aaa), Lead#2 (MyCustomField=aaa). -
Cannot get Image Upload to Work
Here is the code I'm using to grab an image and load it to a specific field called Image in a module called Property Pictures: photo = invokeurl [ url :"https://cdn.britannica.com/79/232779-050-6B0411D7/German-Shepherd-dog-Alsatian.jpg" type :GET ]; info
Issue Fetching Data Zoho API
I am trying to fetch these records using zoho api but it returns only first 10 records, but there are 24 of them that can be accessed by pagination This is the url https://www.zohoapis.eu/crm/v3/Matter_Categories/547619000000662695?fields=Solicitors and
Need help regarding the token refresh time
Hello! I have a website where a costumer can book himself a meeting via Calendly. Once the meeting is booked the costumer information is sent to the Zoho CRM and a lead is created. My website is hosted on Heroku and the Zoho CRM token which i need in
Client Script: Edit page onChange doesn't fire when selecting "-None-" value.
I have a client script using the onChange event on the standard edit page that updates another field based on value selected in a pick list. This works great except I just realized when you select the "-None-" option in the pick list if you wanted no
Same function in multiple schedules
Hi, I need to use the same custom function in multiple schedules. I am passing in the last_schedule datetime which will determine what happens in the function, but I want schedules for multiple days and times. The schedule is for sending reports, so I
Kaizen #141 - Zoho CRM's API Collection in Postman
Hello everyone! Welcome back to another week of Kaizen! In today's post, we will discuss: What is Postman? Zoho CRM's API Collection in Postman Where is it available? Prerequisites for using the collection Forking the API Collection from Zoho CRM Developer
Add options to a picklist without going to the Modules and Fields
I've been working on simplifying the CRM interface with Wizards and Canvas views. Now my users are asking if they can add a new option to a pick list from the Canvas view and Wizards. I can't find any info that gives me the ability to do this in a function.
Write in the Voice Recording field in the calls module via API
Hello, The Voice Recording field in the calls module is a nice little improvement but it would be far more practical if it was possible to populate it via API rather than manually. Thx for considering it !
Get Records Request Pagination problem with Notes - TOKEN_BOUND_DATA_MISMATCH
My first get request for the Notes table works fine, but when I grab the "next_page_token" from the first Json response and pass it in my request for the second page as "page_token", I get the following error: { "code": "TOKEN_BOUND_DATA_MISMATCH", "details":
Issue with developing CRM widget
Hi all, I'm experiencing an issue with Zoho CRM widget development for our customer. The following occuers: Every account in CRM has multiple underlying modules with data. For a dashboard I want to load this data with a search query on de JS SDK. Example
Custom token persistence - Python SDK
Hallo, Python-SDK version 6.0 https://github.com/zoho/zohocrm-python-sdk-6.0/blob/master/versions/5.0.0/README.md#custom-persistence How can I get can I get CustomStore token persistence to work? I have used FIleStore before with no issues, but I would
getRecords - 200 records at a time limitation - how to handle this - looking for a source code example
Hi all, Just wondering if anyone has put together the 'buffering' logic, or looping logic, needed to deal with the limitation that you can only pull 200 CRM records via the API at a time...which is obviously an issue when you have more than 200 records in your CRM. Has anyone looked at this in detail, and written the deluge script to handle it? Anyone from Zoho volunteer a solution? I think it's tricky (or at least cumbersome) without a Repeat/Until type statement for even a traditional 'For Loop'.
ZOHOCRMSDK-6.0 Token issue
Hi I get an error regarding tokens when want to retrieve a record. i have a class constructor which contains this : new SDKInitializer.Builder() .Environment(environment) .Token(token) .Store(tokenstore) .SDKConfig(config) .ResourcePath(resourcePath)
How to set DateTime value to blank via Python SDK
I want to clear a previously set datetime custom opportunity field in Zoho CRM using python SDK 2.1 (3.0.0) The following fails with a TYPE_ERROR: deal_record.add_key_value('myfield', None) The following fails with "Invalid date format string (too short):
Kaizen #139: Using Functions in Client Script and Handling Timeouts
Hello everyone! Welcome back to another interesting Kaizen post. In this post, we can discuss how to invoke Functions using Client Script and how to handle Timeouts in Client Script. This post will answer the question raised in the post, Why Client Script
CRM function REST API response format
Is there a way to control the JSON response returned by the CRM function REST API? If I call a function using either OAuth or an API key it returns a 200 OK response with a string in the format shown below. I am using a particular feature of an external
Next Page