ZoHo Flow Custom Function not Processing JSON

ZoHo Flow Custom Function not Processing JSON

JSON is being escaped and converting all the quotes in the JSON to '"' 

Here's the Code: 
void InsertRowInE123EligibitySheet(map input)
{
rawData = get("data","");
decodedData = rawData.htmlDecode();
data = decodedData.toMap();
sheet_id = "ID GOES HERE";
worksheet_name = "SHEET NAME GOES HERE";
row_data = Map();
row_data.put("Agent ID",data.get("Group ID"));
row_data.put("Unique Identifier",data.get("Member ID"));
row_data.put("Corp ID",data.get("Corp ID"));
row_data.put("Product Code",data.get("Product Code"));
row_data.put("Product Subcode",data.get("Product Subcode"));
row_data.put("Active Date",data.get("Active Date"));
row_data.put("Record Code",data.get("P_Record_Code"));
row_data.put("First Name",data.get("P_FirstName"));
row_data.put("Last Name",data.get("P_LastName"));
row_data.put("Address 1",data.get("Address 1"));
row_data.put("Address 2",data.get("Address 2"));
row_data.put("City",data.get("City"));
row_data.put("State",data.get("State"));
row_data.put("Zip Code",data.get("Zip"));
row_data.put("Email",data.get("Email"));
row_data.put("Phone Number",data.get("Phone"));
response = zoho.sheet.createRecords(sheet_id,worksheet_name,row_data);
info response;
}

Function Execute Test: 
Sample Data: 
{
"Group ID": "1234", 
"Corp ID": "1552", 
"Product Code":"434314", 
"Product Subcode":"43442",
"Active Date":"01/01/2025",
"P_Record_Code": "1",
"P_FirstName": "John",
"P_LastName": "Smith",
"Address 1": "fsdfsdfsd",
"Address 2": "fsdfsfsfd",
"City": "fdsfsdf",
"State": "fdsfsdfdsfs",
"Zip": "12345",
"Phone": "1231231234"
}

ERROR when testing the Function Execute
"Value is empty and 'htmlDecode' function cannot be applied at line number 4. Resolve the errors and try executing it again"

Flow Custom Function Input: 
{
"Group ID": "${trigger.SingleLine4}", 
"Corp ID": "1552", 
"Product Code":"${var_product_id}", 
"Product Subcode":"${setVariable_25}",
"Active Date":"${trigger.Date3}",
"P_Record_Code": "1",
"P_FirstName": "${trigger.SingleLine7}",
"P_LastName": "${trigger.SingleLine8}",
"Address 1": "${trigger.SingleLine13}",
"Address 2": "${trigger.SingleLine14}",
"City": "${trigger.SingleLine15}",
"State": "${trigger.Dropdown7}",
"Zip": "${trigger.SingleLine16}",
"Email": "${trigger.Email}",
"Phone": "${trigger.PhoneNumber}"
}

Testing Input: 
o

{
   input : "{ "Group ID": "123456",  "Corp\nID": "1552",  "Product\nCode":"46523",  "Product\nSubcode":"9376", "Active\nDate":"01/01/2025", "P_Record_Code":\n"1", "P_FirstName":\n"Christopher", "P_LastName":\n"Anderson", "P_DoB":\n"No", "P_Gender":\n"M", "P_SSN":\n"231-23-1232", "Address 1":\n"771 Outlook Dr", "Address 2":\n"", "City":\n"Ponte Vedra", "State":\n"Florida", "Zip":\n"32081", "Email":\n"chris.anderson70@gmail.com", "Phone":\n"19046379244", "Smoker":\n"No" }"
}

