Kaizen #77 - Multi-select Lookup Fields in API V4
Hello everyone!
Welcome back to another post in the Kaizen series!
This week, we will discuss how to add data to multi-select lookup fields using the insert records API.
Note that this support is available only from CRM API version 2.1 and up. We have used the V4 API in examples, here.
What is a multi-select lookup field?
Consider an insurance company using CRM to track its policies, customers and their purchased policies. In CRM, we will use the custom modules Policies and Holders to store policy details and customers' personal details, respectively.
Here, each holder can have multiple policies and the same type of policy can be held by multiple holders.
So, there is a need to establish many-to-many relationships which you cannot achieve through a lookup field.
Multi-select lookup fields solve exactly this!
They allow you to associate multiple records with each other from two modules. The related modules' records are also available as related lists.
Linking Module
When you have a multi-select lookup that connects two modules, a linking module is created that contains data of the two connected modules.
Here, there will be two lookup fields—one pointing to Policies and the other pointing to Holders.
This is how the linking module looks in the UI:
Earlier, using V2 APIs, you had to make a POST call to this linking module and add data related to the two modules. Refer to this post for details.
From V2.1, you can directly add data to a multi-select lookup field while inserting a record itself.
Example Scenario
Let us consider the same example of Policies and Holders.
Policies and Holders contain Holders and Policies_Held multi-select lookup fields, respectively.
There are four policies viz., Life, Health, Auto, and Home.
Similarly, Allison, Smith, Jack, and Derek are policy holders and hold single or multiple policies.
Here is how a policy record looks like in the UI.
Holders is the multi-select lookup field and contains the details of the holders of this policy. You can also see Holders as a related list.
Here is how a record from the Holders module looks like in the UI with the Policies_Held related list.
Let us discuss how to associate a policy holder directly while creating a policy through the Insert Records API.
API names you need before using the API:
- API names of the multi-select lookup fields in the modules they appear.
- API names of the lookup fields in the connected module. Example, the API name of the multi-select lookup field in Holders is Policies_Held, while that of the lookup in the connected module is Policies.
You can use the Fields Metadata API for Policies and Holders to get these details.
Request URL: {{api-domain}}/crm/v4/Policies
Request Method: POST
Scope: ZohoCRM.modules.ALL or ZohoCRM.Policies.ALL/CREATE
Input Body:
{ "data": [ { "Name": "105_Travel", "Policy_Type": "Travel", "Policy_Period": "5 years", "Premium_Amount": 5000.00, "Payment_Model": "Annual", "Holders": [ //API name of the multi-select lookup field in Policies module { "Holders": { //API name in Policies "name": "Allison", "id": "3652397000011357033" //Record ID in the Holders module } }, { "Holders": { "name": "Jack", "id": "3652397000011357001" //Record ID in the Holders module } } ] } ] } |
UI after successful insertion:
Deluge Code:
Policyinfo = { "data":[{ "Name": "105_Travel", "Policy_Type": "Travel", "Policy_Period": "5 years", "Premium_Amount": 5000.00, "Payment_Model": "Annual", "Holders": [ { "Holders": { "name": "Allison", "id": "3652397000011357033" } } ] }]}; response = invokeurl [ type: POST content-type: "application/json" parameters: Policyinfo.toString() connection: "ZohoCRM" ]; info response; return ""; |
Here is the input body to insert a holder in the Holders module with the multi-select lookup field Policies_Held.
{ "data": [ { "Name": "Sandra", "Policies_Held": [ //API name of the multi-select lookup field in Holders { "Policies": { //API name in the connected module "name": "105_Travel", "id": "3652397000011358003" //Record ID in Policies } }, { "Policies": { "name": "101_Home", "id": "3652397000011353001" } } ] } ] } |
Deluge Code:
Holderinfo = { "data": [ { "Name": "Sinatra", "Policies_Held": [ { "Policies": { "name": "105_Travel", "id": "3652397000011358003" } }, { "Policies": { "name": "101_Home", "id": "3652397000011353001" } } ] } ] }; response = invokeurl [ type: POST content-type: "application/json" parameters: Holderinfo.toString() connection: "ZohoCRM" ]; info response; return ""; |
We hope you found this post useful. We will meet you next week with another interesting post.
Write to us at support@zohocrm.com if you have any questions, or let us know in the comment section.
Cheers!
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
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 Bigin?
Topic Participants
Shylaja S
Sticky Posts
Kaizen #197: Frequently Asked Questions on GraphQL APIs
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.Celebrating 200 posts of Kaizen! Share your ideas for the milestone post
Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQsKaizen #193: Creating different fields in Zoho CRM through API
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.Client Script | Update - Introducing Commands in Client Script!
Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
FSM Improvement Idea - Show an Import button when there is no data
I am setting up FSM for a client and I noticed that there is no option to import data, see screenshot below. Even when you click Create Contact there is only an option to Import from Zoho Invoice. It is only after you add at lease 1 record that the ImportZoho CRM Community Digest - July P1 | 2025
Hey everyone, The start of July 2025 marked a special milestone: 200 posts in our Kaizen series! For those new here, Kaizen is a go-to series for Zoho CRM developers, where we regularly share best practices, tips, and expert insights to help you buildcan't login Kiosk URGENT
already try, can't login pls help to support. thanks.Join our BI & Analytics Workshop at Zoholics UK 🇬🇧
Hello users, We are thrilled to announce a hands-on workshop at Zoholics UK, 2025, led by Ashwinth and Alan, our Product Experts. This session is designed for anyone who wants to move beyond raw data and truly understand their business performance usingWhat’s New in Zoho Expense (April – July 2025)
Hello users, We're happy to bring you the latest updates and enhancements we've made to Zoho Expense over the past three months, which include introducing the Trip Expense Summary report in Analytics, extending Chatbot support to more editions, rollingWeekly Tips: Insert frequently used phrases in a jiffy using Hotkeys
You often find yourself using similar phrases in an email —like confirming appointments or providing standard information. Constantly switching between the mouse and keyboard interrupts your flow and slows you down.Instead of typing the same phrases overUndo Command in Notebook
It would be handy to have an Undo in the row of icons at the bottom of the notes.Improved UI for a Seamless User Experience - Calls, Tasks, and Meetings
Hello all, We are making UI unification across CRM so that the UI experience is seamless across the product. As part of that effort, we have made changes to the details page of activity-based module records—Meetings, Calls, and Tasks. Let's look at theseNew Customization options in the module builder: Quick Create and Detail view
Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the numberUnable to send message; Reason:554 5.1.8 Email Outgoing Blocked
Hi, I sent few emails and got this: Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked And now I have few days since I cant send any email. Is there something wrong I did? Also can someone fix this pleaseCross References Do Not Update Correctly
I am using cross references to reference Figures and current am just using the label and number, i.e. Figure #. As seen here: When I need to update the field, I use the update field button. But it will change the cross reference to no longer only includingAdd multiple users to a task
When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesmanNarrative 9: GC—Meaningful conversations that benefit your customers
Behind the scenes of a successful ticketing system - BTS Series Narrative 9: GC—Meaningful conversations that benefit your customers Customers often seek immediate solutions, which is why self-service options are essential. Guided Conversations providesFSM App Oddity
We recently rolled out FSM to our technicians, and only one technician is having an issue. He's using an iPhone with iOS 18.6 installed. When he goes to service appointments using the calendar icon at the bottom of the app, he gets a list view only. Typically,Cliq Not Working !
Zoho Cliq has been experiencing connectivity issues since this morning. The app is unable to establish a connection with the server.Injecting CSS into ZML pages
Is there a way to inject CSS into ZML pages? Use case: 1. Dashboard displays 'Recent Activities' card displaying a list of newly added records 2. Each item in list links to the record onClick 3. When a user points the cursor over an item in the list,Power of Automation :: Automated Weekly Notifications for Unapproved Timesheets
Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automateExtracting Data from Sitelink APIs
Hi All, I'm working to pull data on Sitelink using API calls but i can't seem to extract it. If you click expand, you will see it has a lot of data in it. I tried extracting from the map but it's not giving me anything. Is there a workaround on this orExport a list of fields for all modules in a spreadsheet with specific field data
Many of my clients are using spreadsheets to create lists of fields for all modules when starting a new implementation or when updating an existing setup. This is a useful process but also a very time consuming one. It would be good a list of fields could[Important announcement] Zoho Writer will mandate DKIM configuration for automation users
Hi all, Effective Dec. 31, 2024, configuring DKIM for From addresses will be mandatory to send emails via Zoho Writer. DKIM configuration allows recipient email servers to identify your emails as valid and not spam. Emails sent from domains without DKIM【Zoho Backstage】2025年7月のアップデート紹介
本投稿は、本社のZoho Desk コミュニティに投稿された以下の記事を翻訳し、一部抜粋したものです。 What's New - July 2025 | Zoho Backstage ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 本投稿では、Zoho Backstage の直近のアップデートを3点抜粋して、ご紹介します。 目次 1.参加可否の確認：RSVP 2.証明書作成ツール：Certificate Builder 3.登録の承認 ：Registration Approval 1.参加可否の確認：RSVPOption to select location?
As a business coach, I meet with clients at various public locations. I have two or three pre-determined locations that I meet at. I would like the client to choose the location when booking an appointment. Is there a way to do that with a single service, or is the best way to accomplish this by creating one service for each location offered?Can we have Backorder Management ?
Can we have Backorder Management ?Display a field of an Account on the Ticket view
Hi there, We would like to display of the Account of the user submitting a ticket on the ticket view. See for example: How can this be achieved? It doesn't really matter where it will be placed as long as it is shown there. Thanks, SnirTwo factor authentication for helpdesk users
The company i work for wants use the helpdesk site in Zoho desk, as a place for their distribution partners to ask question and look for information about our product. The things there is suppose to go up there is somewhat confidential between my companyRemove "Invalid entries found. Rectify and submit again" modal
Following up on a post from a few years back, but can the Zoho team consider either removing the 'Invalid entries found. Rectify and submit again' modal that displays for empty mandatory fields OR allow an admin to change it? I've built a custom errorInsurance Agencies
I am reaching out to see if anyone has any experience in the Insurance Agency world with using Zoho exclusively for the CRM and commissions side of things. Lots of strong features like drip campaigns, meeting, calendars, emails, can all be found in here.Problem with Egyptian internet ISP
Dears, We have problem with our ADSL internet SP, That your site not working with. So, we contact them and they asking us to contact you to solve this problem. The problem that when we are connecting to Tedata ADSL your website not working (Business Email). BR,, Mohamed OmarEmails not being received from a particular domain
Cannot receive any emails sent from atco.com Domain is in the spam whitelist so should be no reason for it not to be coming through. Have filed a ticket and besides a generic response of we are looking at it - it seems there is no actual support workersMail Not Showing In Inbox or Sent Box
Hi, there are mails that are not displaying in both my inbox and sent box. I just tried the iPad app and it is the same but there is a blank field where a mail should be and it refers to a server error. Please fix this.Possible to bold or indent text in the description field?
As part of one item, I often have a detailed description that would be much easier to read if there was the ability to have a bulleted list or bold text and the like. Is this possible? My last invoicing software allowed markup in the field so, for example, an asterisk meant a bullet. I haven't been able to find any documentation related to this. Any information would be appreciated. Thank you.Marketing Automation List Entry Criteria is no longer an option
For a couple of years now we have used the "List Entry Criteria" option to filter our Journey recipient list. All of a suddent the option no longer exists for New Lists and I can only delete the option from existing lists but can no longer edit it. AnyoneGCLID arrives not in CRM with iframe integrated ZOHO Form
Hello amazing community, I enabled Adwords integration in ZOHO CRM. I have a ZOHO Form integrated in a wordpress. I tested iframe and Javascript. I enabled the "handover" GCLID in the ZOHO Form. When I add a GLID with http://www.example.com/?gclid=TeSter-123.How to overcome Zoho Deluge's time limit?
I have built a function according to the following scheme: pages = {1,2,3,4,5,6,7,8,9,10}; for each page in pages { entriesPerPage = zoho.crm.getRecords("Accounts",page,200); for each entry in entriesPerPage { … } } Unfortunately, we have too many entriesAdd Webhook Response Module to Zoho Flow
Hi Zoho Flow Team, We’d like to request a Webhook Response capability for Zoho Flow that can return a dynamic, computed reply to the original webhook caller after / during the flow runs. What exists today Zoho Flow’s webhook trigger can send custom acknowledgementsTriggering Zoho Flow on Workdrive File Label
Right now Im trying to have a zoho flow trigger on the labeling/classification of a file in a folder. Looking at the trigger options they arent great for something like this. File event occurred is probably the most applicable, but the events it has arentBidirectional sync between Zoho Bookings and Zoho CRM - Part 1
Hey, community members! The default integration between Zoho CRM and Zoho Bookings is unidirectional, which means that any appointments booked, rescheduled, or deleted in Zoho Bookings will be reflected in Zoho CRM. However, any modifications made toIs it possible to edit placeholder text?
In the master slides I want to make sure my templates have more meaning for the users and want to replace the standard placeholder text with something more instructional. Instead of "Click to edit Mast subtitle styles" I want to have "Click to enter reportingDelay function execute
I've got a workflow which uses a webhook to send information to Flow, which in return updates a record in Creator. Problem is, by the time this has executed, the rest of my script has run and can't find the (yet to be) updated info in the record. Is thereRefunds do not export from Shopify, Amazon and Esty to Zoho. And then do not go from Zoho inventory to Quickbooks.
I have a huge hole in my accounts from refunds and the lack of synchronisation between shopify , Amazon and Etsy to Zoho ( i.e when I process a refund on shopify/ Amazon or Etsy it does not come through to Zoho) and then if I process a manual credit note/Next Page