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.
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
UPS API
I am fairly proficient when it comes to creating deluge scripting to assist between Zoho CRM and Zoho Creator, but I do not work outside of the Zoho family often. I am trying to pull the tracking status from a UPS tracking number into our CRM environment.
How to delete an uploaded file through the files API?
Hi, I'm using the files API (https://www.zohoapis.com/crm/v6/files) to upload images to my Records. When I delete a record through the API I'd also like to remove those linked files/images. In the CRM API docs I don't see any API endpoint to delete files,
Kaizen #43 - Tokens and Limitations
Hello everyone! Welcome back to yet another post in the Kaizen series. This week, we will discuss the usage of tokens in authorizations and their limitations. Tokens in OAuth 2.0 Zoho CRM employs the OAuth 2.0 authorization model to authorize its API requests. Grant token, access token, and refresh token are the three major components that play an important role in the authorization process. Initially, the user needs to register a client with Zoho CRM. After registration, the user can generate
Making a Lookup field in Subform as Read only through Client Script
Hi I want to know how can i make a lookup field(ookup to Products) in a subform on Deals module as Read Only on a Stage through Client Script in Zoho CRM. I was able to make the other fields as Read only but was finding issue with the Lookup field. Can
Zoho CRM Python SDK 2.1 won't update record owner
When I try to change the owner on a Zoho record for my website APKBEB, I get a success message but the Lead Owner field doesn't change. The record is in the "Potentials" module (I think it's a custom module) lead: Record = self.get_lead(int(lead_id))
Webhook when an Entity is restored from the Recycle Bin
I have webhooks successfully setup for communicating with another system when an entity such as a Deal changes and gets deleted. Is there any way to also get a notification if something that got deleted by accident comes back from the Recycling Bin? I
Kaizen #138 - How are Widgets used in Zoho CRM Settings?
Hello all! In last week's Kaizen, we covered the Lead Conversion using Zoho CRM APIs. This week, we will dive into how widgets on the setup page can be helpful. What are Widgets? Widgets are embeddable UI components that you can create and add to your
Kaizen #128 - Circuits in Zoho CRM - Part 3
Hello everyone! We are back with yet another post on Circuits in Zoho CRM. In our last week's post, we discussed a use case, the various states and functions involved in that circuit, testing and execution, and associating that circuit with a workflow.
Fetch Jobs from ServiceM8 and Create Leads in ZOHO CRM
Hi, I am trying to get all the jobs from ServiceM8 to create them in my ZOHO CRM Leads module through deluge using API. when I use the API like this response = invokeurl [ url : "https://api.servicem8.com/api_1.0/jobcontact.json" type : GET headers: header_map
Kaizen #137 - Lead Conversion using Zoho CRM APIs
Leads represent potential sales opportunities sourced from various channels like trade shows, seminars, and marketing campaigns. When a Lead shows promise, you can convert them into Accounts, Contacts, and Deals. Imagine you have a Lead named Pat Boyle
Custom Field in Sales Orders items
These adult_qty and child_qty fields, how to populate them from Zoho CRM REST API.
API - Updating a pipeline on a record
It's evidently impossible to update the pipeline of a record programmatically with the API. Here's what I tried: curl "https://www.zohoapis.com/crm/v2/Deals/#########" -X PUT -d "{ "data": [ { "Pipeline": "Sample Pipeline" } ] }" -H "Authorization: Zoho-oauthtoken
Looking for someone to help us
We need to create a connection between Zoho CRM and an accounting system. The description of the accounting system that I have at the moment is that it Freedom. Running a JET database engine. Operating in an SQL environment. I suspect someone might need more information. The needs are very basic. The periodic updating on basic sales data into the associated records in ZoHo CRM. We are looking for someone who is experienced and fully competent at creating this linkage. We are assuming this would
when Whatsapp field then send sms
we have clients that dont have whatsapp. can make a workflow/function, that will send whatsapp massage, but if it fields then it will send sms massage?
any way to get records count in the module through CRM API ?
Hi, is there any way to get records count in the module(s) through CRM API without fetching all the data from the module ? Prior to fetch data from the module (for example via getRecords call) I need to know records count using CRM API (not account UI).
How to get email body using Zoho CRM API or Node JS SDK
Hi Team, I'm building custom zoho crm widget using Node JS SDK. In that application I want to show contact related emails including the email body. I'm using get related records to get contact related emails, but it only contain the message id, subject
Built-in Website Field is not correctly checking for duplicates in the API
While executing an upsert (https://www.zohoapis.eu/crm/v6/Leads/upsert), setting duplicate_check_fields to ["Website"] is not always working and, for some records, inserts another identical record. Creating another field of type "single line" and checking
Remove user tag in notes when copying a note
I am copying the notes from a custom module, to a main account in zoho crm. When I copy the notes the tags are coming too. is there a way to remove it or put the name of (user/group) without tagging it. Deluge code RelNotes = zoho.crm.getRelatedRecords("Notes",'Work_orders',recID);
ZOHO COQL query bug
Hi Zoho team! I found a bug in your COQL handling. please have a look at the query I am sending to the COQL endpoints: https://www.zohoapis.com/crm/v2.1/coql OR https://www.zohoapis.com/crm/v4/coql "select Potential_Name.Deal_Name,Potential_Name.id FROM
Next Page