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!

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts



                                                          • 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,


                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources


                                                                                            Zoho Writer Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ



                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Zoho Tasks - Add Sorting by Priority

                                                                                                            We are able to Group by and Filter by Priority but for some reason we can't Sort by Priority on the Task lists. Please allow for sorting by priority if the current view is not grouped by priority.
                                                                                                          • customize payment page

                                                                                                            Is there a way to customize, other than the theme colour, the payment page that customers are taken to from invoices? I can't seem to find a way. I just don't like the formatting of the current page and would like to make it look better. I've looked at
                                                                                                          • Zoho People > Candidate Form > error Editable Primary Lookup is needed to set add permission

                                                                                                            Hello All I have try to turn on the add feature in the candidate form It show the error Editable Primary Lookup is needed to set add permission What is missing from my side?
                                                                                                          • 6 time-saving tips for working with tables in Zoho Writer

                                                                                                            Tables have always been the best way to represent data. They help you structure and categorize information systematically and present them in a simpler way. While tables in Zoho Writer are easy to implement, some tasks might not be that obvious.  Here are some time-saving tips to help you work better with tables in Zoho Writer:    1. Insert Multiple Rows / Columns in a Table Adding more rows and columns is the most common action performed while working with tables. Instead of using the Table tab,
                                                                                                          • Add Built-in "Partner Finder" / "Contractor Directory" Tab to Zoho Desk Help

                                                                                                            Hi Zoho Team, We hope you're doing well. We would like to request a new feature for the Zoho Desk Help Center: A built-in, configurable "Partner Finder" / "Contractor Directory" tab or section, similar in concept to your own Zoho Partner Finder at: 🔗
                                                                                                          • Can't get sender adress to work

                                                                                                            Hi, I am having some trouble getting the sender adress to work for responses on tickets. I would like to configure a sender adress that is different from the zohodesk emailadress that is normally used. These are the steps I have followed: 1. Add a new
                                                                                                          • Question Regarding Deleted Reports in Zoho Desk Analytics

                                                                                                            Dear Zoho Desk Support Team, I hope this message finds you well. We have a question regarding the Analytics module in Zoho Desk, specifically related to deleted reports/dashboards. We would like to understand the following: Is there a recycle bin, recovery
                                                                                                          • Add an option to start zobot when user clicks the Chat with Us button

                                                                                                            I would like to have an option to start the zobot when user clicks on "Chat with us" button when chat widget is maximized that way visitors could see first the homepage and decide which channel they would like to use to connect, or to see the quicke help
                                                                                                          • Zoho Books - Feature Request - Provide "Show PDF View" toggle on Invoice records

                                                                                                            I have noticed it is possible to activate or deactivate the PDF preview on some records but not all. This would be very helpful on Invoices when a custom template is being used and the PDF preview does not represent the output file. Not available on:
                                                                                                          • Incorrect Handling of XLSX data

                                                                                                            Trying to import an XLSX schedule of bills into Zoho Books I ran across the problem of date formatting. To replicate: Build a CSV file with bill dates in whatever format you like and import it - this should work if you match the "dd/MM/yyy" etc. format
                                                                                                          • Disable Smart Filters By Default

                                                                                                            The smart filters "feature" is causing confusion for Zoho Mail users. New emails should be delivered to the inbox unless they have specifically opted to redirect them somewhere else. People don't understand that new emails might be waiting in a random
                                                                                                          • Adding Columns to Reports

                                                                                                            Hi, Is it possible to choose fields to be added as columns in the reports? Thank you.
                                                                                                          • How do I automatically assign the project owner for all tasks in Zoho Projects?

                                                                                                            I have been researching for days on how to automatically assign all the tasks to the project owner on creation of the project in Zoho Projects. I have been having to go in and manually change all the task owner from 'unassigned' to the owner of the project
                                                                                                          • CRM Kiosk - Action for GetRecords

                                                                                                            I have a Kiosk screen with GetRecords and want to use the selected records in a custom function. My particular case is to set a lookup value on the selected records. Generally speaking though, I want to work with the selected records in a function. I
                                                                                                          • Extract Archived Projects using Zoho Projects API

                                                                                                            In my organization we archive the projects when they are already completed, charged, invoiced, so that only those that are still pending process remain active. I need to access all projects (active and archived) from an external system, but the API v3
                                                                                                          • Email for customer to provide payment information

                                                                                                            Is there a way for customers when you set up a subscription to get an email that prompts them to put in their billing information to start their subscription? Also, can you show the subscription in their portal?
                                                                                                          • Unable to display field label from a hidden Single Line Textbox in Description

                                                                                                            Hi folks, I'm unable to display my hidden field, e.g. ${zf:SingleLine4} , in my description. I'm pre-filling this hidden Single Line Text box via "Field Alias - Pre-fill URL" settings. I noticed that my decimal form fields work, e.g. ${zf:Decimal}, and
                                                                                                          • Lookup fields

                                                                                                            Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modules
                                                                                                          • Zoho Analytics - Bill Table

                                                                                                            Hi I am new to Zoho and mainly work in Books. Recently learned of Zoho Analytics and am exploring it to create reports that would be useful for me. For example, I want to create a bills cash forecast by week for cash flow planning. When I start to create
                                                                                                          • Creating a tax - amount table in Analytics

                                                                                                            Hi everyone, I would like to create a report in Zoho Anayltics that creates the tax and amounts in a table. I have been able to create a report that shows me all the tax accounts, but I can't get it combined with the amounts of the accounts. Is there
                                                                                                          • Is it possible to do custom domains on test accounts that use saml setups?

                                                                                                            In Zoho Billing, Is it possible to do custom domains on test accounts that use saml setups for the customer portal?
                                                                                                          • I’m facing an issue while trying to upload a PDF file to a custom file upload field within the Leads module via the Zoho CRM API.

                                                                                                            Hi Zoho Team, I’m facing an issue while trying to upload a PDF file to a custom file upload field within the Leads module via the Zoho CRM API. I am able to manually upload a PDF into this field through the UI. I am also able to upload files as attachments
                                                                                                          • No chat option

                                                                                                            Chat option is not available in Android app.
                                                                                                          • How to add custom templates in zoho sheets mobile

                                                                                                            How can I add custom templates in Zoho spreadsheet mobile?
                                                                                                          • Order Items

                                                                                                            Hi .. We have to implement orders with line but each line should have a separate record and not as a subform, does anyone have experience with that kind of solution what is the best practice for that kind of thing Thanks
                                                                                                          • Trello: Invalid Client - Client ID passed does not exist

                                                                                                            Hello, I am trying to authorize the Zoho CRM power-up in Trello but always land on the following page: I tried adding a trello client to the Zoho API console but this generated a different client ID to the one in the link of the page in the above picture.
                                                                                                          • Zoho Sprints - Q2 updates for 2025

                                                                                                            Hello everyone! We’re excited to share the latest updates from Zoho Sprints for Q2 2025! This quarter, we rolled out a few highly-requested features designed to enhance collaboration and time management across your projects. Here's a look back at the
                                                                                                          • CRM Email Insights Not Working - Status not Changing

                                                                                                            I used to be able to see if a customer opened/read an email in CRM, but I no longer get those status changes inside their record. I have everything enabled and I am sending the email from CRM. The experience center has the status' enabled as well. Any
                                                                                                          • The use of Ticket statuses

                                                                                                            When your support team mark a ticket "Closed" before I had a time to check what your team has done on the ticket - I have to consider this as you consider the ticket closed even if I dont consider it closed. Which automatically produce a negative sentiment.
                                                                                                          • "Replace" an existing version of CRM

                                                                                                            Hi all, I have a question, I saw an article about this once, but I now cannot find it. I am working with a client who has had their CRM in Zoho One built and extensively modified. But it is non-functional now, and rather than try and unpick the system,
                                                                                                          • Data Import From a private PostgreSQL RDS Instance

                                                                                                            Hello All, I feel like the problem I am experiencing has been seen before; however, I am having a difficult time finding any solutions. Hoping the community has some insights. I am trying to import data from a PostgreSQL RDS instance that is behind an
                                                                                                          • Assistance Required: Authentication Error When Sending Credit Application Form

                                                                                                            Hi, I'm encountering an error message that states: "Authentication unsuccessful – the user credentials were incorrect." This occurs when I attempt to send the credit application form to our customers. I've attached the form I’m trying to send for your
                                                                                                          • Missing Fields in Lead Conversion Mapping

                                                                                                            I’ve been using Zoho CRM since 2013 to manage leads and convert them into contacts and jobs. When I convert a lead to a customer, I create a new contact and a job. Previously, this process automatically transferred key information from the lead to the
                                                                                                          • Allow selection of select inactive users in User data fields

                                                                                                            Hello, We sometimes need to select a previous employee that has an inactive account in the User data field. For example, when doing database cleanup and indicating actions are done by a certain employee that weren't filled out when they were part of the
                                                                                                          • Connection to Zoho One

                                                                                                            My org has a Zoho One account, which includes Zoho Social. We are wanting to try linkthread. However, I want to make sure it is set up properly from an account perspective, as I have accidentally created Zoho accounts separate from Zoho One when I didn't
                                                                                                          • Ticket Automatically Created from Closed Chat

                                                                                                            Is there a way to prevent a ticket being create for every chat.... or at the very least have it automatically closed.
                                                                                                          • IMPORT INVOICES CSV

                                                                                                            Hi, Impossible to import invoices in Zoho books with a csv file. I have also tried with the template. My topic keeps getting closed but I did not get any answer Is there an issue with this fonctionnality ?
                                                                                                          • Related Lists in Email Templates

                                                                                                            Hi Zoho team, I would love to see a feature where related list information can easily be added to an email template (instead of mail merge). I have a client who books flights for their customers. They do this through a Flights module so all booked flights
                                                                                                          • Outlook plugin funktioniert nicht.

                                                                                                            DAs Outlook Plugin funktioniert nicht mehr. Ich werde aufgefordert, mich mit der App "OneAuth" anzumelden Intelligente Anmeldung per OneAuth funktioniert nicht zufreidenstellend. Nach erfolgreicher Anmeldungung mittels QR Code lande ich wieder beim QR
                                                                                                          • iOS App Version 3.0 - Customer list gone?

                                                                                                            Not sure when this changed, but I seem to have been updated to 3.0 for the phone app (on iOS). I'm pretty sure that I used to have a Customers button that allowed me, for example, to see what appointments a customer has. Has this disappeared or am I just
                                                                                                          • Next Page