Map Dependency Fields in Zoho CRM using APIs
Map dependency fields with a use case
- Parent Field - Issue Type: The value chosen here determines which options appear in the dependent field.
- Child Field - Sub-Issue: The available options change dynamically based on the selected value in the parent field.
Issue Type | Sub-Issue |
Login Issue | Forgot Password, Account Locked, 2FA Not Working |
Payment Issue | Credit Card Declined, Refund Not Received, Double Charge |
Feature Request | New Integration, UI Enhancement, Report Customization |
Without map dependency
Without configuring a map dependency, the Sub-Issue picklist would always display all available options - regardless of the selected Issue Type. For example, users might see options like Forgot Password, Double Charge, and Report Customization all at once. This can easily confuse users and lead to incorrect selections, such as choosing Double Charge under Login Issue.With map dependency
With mapping dependencies, you can guide users to make correct selections by showing only the relevant options in the child field based on the option selected in the parent field.Mapping picklist options in UI
- Go to Setup → Customization → Modules and Fields.
- Select the desired module. In this case, Support Cases.
- Click the ⋯ (more) icon next to the module name.
- Select Map Dependency Fields.
- On the Map Dependency Fields page, click the New button to create a new dependency.
- Choose the Parent Field and Child Field you want to map.
- Click Next button.
UI options mapping viewMapping picklist options via API
- Modules Metadata API - To know the API name of the module.
- Endpoint: GET - /settings/modules
- Here, the API name of the Support Cases module is Support_Cases.
- Layouts Metadata API - Since dependencies are layout-specific, this API helps you identify the layout ID and all the available picklist fields for mapping. It also provides detailed metadata such as the layout ID, field IDs, and the corresponding picklist value IDs.
- Endpoint: GET /settings/layouts?module=Support_Cases
Create Dependency using the POST Map Dependency
{ "map_dependency": [ //Array that contains one or more dependency mappings { "parent": { // Mandatory - Represents the parent picklist "api_name": "Issue_Type", //Mandatory - API name of the parent field "id": "5725767000007985243" // Mandatory - Unique ID of the parent picklist }, "pick_list_values": [ //Mandatory - List of parent picklist values and their corresponding child mappings { "display_value": "-None-", "maps": [ { "display_value": "-None-", "actual_value": "-None-", "id": "5725767000007985204" } ], "actual_value": "-None-", "id": "5725767000007985249" }, { "display_value": "Login Issue", "maps": [ { "display_value": "Forgot Password", //Label shown in the UI for the parent value "actual_value": "Forgot Password", //Actual stored value of the parent picklist option "id": "5725767000007985185" //Mandatory - Unique ID of the parent picklist option }, { "display_value": "Account Locked", "actual_value": "Account Locked", "id": "5725767000007985187" }
], "actual_value": "Login Issue", //Actual value of the parent field's option "id": "5725767000007985242" //Mandatory - Unique ID of the parent field's option }, { "display_value": "Payment Issue", "maps": [ { "display_value": "Credit Card Declined", "actual_value": "Credit Card Declined", "id": "5725767000007985191" }, { "display_value": "Refund Not Received", "actual_value": "Refund Not Received", "id": "5725767000007985193" }, { "display_value": "Double Charge", "actual_value": "Double Charge", "id": "5725767000007985195" } ], "actual_value": "Payment Issue", "id": "5725767000007985244" }, { "display_value": "Feature Request", "maps": [ { "display_value": "New Integration", "actual_value": "New Integration", "id": "5725767000007985197" }, { "display_value": "UI Enhancement", "actual_value": "UI Enhancement", "id": "5725767000007985199" }, { "display_value": "Report Customization", "actual_value": "Report Customization", "id": "5725767000007985201" } ], "actual_value": "Feature Request", "id": "5725767000007985246" } ], "child": { //Mandatory - Represents the child field "api_name": "Sub_Issue", //Mandatory - API name of the child field "id": "5725767000007985186" //Mandatory - Child picklist field ID } } ] } |
{ "map_dependency": [ { "code": "SUCCESS", "details": { "id": "5725767000008174001" }, "message": "map dependency created", "status": "success" } ] } |
Retrieve the configured field mappings using the GET Mapped Dependency Fields API
{ "map_dependency": [ { "parent": { "api_name": "Issue_Type", "id": "5725767000007985243" }, "internal": false, "active": true, "id": "5725767000008180001", "source": 1, "category": 0, "pick_list_values": [ { "display_value": "-None-", "maps": [ { "display_value": "-None-", "actual_value": "-None-", "id": "5725767000007985204" } ], "actual_value": "-None-", "id": "5725767000007985249" }, { "display_value": "Login Issue", "maps": [ { "display_value": "Forgot Password", "actual_value": "Forgot Password", "id": "5725767000007985185" }, { "display_value": "Account Locked", "actual_value": "Account Locked", "id": "5725767000007985187" }, { "display_value": "2FA Not Working", "actual_value": "2FA Not Working", "id": "5725767000007985189" } ], "actual_value": "Login Issue", "id": "5725767000007985242" }, . . . ], "child": { "api_name": "Sub_Issue", "id": "5725767000007985186" } } ] } |
Update the existing mapped options using the PUT Mapped Dependency Fields API
{ "map_dependency": [ { "parent": { "api_name": "Issue_Type", "id": "5725767000007985243" }, "pick_list_values": [ { "display_value": "-None-", "maps": [ { "display_value": "Login Issue", "maps": [ { "display_value": "Forgot Password", "actual_value": "Forgot Password", "id": "5725767000007985185" }, { "display_value": "Account Locked", "actual_value": "Account Locked", "id": "5725767000007985187" }, { // mapped a new option to the existing mapping "display_value": "2FA Not Working", "actual_value": "2FA Not Working", "id": "5725767000007985189" } ], "actual_value": "Login Issue", "id": "5725767000007985242" } ], "child": { "api_name": "Sub_Issue", "id": "5725767000007985186" } } ] } |
Delete existing dependency using the DELETE Mapped Dependency Fields API
{ "map_dependency": [ { "code": "SUCCESS", "details": { "id": "5725767000008174001" }, "message": "map dependency deleted", "status": "success" } ] } |
Assigning picklist values using the Insert Records API
{ "data" : [ { "Name" : "Support Case 1", "Support_Case" : "Login Issue", "Issue_Type" : "Login Issue", "Sub_Issue":"Forgot Password" } ] } |
FAQs
- Map picklists within the main form, or
- Map picklists within the same subform.
Topic Participants
Subramanian K
Sticky Posts
Kaizen #217 - Actions APIs : Tasks
Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.Kaizen #216 - Actions APIs : Email Notifications
Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes areKaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achievedKaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script
Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.Kaizen #210 - Answering your Questions | Event Management System using ZDK CLI
Hello Everyone, Welcome back to yet another post in the Kaizen Series! As you already may know, for the Kaizen #200 milestone, we asked for your feedback and many of you suggested topics for us to discuss. We have been writing on these topics over the
Recent Topics
I can not save new invoice
Hello Now I am trying to save a new invoice but I can not save it because showing unpaid invoice warning which are not overdue. Please let me know how to skip unpaid invoice warning letter and save new invoice. Thank youADD CONDITIONS FOR FIELD IN ZOHO BOOKS TEMPLATE CUSTOMAZATION
HELLO I WANT TO ADD CONDITIONS FOR FIELD IN ZOHO BOOKS TEMPLATE CUSTOMAZATION FOR SALES ORDER . I HAVE SET %StatusStamp% IF APPROVAL I WANT THAT TEXT TO BE DISPLAYED WITH GREEN COLOR OTHERWISE OF OTHERR STATUS RED COLOR AS SHOWN IN CODE BELOW . BUT ITAccounting on the Go Series-55: Seamlessly Add New Vendors While Creating Transactions from Scanned Documents
Hi there! We’ve made handling documents and vendors in Zoho Books even simpler. Now, when you upload a document and scan it, if the app detects a vendor that isn’t already in your organization, you don’t have to leave the page to add them manually. WithAccounting on the Go Series-57: Effortlessly Add and Manage Bank Accounts from the Zoho Books Mobile App
Hi all, Great news for our users in the US and Canada! Managing your finances just got a whole lot easier. Zoho Books has always made it seamless to integrate bank accounts and fetch feeds automatically. Now, we’re taking it up a notch—directly from theAccounting on the Go Series:58-Effortless Compliance: Download XML for Invoices & Credit Notes on Mobile
Hi there! In Mexico, XML files are crucial for electronic invoicing and fulfilling SAT (Tax Administration Service) requirements. These files ensure your transactions are accurately recorded and tax-compliant. Now, you don’t need to rely on the web appAuto Generated Invoice number YEAR
Auto Generated Invoice number shows transaction year as 25 even though it's 24 still.Books generiert keine valide XRechnung
Hallo zusammen, ich möchte hier ein Problem ansprechen, das mir aktuell bei der Nutzung von Books erhebliche Schwierigkeiten bereitet, und hoffe auf Austausch oder Lösungsansätze von anderen Nutzern. Bei der Erstellung von XRechnungen mit Books tretenWHEN UPDATE ORGANIZATION INFO OLD INVOICES ALSO CHANGE INVOICING DATA
Hi We have updated our tax information because we have become a company, up until now we were an individual. The problem is that when updating the data in the zoho books profile all the old invoices change their tax information as well. Is there a wayInvoice import error - duplicate customer name column - there are no duplicates
It is not allowing the importing of any rows because of a duplicate customer name problem, but there are no duplicates in the custoemr name row. Has anyone dealt with this issue before?[WEBINAR][Feb 2025] Automate your entire financial operations from receipts to reconciliation with Zoho Books & Zoho Expense integration
Hello there, We are hosting a free, live webinar on the importance of travel and expense management solutions for businesses, and how Zoho Expense automatically syncs with Zoho Books to simplify your accounting even further. The webinar is on FebruaryCustomize Layout
I am using "Customize Layot" for customize Quotation template but I try to add logo into the header by "%ScaledLogoImage%" code but dont add logo into header. what is problem?Problem - cant add Users (i.e. Zoho one / CRM Users) to BCC or CC in email, i.e. Sales orders or Retainers
I can go to zoho books email templates, and select any email template, and automatically include any Zoho One user, i.e. member of staff. However in the context of sending an email, it will not let us add a member of staff from the user list, insteadUK MTD ITSA
UK Making Tax Digital for Income Tax I have had notice this is to apply from April 2026. What is Zoho doing about this? I will need to start planning to implement this in the next months so need an update as to what I will and will not be able to do inPartial refunds
I am trying to process refund for a one item invoice, however the refund is partial: i am getting this error while creating credit note, can anyone share some wisdom about thisZoho Books Roadshows are back in the UAE!
Hello there, Business owners and accounting professionals of the UAE, we’re coming to your cities! FTA accredited Zoho Books is now officially one of the Digital Tax Integrators in the UAE. With the newly launched direct VAT filing capabilities, we'reNew user After moving over from QBO
New user observations/suggestions. QBO took away a lot of features I was used to with the desktop version. Chaos ensued. Zoho Books has a lot of what I was used to and a bit more. Good deal Some things I have run into and suggest some upgrades. 1: TheSole Trader - Financial Advisor (Appointed Representative) - Paid via Capital Account but no Invoicing...
Hi. I'm about to venture into a new business after 12 months of intensive learning/exams. A little chuffed if I may say so especially at 52! I really like the look of ZoHo Books for my modest enterprise but I'm in need of some guidance, please. My servicesMulti-Unit Inventory with Flexible Unit Selection (Purchase in One Unit, Sell in Another)
We need multi-unit inventory management in Zoho Books with the flexibility to choose units (e.g., Box or Piece) at the time of purchase or sale. For example, if 1 Box = 10 Pieces, we should be able to record purchases in Boxes but sell either in BoxesDisputed Purchase Invoices
We have recently moved to Zoho Books from Sage. In Sage we were able to post a purchase/vendor invoice but mark it as on dispute. This would usually be a pricing query or if something was damaged. It would show in their ledger, so we could agree theirNo TDS Deduction
In some of our case, where we are reselling items at the same rate we purchased. In this scenario, Indian IT Law has a provision to request customer not to deduct TDS if the transaction value is same. TDS is paid by us (intermediary reseller) before weCBSA - GST CHARGES on imports
Hi there, We have a questions about landed cost categorization. We received a shipment from overseas. CBSA invoiced us for the GST on the items. Now we entered the CBSA-GST as a separate bill and attached it as landed cost to the main invoice based onZoho Books
How do I manually insert opening balance?Sales order & purchase order item links for item details
This is fantastic for checking lots of things, I use it a lot. It would be great to see it extended to invoices & bills On another note, may as well throw in my favourite whinge ..... Wish you guys would get the PO receive differences sorted urgently,Bank charges are applied. Please select a bank account.
Hello, I'm trying to add bank charges to a customer payment, but I get the error message "Bank charges are applied. Please select a bank account." I found this old thread, where it says that I need to "select a Bank account for the 'Deposit To' dropdownHow to add receipts
How to add receiptsSupport for auto-upgrade in TrueSync (for Windows)
WorkDrive TrueSync app now supports auto-upgrading to the latest version for Windows OS. You must manually download and install the TrueSync app version 3.4.0 to avail this feature. Download the latest TrueSync app for Windows (version 3.4.0) SupportedWorkDrive API Documentation
WorkDrive provides users and developers an extensive set of APIs to help integrate functionalities of Zoho WorkDrive with other Zoho applications and third-party tools. We have published the official WorkDrive API Documentation page for all external users.March 15, 2023: Zoho Docs is discontinued
As of today (March 15, 2023) Zoho Docs is discontinued for all users. We would like to thank our customers for trusting us for so many years! Going forward, we're confident you'll enjoy using Zoho WorkDrive for all your advanced file management and collaborationIntroducing WorkDrive 4.0: Enhanced productivity. Advanced data administration. (Phase 1)
Hello All, We're excited to share the release of WorkDrive 4.0, which includes important new features and enhancements focused primarily on productivity, secure collaboration, data administration, integrations, and user experience. Read the official announcementExternal download link limit
Can You please help us to understand this For Zoho WorkDrive external users, the download limit is a maximum of 5 GB total download size and a maximum of 50 first-level files and folders What is the meaning of first level? We are using these files inDynamically catching new file creations
I have a team folder with many subfolders, and in those folders we add new documents all the time. I'd like to have a workflow or script to notify me (and then take other actions) when a file is added anywhere in that structure that ends in "summary.txt".Rotate an Image in Workdrive Image Editor
I don't know if I'm just missing something, but my team needs a way to rotate images in Workdrive and save them at that new orientation. For example one of our ground crew members will take photos of job sites vertically (9:16) on his phone and uploadWorkflow workdrive rollout
Hi! When will workflow be rolled out to all users? Thanks.Creating and managing a Team Folder using WorkDrive TrueSync
Hello everyone, Are you tired of constantly switching between your Desktop TrueSync app and the WorkDrive web app to create and manage Team Folders? We’ve made things easier for you. You can now create and manage Team Folders directly within the TrueSyncEdit images seamlessly with WorkDrive's built-in Image Editor
Are you tired of switching between multiple tools just to make simple edits to your images? We understand the hassle, which is why Zoho WorkDrive now comes with a built-in image editing tool, powered by Zoho Annotator. This tool allows you to edit imagesSupercharge your email workflow with WorkDrive's add-in for Microsoft Outlook
Consider this: You’re handling a critical project, and your inbox is packed with important attachments, email threads, and client communications. The back-and-forth routine of downloading files to your computer, uploading them to WorkDrive, and manuallySecure and promote your content with Custom Watermarking
Imagine this: You’re a professional photographer who regularly shares your work online with potential clients and collaborators. Recently, you notice that some of your images have been reposted without any credit or permission. This not only impacts yourJoin us in Singapore for the Zoho WorkDrive User Group meetup!
Hello, everyone! Exciting news! We'll be hosting an upcoming Zoho WorkDrive user group meetup in the beautiful city of Singapore this November. At this Zoho User Group meetup, we'll guide you through ways to use WorkDrive as a platform and build customWorkDrive TrueSync now supports ARM64-based Windows devices!
We’re excited to announce that the Zoho WorkDrive TrueSync app now fully supports Windows devices with ARM64 architecture! Whether you're working on an ARM-based device or an x64 processor, you can now enjoy the same seamless file synchronization experienceOption to Disable Download for Documents Shared via Permalink
Dear Zoho Writer Team, Currently, when sharing a Writer document using the regular permalink (Collaborators with external users), there is no option to restrict the ability to download the document. While the external share link allows such restrictions,Next Page