Testing Output: 
"Value given for the variable 'input' does not match its type due to invalid JSON format at line number 1. Resolve the errors and try executing it again"





        • Recent Topics

        • Good news! Calendar in Zoho CRM gets a face lift

          Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activities

        • New Enhancements in Wizards

          Dear All, Wizards help you break a long form into a series of smaller forms on different screens, making it less overwhelming. We are thrilled to introduce a couple of enhancements to wizards in Zoho CRM: Enhancements for conditional rules in Wizards

        • Microsoft Teams now available as an online meeting provider

          Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings

        • Find and Merge Duplicates to trigger webhook

          My sales team uses the Find and Merge Duplicates feature often to cleanup records in the CRM. We use webhooks to signal to our internal tools database when new Contacts are created, updated, or deleted, in order to keep our DB in sync with Zoho CRM. However,

        • Charting the 2025 Voyage: Zoho Invoice's Year in Review

          2025 has been a year of progress, productivity, and purposeful growth for Zoho Invoice. From expanding into new regions to refining everyday workflows, each update was designed to help businesses stay compliant, get paid faster, and work with confidence.

        • How to Hide System-DefinedTemplates in Service Report

          Is there any option available to hide system-defined templates? these templates are causing confusion for field users.

        • WhatsApp Report in Bigin CRM

          Reporting feature for Bigin CRM’s integrated WhatsApp that provides insights such as: Number of WhatsApp conversations closed Number of messages sent and received Number of conversations replied to Response and closure metrics for WhatsApp chats More

        • Auto tracking URL generation based on Carrier

          Hi, While creating a shipment order for a package in Zoho Books, I have a requirement that for example, if the carrier is Delhivery and tracking number is 1234, then can automatically the tracking link/URL be generated as www.delhivery.com/1234. Similary,

        • Issue with Azure DevOps Integration in Zoho Flow

          Hello, All workflows between Zoho Flow and Azure DevOps have stopped working for several days now. Upon further investigation, it seems that the connection to Azure DevOps is no longer directly supported. Indeed, Microsoft has deprecated the Azure DevOps

        • Contacts per department

          Hello, Is it possible to limit Contacts to a Department? Thanks

        • How to install Widget in inventory module

          Hi， I am trying to install a app into Sales Order Module related list, however there is no button allow me to do that. May I ask how to install widget to inventory module related list?

        • Narrative 16: Simplify with workflows

          Behind the scenes of a successful ticketing system: BTS Series Narrative 16: Simplify with workflows What is a workflow? A workflow organizes business tasks in a defined sequence that makes each step clear to all participants. This ensures work is completed

        • Zoho Invoice Customer Login Portal

          Are there any plans for a customer portal to Zoho Invoice, ala Freshbooks?  I would like customers that I invoice to be able to login to review invoices and invoice history.  I have not switched from Freshbooks for this very reason.

        • Random Leads are being created

          Hi, Every few days I am getting random leads that are being created with no form interactions at all. The email addresses are from obvious spam, such as 'Easymerchantsx'. When I look at the timeline, there is a Visit record and then a Lead Created record,

        • Related list Mobile Device

          Hello, We use an the Zoho creator application to make reports linked to Accounts. On the computer: it's easy to go the Account and see all the created reports in the related list below On iPad/Phone ZOHO CRM APP: we cannot see the reports on those accounts

        • Print a price list or price book

          Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more

        • Bar Chart -- sort X-axis

          Hi! I created a bar chart ("Top 10 Products by Revenue") X-axis: Product Name Y-axis: Revenue Filter: Revenue - Top 10 Here's a picture: http://screencast.com/t/ZTJlZTdkNz The x-axis is sorted alphabetically by Product Name. How can I force it to sort numerically by Revenue?

        • Syncing with Google calendar, Tasks and Events

          Is it possible to sync Zoho CRM calendar, task and events with Google Calendar's tasks and events. With the increasing adoption by many major tool suppliers to sync seamlessly with Google's offerings (for instance I use the excellent Any.do task planning

        • ZoHo Flow Custom Function not Processing JSON

          JSON is being escaped and converting all the quotes in the JSON to '"' Here's the Code: void InsertRowInE123EligibitySheet(map input) { rawData = get("data",""); decodedData = rawData.htmlDecode(); data = decodedData.toMap(); sheet_id = "ID GOES

        • Managing functions

          Can someone let me know if there are any plans to improve the features for managing functions in CRM? I have lots of functions and finding them is hard. The search only works on the function name and the filter only works on function type. I have created

        • Zoho FSM - Service Appointment Trouble Adding Field Agent

          Hello, I just started using Zoho FSM and I'm currently adding older work orders from prior Field Service application I use. The work order that im trying to add is from an earlier date, and when I try to add a field agent to a service appointment it does

        • Shifts in Zoho People vs Zoho Shifts?

          Hello Zoho People Team, We hope you are doing well. We are evaluating the Shifts functionality within Zoho People and comparing it to the standalone Zoho Shifts product. We’ve encountered comments and discussions suggesting that the Shifts feature inside

        • 年内最後のユーザー向けイベント：5名限定！ 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (12/18)

          ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 12月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら（無料） https://us02web.zoom.us/meeting/register/QHn6kJAcRs-znJ1l5jk0ww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。

        • How do I get my account id?

          Hello, I followed the instructions to get a list of accounts of the currently authenticated user (which is me, and I am logged in). But when I follow the below instructions I get the following error: ERROR: {"data":{"errorCode":"INVALID_TICKET","moreInfo":"Invalid ticket"},"status":{"code":400,"description":"Invalid Input"}} Instructions that I am following: GET - User account details Purpose The API retrieves the list of accounts of the currently authenticated user.  Request URL  http://mail.zoho.com/api/accounts

        • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

          I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the

        • Zoho Quartz Screen Recording

          Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you

        • auto close automated alert tickets which are similar

          Hello ZOHO Community, we are using ZOHO Desk to process automated monitoring alerts. Scenario: Our monitoring system creates a ticket when a threshold is exceeded, e.g. Subject: Computer 1 – CPU usage 100% – Error A few minutes later, once the issue resolves

        • Maintain knowledge base integrity by moderating article comments

          Hello everyone, A knowledge base provides a self-service platform where customers can refer to articles, user manuals, and other resources to learn about the company's products or services and troubleshoot problems. Often, readers leave a comment on the

        • Making another calendar your default calendar

          I am trying to make another calendar my default calendar when I add events to it. It keep going to a single calendar, I need it to go to my google calendar by default, as this is linked to other services / websites. I cannot find an option to make it

        • Customer ticket creation via Microsoft Teams

          Hi all, I'm looking to see if someone could point me in the right direction. I'd love to make it so my customers/ end users can make tickets, see responses and respond within microsoft teams. As Admin and an Agent i've installed the zoho assist app within

        • Option to Delete Chats in IM

          Currently, there is no option to delete any chats in IM, regardless of their source.

        • Restrict Users access to login into CRM?

          I’m wanting my employees to be able to utilize the Zoho CRM Lookup field within Zoho Forms. For them to use lookup field in Zoho Forms it is my understanding that they need to be licensed for Forms and the CRM. However, I don’t want them to be able to

        • Referencing a cell from another sheet

          My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by

        • Group mail for external email addresses

          Hello, I was just wondering if the Group mail feature works with external email addresses - e.g. gmail.com or a completely different domain? it seems only internal addresses (hosted with Zoho) receive the mail. Thanks, Oliver

        • Is Zoho Shifts included in the Zoho One plan?

          In case the answer is no: there's any plan to make it available via One? Thank you

        • Marketing Automation Requirements Questions

          I would like to set up a multi-email drip campaign- please see the structure below and confirm if I can achieve this set up in Zoho marketing automation. Where applicable, highlight gaps and workarounds. Thanks Drip email campaign- Can I create one drip

        • The email address you have entered belongs to a different deployment/region.

          Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below -  The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forward

        • Use Zoho Flow Credits for CRM ‘Actions by Zoho Flow’

          Hello Team, We would like to submit a feature request regarding credit usage for “Actions by Zoho Flow” in Zoho CRM. Use Case: We are Zoho One users and actively use Zoho Flow, where our organization has 52,000 Flow tasks per month. In Zoho CRM, we use

        • Unusual activity detected from this IP. Please try again after some time.

          Hello Zoho admin and IT team We are a registered website in Eloctronic services and we been trying to add our users to the zoho system but this issue faced us ,, hope you unlocked us please.

        • Alert if a field is ticked.

          Hi There, We have two modules named Opportunities (Deals) and End Users (CustomModule1), as per the image below. Within Opportunities, we have a lookup field that looks up from the End Users Module. We are looking to get an alert either via email or another

        • Next Page