Zoho CRM Workflow Function Not Receiving Field Data – All Values NULL

Zoho CRM Workflow Function Not Receiving Field Data – All Values NULL

Hi Everyone,

I am trying to do an automation using function and workflow.

One of our client has a request that they want to get an update about all of their sales order on their application when the status of sales order change. I created a work flow rules, crete and edit and if the account name is "client account name", then apply the function. 


An automated category functuion is created to send
webhook url. later will be replaced by clients standard Mule Rest Callout with auth2.0 authentication.

my response is success but no data is sent all logs are showing data point is null. I have fot the fields name and API name from Zoho API names only.

Info
  • 🔍 Function Execution Started
  • Received SO Number: NULL
  • Received Status: NULL
  • Received Deal Name: NULL
  • Received Contact Name: NULL
  • Received Account Name: NULL or Empty
  • string standalone.sendSalesOrderToMule(Int sales_order_id)
  • {
  • // Fetch Sales Order details from Zoho CRM
  • sales_order = zoho.crm.getRecordById("SalesOrders",sales_order_id);
  • // Check if the Account Name is "Aldar Properties"
  • account_name = sales_order.get("Account_Name");
  • if(account_name != "Aldar Properties")
  • {
  • return "No action taken - Not Aldar Properties";
  • }
  • // Extract required fields
  • so_number = sales_order.get("SO_Number");
  • status = sales_order.get("Status");
  • deal_name = sales_order.get("Deal_Name");
  • contact_name = sales_order.get("Contact_Name");
  • // Prepare JSON payload
  • data_map = Map();
  • data_map.put("so_number",so_number);
  • data_map.put("status",status);
  • data_map.put("deal_name",deal_name);
  • data_map.put("contact_name",contact_name);
  • // Convert Map to JSON string
  • json_payload = data_map.toString();
  • // Ensures proper JSON format
  • // Define Webhook URL (For now, we use a dummy API for testing)
  • webhook_url = "https://httpbin.org/post";
  • // 🔄 Replace with MuleSoft API later
  • // Send POST request
  • response = invokeurl
  • [
  • url :webhook_url
  • type :POST
  • parameters:json_payload
  • headers:{"Content-Type":"application/json"}
  • ];
  • // Log response for debugging
  • info response;
  • // Return success message
  • return "Webhook sent successfully!";
  • }
  • ❌ Error: Account Name is empty!



      • Sticky Posts

      • Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

        Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such

      • User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

        Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.

      • Custom Function : Automatically send the Quote to the related contact

        Scenario: Automatically send the Quote to the related contact.  We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please follow

      • Function #50: Schedule Calls to records

        Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM

      • Function #37: Create a Purchase Order from a Quote

        Welcome back everyone! Last week, we learnt how to calculate the total number of activities for a lead and further take note of the activity count for particular dates. For instance, from the period of Demo to Negotiation. This week, let's look at a function that lets you create a Purchase Order instantly from a Quote. Business scenario: In any form of business, one of the most important things to do is to document the transactions. Naturally, negotiation, signing an agreement, placing an order,

        • Recent Topics

        • multiple upload files in zoho form

          Hi,  I need upload multiple files  in a single upload field thkns

        • Keeping Track of Email Threads

          Hi, Z CRM is great for tracking all the activities one would want to track whilst qualifying leads, converting to customers, closing deals etc etc, however.... ....although I can use Z CRM to send an email to a lead/contact and have that recorded as an activity for other team members to see, there is no way of capturing an inbound email from that lead. Assume my lead replies to my email sent from ZCRM, in my case, the response arrives in my ZMail account. However I can't get it back into ZCRM to

        • Zoho Creator invokeUrl to retreive PDF

          I'm trying to retreive a record PDF to send to Print Node. Tried with and without the zoho_creator_connection. pdf_content = invokeurl [ url :"https://creatorapp.zoho.com.au/<org_namespace>/<app_link_name>/record-pdf/<report_link_name>/" + input.ID type

        • Bulk upload image option in Zoho Commerce

          I dont know if I am not looking into it properly but is there no option to bulk upload images along with the products? Like after you upload the products, I will have to upload images one by one again? Can someone help me out here? And what should I enter

        • Zoho App Builder

          I’m looking for a Zoho Creator developer to build a simple app for tracking site expenses for a construction company. Key features: mobile form, dropdowns for projects and expense types, photo attachment for invoices, auto-calculated totals, and Excel

        • Captcha can't be enabled conditionally

          Hi Problem: captcha on a form can't be enabled conditionally. Why is this a problem: Because I use the same form on our website (public) in the portal and mobile app. In the portal it works but in the mobile app it doesn't. So there should be a way to

        • ACH Returns Don’t Trigger Dunning or Reverse Payment in Zoho Subscriptions

          Zoho Billing marked an ACH payment as successful and kept the subscription active — even though the payment was later returned by the bank (NSF). There was no update to the invoice or subscription status, and I had to manually clean it all up. For credit

        • Zoho Sheet - Split cell diagonally fill half color

          is it possible to split a cell diagonally, fill different text in each half and ideally color them differently as well?

        • Calling Token API in Postman returning "error: invalid_client"

          Hello, I've been working on setting up an API to get data from zoho crm into a third-party application. I'm currently testing the setup in Postman, but I'm getting an error from the API to retrieve the access token. It keeps returning "error: invalid_client".

        • How to handle this process need using a Blueprint?

          See one minute screen recording: https://workdrive.zohoexternal.com/external/eb743d2f4cde414c715224fc557aaefeb84f12268f7f3859a7de821bcc4fbe15

        • bulk scheduling youtube shorts and facebook reels

          how do i flag the video as facebook reel rather than normal video, it's vertical, 20 seconds, yet still being posted as video on facebook for youtube, it's being rejected out right both videos are to standard, can be posted normally with normal scheduler

        • Invitation-Based User Access in Zoho Analytics

          Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security

        • Filtert products by multi select custom field

          Hello, this is seems like a must addition, why it can not be done now?

        • Multiple images

          Hi Is there a way to insert multiple images in one image record or any way that instead of one image, I could upload 5 to 10 images together. Looking forward for a solution. Regards

        • Zoho Projects - Custom Objects

          Hello, is there the ability now, or in the near future, to add custom objects to Zoho Projects? The requirement here would be to have the ability to track change requests to a project's budget. The idea here is to have the ability to create a custom Object

        • Access CRM Variables from Formula field

          Is it possible to use a CRM variable (defined in Developer Space -> CRM Variables) in a formula field for calculations ?

        • Announcing Bigin India Meetups Across 8 Cities: July 29 - Aug 07

          Hello Biginners, We've got some exciting news to share! We're hosting our first round of Customer Meetups for 2025 in India, from 29th July - 9th August. Whether you're a Bigin newbie or a seasoned pro, this is your chance to meet customers from your

        • Why isn't there an Expense description field / column?

          Hello! I'm new to Zoho Books and accounting. I'm surprised there isn't a proper expense description field (and column in the overview "all expenses" page)? I thought this was a given in accounting, as visualizing expenses facilitates tracking them down?

        • New in Zoho PDF Editor: Watermarks, password protection, signature collection, and more.

          Hi Zoho Sign users! We are delighted to introduce the latest enhancements to Zoho PDF Editor, designed based on user feedback and feature requests. This update enables you to reorder, extract, and rotate PDF pages, add watermarks, and collect signatures.

        • Cant't update custom field when custom field is external lookup in Zoho Books

          Hello I use that : po = zoho.books.updateRecord("purchaseorders",XXXX,purchaseorder_id,updateCustomFieldseMap,"el_books_connection"); c_f_Map2 = Map(); c_f_Map2.put("label","EL ORDER ID"); c_f_Map2.put("value",el_order_id); c_f_List.add(c_f_Map2); updateCustomFieldseMap

        • Printed Reports, Increase Font SIZE

          I need to send some printed copies of financial reports to my attorney. The reports print out with microscopic fonts. How do I increase the font size so that a normal human can read the text? Every other accounting app can do this so I imagine I have

        • Avoid email sending!

          Hello, Thanks you Zoho for the wonderful apps you provide. Question: Is there a way to disable sending emails when: - creating an estimate or billing. Thanks Tommy

        • Need to show discount before total after subtotal

          Need to show discount before total after subtotal on my estimate template (see attachment)

        • Email a "thank you" note for this payment is NOW checked by default

          Hello Team, Just noticed that Email a "thank you" note for this payment is now checked by default. I tried searching in Preferences and there is no way to turn this off. I do not want this to be the default. Is there a way to turn this off?

        • End-to-end services hours

          We are trying to determine the best method of quoting service hours on quotes but only present the sum amount to a customer, without losing the tracking of quantity of hours for invoicing purposes. Does anyone have a good method they have determined?

        • Specific Approval Question

          Hi everyone, Just a quick question here. I have located the "Approval Type" in the preferences, which is great, and I am sure we could make use of it. However, I am trying to understand how I can implement an approval "workflow". The business call it

        • Zoho Books - Show Discount Totals When Greater Than Zero

          Hi Books Team, I understand that to show or hide discount amount on a Quote or Invoice, I need to use different templates. It would be a great quality of life improvement for users if we had an option to show or hide the discount amount at line item and

        • Specifying a filename for Schedule Reports

          Is it possible to specify a filename to use with scheduled reports? For example: With a general ledger report, instead of general_ledger.pdf I would like to include the date the report was generated in the filename so it is called general_ledger_202

        • Need to upsert "Created Time" field in Leads Module

          I am in the process of implementing Zoho CRM for my business. I need to modify the "Created By' field to reflect the actual date/time the lead was captured in my original Excel file. Otherwise, my conversion velocity data will always be inaccurate, which

        • HTML for confirmation email

          Hi, After a prospect submitted the Zoho form, we want to send a confirmation mail. In this mail we want to add our email signature. However, while this is possible in Zoho CRM this doesn't seem to be an option in Zoho Forms. Also an html editor is not

        • Fire a webhook when the user gets access to portal

          Hello, We would like to know if there is any way in which we can automate a webhook call if the user accepts the portal invitation that Zoho sends by email. The customer module does have the option to trigger webhooks when a customer is created, updated,

        • Enable History Tracking for Picklist Values Not Available

          When I create a custom picklist field in Deals, the "Enable History Tracking for Picklist Values" option is not available in the Edit Properties area of the picklist. When I create a picklist in any other Module, that option is available. Is there a specific reason why this isn't available for fields in the Deals Module?

        • Creating Payrun summary by fetching values from the employee payruns and adding them

          I am trying to make a processing payrun module. I want on Form load to autofill payrun summary eg Total Deductions, Total employer contributions etc by fetching one value after the other in the employee payrun information. So it should loop through the

        • Feature Request - Zoho Books - Add Retainer Invoices to CRM/Books integration

          Hi Books Team, My feature request is to include Retainer Invoices in the finance suite integration with Zoho CRM. This way we will be able to see if retainer invoices have been issued and paid. I have also noticed that when the generate retainer invoice

        • Books <-> CRM synchronisation with custom Fields

          Hello, We are synchronising Books Customers with CRM Accounts. In CRM Accounts I set up last year a "segments" multiselect field shown below In Books, I set up a custom multi-select field with the same value as in the CRM And set up the synchronisation inside Books. Want to synchronise the Books Segments with the CRM Segments, but the later doesn't exist, and another non-existing is there ?! First, I don't understand where the field Segmentation is coming from. Second, I set CRM Segmentation to sync

        • Edit Reconciled Transactions

          I realize transaction amounts and certain accounts cannot be edited easily once reconciled, but when I audit my operational transactions quarterly and at the end of the year sometimes I need to change the expense account for a few transactions. To do

        • Request to Customize Module Bar Placement in New Zoho CRM UI

          Hello Support and Zoho Community, I've been exploring the new UI of Zoho CRM "For Everyone" and have noticed a potential concern for my users. We are accustomed to having the module names displayed across the top, which made navigation more intuitive

        • Sending campaigns from other server

          Hi, Is it possible to send campaigns from another server so customers can see mail direct from our company (Corrata) and not from ZCSend.net? Thanks, Tim

        • Edit a previous reconciliation

          I realized that during my March bank reconciliation, I chose the wrong check to reconcile (they were for the same amount on the same date, I just chose the wrong check to reconcile). So now, the incorrect check is showing as un-reconciled. Is there any way I can edit a previous reconciliation (this is 7 months ago) so I can adjust the check that was reconciled? The amounts are exactly the same and it won't change my ending balance.

        • Admin and Dispatcher Users show as Field Technicians in Dispatch Module?

          Hi Zoho, Our Admin and Dispatch user both show up as Fied Technicians / Field Agents in the Dispatch module, but they most certainly should not be assigned to any of the work orders and service appointments. These users are NOT service resources. How

        • Next Page