Error Code 4: Invalid value passed for JSONString
Okay, I want to start by saying I know I'm a terrible scripter, so sorry if this is a dumb mistake. I just can't figure it out, even with LLM help. Here's my code: // --- Input Variables --- customer_id = salesorder.get("customer_id"); so_id = salesorder.get("salesorder_id");CRM module name capitalisation bug ?
HI, I''m writing a deluge script from Desk to create a task in CRM. All is good when I deal with a lead, but not when a contact is involved. It took me days to figure it out. It might be a bug. Here is a snippet of my script // Ticket Description taskMap.put("What_Id",{"id":ticketContactId});All Deluge environments draggy! Negatively impacting productivity
Hello, I have been using Zoho flow, CRM, Project, etc to develop custom functions, integrations. etc. for over 5 years. However, just about 3 days ago, I observed the deluge integrated environment is now acting draggy across all Zoho products using Chromelist.contains(object) returns null instead of false when list is assigned to null
Consider the following code: list1 = list(); list1 = null; info list1.contains(1); Info returns: null (see attached screenshot) According to the documentation of List.contains(), the only possible return values of List.contains() are true and false. ButI will kill myself
I spend almost a hour trying to figure out why nothing changes and re-running my code. It`s looks like a meme, for real. ✅ Error Successful ✅Deluge integrated tasks not working!
It seems like the integrated tasks of deluge no longer work. We received a couple months ago from support a suggestion to avoid using the integrated tasks and work with the APIs. Today we realized that it's very blurry to understand which integrated taskszoho.currenttime is not working properly
Namaskaram Zoho Books team, we wrote a script to update an date fields based on current time. For that, we using the deluge default function (zoho.currenttime) in the script. It is not taking the current time of login user, literally its taking current time of the script owner (user who wrote the script) not the current login user. Crafted with ❤️ Zoho Gurus | Zoho Books Practice Team @ CubeYogi Zoho Authorised Partner | 8+ Yrs | 200+ Projects | 100+ CustomersIssue with JSON Formatting in invokeURL task
Hello Zoho Community, I'm reaching out for assistance with an issue I've encountered while trying to integrate Zoho with HubSpot using a webhook trigger. Despite following documentation and trying various configurations, I consistently encounter an "ErrorGet data from APIrequest gives null values
Hello, We are facing problem with geting values from CRMAPIrequest. The function was executed when a contract was signed by zoho sign, the data was sent by zoho CRM API rest, and then function was getting recipient email to match the deal and then fillDeluge Custom Function - Product_Details wrong data type when parsing back to Purchase Order
Please note I'm not a deluge expert, but I have attempted to tweak a custom function but seem to be having issues with the last operation. Essential the function should do the following: Get the Quote Details Iterate through the Quote Product DetailsIssues with "Connections" panel
Hello, I have summarized a couple of issues that i think should be fixed with the connections panel (in Zoho Books, Zoho Inventory, etc.). 1. Please don't translate to my browser language. It is completely redundant and and makes it very hard to understandread compressed file in GZ format, Ex. impression-day-2019-01-22.json.gz
We have a file upload on S3 bucket in with .JSON.GZ extension. We are trying to write a script to read that file, unzip that file and then upload it to ZOHO Workdrive. Code is below: ========================================================== zip = invokeUrlSupport Scope in Client Credential grant type
Hello, As Scopes are supported by this grant type, It's useful to have this option (and we need it) in the Create Service form like Authorization Code grant type ThanksMerge and Send
I have a custom function that uses zoho.writer.mergeAndSend it has been working for months and in the past few days it has stopped working is there an issue on the Zoho side that may have caused this? I have tried revoke and reconnecting the connection,Why can't I add an event to my calendar in Zoho Creator/Deluge?
I am trying to build a script using Deluge in Zoho Creator which will create a calendar event in Zoho Calendar when a new form is submitted or an existing form is updated. I am using the Zoho Calendar connection with the following code: response = zoho.calendar.createEvent("<calendar-uid>",Creator + Zoho Sign
Hi All, First off, thank you for everyone's help so far. I am trying to accomplish the following in Zoho Creator: Recall Document & Remind Signer. Both of these functions are not available via deluge so I am trying to use the Zoho Sign API. I believeHow to get data from response?
In deluge I used a simple statement to get a Zoho Sign Document response resp = zoho.sign.GetDocumentByID(XXXXXXX); info resp; I get a response in this format { "code": 0, "requests": { "request_status": "completed", "notes": "", "attachments": [ ], "reminder_period":How to transform file Content-Type from Multipart/form-data to application/pdf ?
Hi, I have a big issue with file content-type during uploading the files into Messagebird server. After successful uploaded into Messagebird server, but the file content-type always in Multipart/form data. But the requirement from Messagebird the Content-TypeError using zoho.sheet.createRecords: There was a problem while trying to integrate with DRE
In Deluge, when I try to use zoho.sheet.createRecords to add to more than 1000 rows, I get this error: There was a problem while trying to integrate with DRE Only some of the data is added to the sheet. The number of rows added varies each time, but itAuto-sync email attachments to tickets - Problem with ANSI encoding
Hello, I discovered the following Zoho tutorial: https://help.zoho.com/portal/en/community/topic/automation-3-auto-sync-email-attachments-to-tickets I have created a function based on the post, which also works BUT there is a problem with the text encodingAssigning Teams to Projects from CRM Function Challenge
We have a function in our CRM that creates a Zoho Project (from a Project Template) when a particular field is updated. I'd like to try and assign teams to the project at that time but I can't seem to make it work. Is this possible and if so can someoneRetrieving Invoices via zoho.crm.getRecordById failing in a deluge function?
Hi, While updating a deluge function in CRM (that creates a corresponding invoice in Books), to use OAuth, it looks like I'm getting { "status": "failure" } at the very start of the function (even the old, working code no longer appears to work). TheHow can I get the payable days from attendance form using deluge what is the label name of form and field?
response = zoho.people.getRecords(form name); what is the query?Zoho
When creating a connection in CRMPLUS to Zoho OAuth, I am getting an "Invalid Operation Type Scope does not" page when connecting. Scopes: ZohoCRM.bulk.ALL ZohoCRM.Files.CREATE ZohoCRM.Files.READ ZohoCRM.functions.execute.CREATE ZohoCRM.functions.execute.READUsing invokeurl to upload files to Google Drive
I'm running into an issue when using invokeurl to attempt to upload files to Google Drive using the Google Drive API v3 When I run the code below I get this error: "Missing end boundary in multipart body" However, I define the boundary string in the header,ifNull and isNull analyze differently
There is a problem where isNull analyzes "" as true, and ifNull analyzes "" as false. Very frustrating considering that there is no support calling your own custom functions. I would right my own corrected version of this function except you have to goZoho oAuth Connection not working
So my Zoho to Zoho app connections have stopped working. They have become "disconnected", anytime I try and authenticate them they work for a couple of seconds and then "disconnect" again. Support suggested I create a new connection and edit every function{"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."}
Hello, Im trying to update my conections with Zoho Creator from V1 to the new. I have a simple update getRecords and updateRecord, but both are giving the same error: {"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."} The code is this way: searchB = zoho.creator.getRecords("roboplan","planeamento-plano-b","Tasks_Report",criteriaB,1,200,"creator"); And creatorB = zoho.creator.updateRecord("roboplan","planeamento-plano-b","Tasks",creatorid,rowDataB,empty,"creator"); I'veFlow Custom Function: Issues retrieving record from Zoho Creator
I am currently trying to write a custom function in Zoho Flow to get record details from Creator. I am not sure it it is a syntax issues or what. I am using the following code to get the records. string getUnitMembers ( int params ) { response = zoho.creator.getRecords("[MyName]","[AppName]","Members_Details","Unit_Number==params"); info response; return response; } This however gives me this message. [ { "message": "There is no records match for this condition" } ] Any ides here? Iupdate milestone status using deluge
one thing that would make projects much cleaner is an option to complete milestones if all task are completed. this would keep the projects clean and focused especially on the mobile app. with that said i have attempted to write a script in deluge to check for all task completed and then update the milestone to completed. i am using the function zoho.projects.updated located here: https://www.zoho.com/deluge/help/projects/get-record-by-id.html i have also referenced the api guide on parameters toGetting Zoho Sign fields for CRM
Using Zoho Sign with a custom module, so can't use the extension. Use a webhook and Flow to send the sign doc with the default value of the fields set. When a document is signed, I want to check the completed fields in the signed document against the CRM fields. Seems relatively straight forward.... apart from my deluge skills just aren't quite good enough. I can get the data using zoho.sign.getDocumentByID. I can see the data I want, but I don't seem to have the skills yet to extract the fieldProblem at the time of copying data from Parent Module to chiled one
Hello I have customized the default function "Mass update of Child Contacts" to copy some fields from Parent Module Leads to child Module Message. We have an structure where one Lead (Email, type) may have many messages, one per (email,Type) combination is contacting us. I am trying to move some details from Lead to the message, so we can generate some automation based on those fields. But I am getting below error: 'TEXT' can not be cast to '[BIGINT]' for the function 'get'at lineNumber 14 The codeDatetime and timezone not being changed in function
Hi, I have a datetime field that I'm storing in one of my custom modules. In a custom function, I take that datetime (called tourDate) and try to convert it a String in the US/Central timezone (looked like it comes into the function as a UTC datetime since it shows as 5 hours ahead of me after formatting) like below: tourDate = tourDate.toString("yyyy-MM-dd hh:mm:ss a z","America/Chicago"); I'm noticing two problems after doing that. First, a tourDate that I schedule in my module as May 20, 2019Our return in functions in buttons give white window
Starting yesterday our returns in functions in buttons are giving a white window. Do anyone knows if something has to change now with the API 2.0? Here is the piece of code: if ( input.proy == "" ) { return "Message 1"; } else { return "Message 2"; }
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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 Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
[Integration edition] Deluge learning series - Integrations between Zoho apps and Third-party services with Deluge | 28 August 2025
We’re excited to welcome you to the Deluge learning series: Integration edition! The Integration edition will run for three months: Session 1 – Integrating Zoho Apps with Deluge using inbuilt integration tasks Session 2 – Integrating Zoho Apps with Deluge[Webinar] Deluge Learning Series - Deluge Learning Series Built-in Functions in Deluge
We’re excited to welcome you to the next session in our Deluge Learning Series – Built-in Functions in Deluge – Part 1. In this focused 1-hour live session, we will explore the practical use of built-in functions in Deluge scripting, with a spotlightDeluge security enhancements
Hello everyone, At Deluge, security is a top priority, and we're continuously working to enhance the platform's safety and reliability. As part of our ongoing commitment to secure coding and industry best practices, we're rolling out key updates to howIntroducing the FTP task in Deluge
Hello everyone, We're excited to announce the launch of the FTP task, a powerful addition to Deluge that enables you to effortlessly transfer files between various Zoho apps and your own servers. Unlike the invokeUrl task, which supports various HTTP[Webinar] Deluge Learning Series - AI-Powered Automation using Zoho Deluge and Gemini
We’re excited to invite you to an exclusive 1-hour webinar where we’ll demonstrate how to bring the power of Google’s Gemini AI into your Zoho ecosystem using Deluge scripting. Whether you're looking to automate data extraction from PDFs or dynamically
Most Discussed Topics
What's wrong with this COQL?
What's wrong with this COQL? Code returns "invalid operator found". SELECT id, Name, Stage, Account, Created_Time, Tag FROM Production_Orders WHERE (Account = '4356038000072566002' AND Stage NOT LIKE '%customer%') ORDER BY Created_Time DESC LIMIT 200
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Function #41: Sync Associated Subforms!
Welcome back everyone! The last custom function showed how to update a Contact with Product details from it's Related list in Deals. This week, let's look at a function that lets you update subform records in two modules simultaneously when one of them is updated. Business scenario Let's look at how subform helps in an education institution that has deployed Zoho CRM. National Public School, Austin (made up, of course!) has set up Zoho CRM and it follows the same relationship pattern of "Students",
Top Contributors
Ashwin Vishal R
Ken
Sunderjan Siddharth
Matthew R
Joe Sweeney