Kaizen #30 - Parameters in Zoho CRM APIs [Part 2/2]

Kaizen #30 - Parameters in Zoho CRM APIs [Part 2/2]

Hello everyone!

Welcome back to another week of Kaizen! 
In this post, we will shed some light on the parameters in Search Records API and other generic parameters available in Zoho CRM APIs.

A. Parameters in Search Records API

1. criteria
Use this parameter to search for records in a particular module based on criteria.  

Syntax:
(({api_name}:{starts_with|equals}:{value})and/or({api_name}:{starts_with|equals}:{value})and/or...)

You can set a maximum of 10 conditions (starts_with & equals). When you use parentheses or commas in the value of criteria, you must escape them using a backslash. Further, you must encode the value. 

Consider the search term:
((Last_Name:equals:Burns,B)and(First_Name:starts_with:M))

After escaping the comma and parenthesis in the value: ((Last_Name:equals:Burns\,B)and(First_Name:starts_with:M))

After encoding the value:
((Last_Name:equals:Burns%5C%2CB)and(First_Name:starts_with:M))



To use conditions other than starts_with or equals, refer to the Query API.

2. email
Use this parameter to search for records based on email IDs. All the fields with the field type "Email" in a particular module will be searched and listed. For instance, Primary Email, Secondary Email, and so on. 



3. phone 
Use this parameter to search for records based on phone numbers. All the fields with the field type "Phone" in a particular module will be searched and listed.  


4. word
Use this parameter to perform a module-wise global search by word. 


Note: 
  • You cannot search for records with two or more above mentioned parameters in one API call. 
  • If you specify two or more parameters simultaneously, preference will be given in the following order: criteria, email, phone, and word, and only one of them would work.
B. Other Generic Parameters

1. module
Use the module parameter to perform module-specific operations. For instance, to fetch module-specific metadata like fields, layouts, custom views, and so on.   Specify the API name of the module as value. The module API names that can be passed differs from API to API. Refer to the corresponding API documentation to know the supported modules.   

APIs in which the "module" parameter can be used:

The API call in the example below retrieves the details of the fields in Leads module.


  
2. ids
Use the ids parameter to perform record specific operations. The "id" key in the Get Records API, represents the unique ID of the record. 

APIs in which "ids" parameter can be used:

The API call in the example below deletes CRM variables based on ID.


Refer to Kaizen #25 Zoho CRM API - Common Errors and Error Handling to know about the errors related to parameters. 

We hope you found this post useful. Let us know your thoughts in the comment section or reach us out at support@zohocrm.com.

Cheers!

Next 'Kaizen' - Subforms #API




    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

                                                            • Kaizen #226: Using ZRC in Client Script

                                                              Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this
                                                            • Kaizen #222 - Client Script Support for Notes Related List

                                                              Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore how
                                                            • 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 are
                                                            • Kaizen #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 achieved


                                                            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

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • 【開催報告】東京 ユーザー交流会 Vol.3 2025/10/17 Zoho サービスの活用促進を外部ツールとの連携で実現!

                                                                                                                ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 10月17日(金)に新橋で「東京 ユーザー交流会 Vol.3」を開催しました。ご参加くださったユーザーの皆さま、ありがとうございました! この投稿では、当日のセッションの様子や使用した資料を紹介しています。残念ながら当日お越しいただけなかった方も、ぜひチェックしてみてください😊 ユーザー活用事例セッション:Zoho Flowと決済システムの連携 あみろくの岡島さんに、Zoho サービスの活用事例として、Zoho Flow を活用した外部サービスとの連携事例をご共有いただきました。
                                                                                                              • received email opens in a new tab every time I log in

                                                                                                                as per the title: since about when I first made my email account, every single time Ive logged in to view my inbox, a new tab opens for an email I viewed once as if restoring a closed session. I thought I just didnt understand the "starting up" settings
                                                                                                              • Engage with your customers at scale using WhatsApp Marketing Template messages

                                                                                                                Hi everyone, To make it easier for organizations to communicate with customers, Desk now allows you to send individual, mass, and bulk WhatsApp template messages from both the Ticket and Contact modules. How is this going to benefit your business? WhatsApp
                                                                                                              • Importation Tickets error

                                                                                                                Hi, I'm newbie here 🤓 So, i'm importing data from csv, but when I try advance to mapping fields the importer tool show this message: Previously I try import, other data, and not show errors in this step. Some ideas? Best Regards,
                                                                                                              • Showing description in timesheet and timelogs.

                                                                                                                I am wondering if it’s possible in version 5 of Zoho People to have the description show by default or with a manipulation on the user’s part. Let me show you what I mean. As you can see this is the view for the users. Now if they want to see the full
                                                                                                              • Workaround: openURL in Blueprints - An alternate approach

                                                                                                                There is a roundabout way to open a URL in blueprints after a save event. By using the 'onBeforeMandatoryFormSave' in Client Script, you can open an external URL. Now, the problem is, this is designed to be run BEFORE the blueprint is saved, not after,
                                                                                                              • MTD SA in the UK

                                                                                                                Hello ID 20106048857 The Inland Revenue have confirmed that this tax account is registered as Cash Basis In Settings>Profile I have set ‘Report Basis’ as “Cash" However, I see on Zoho on Settings>Taxes>Income Tax that the ‘Tax Basis’ is marked ‘Accrual'
                                                                                                              • Migrate file from Single File Upload to Multi File Upload

                                                                                                                Dears, I have created a new field Multi File Upload to replace the old Single File Upload field. I'd like to ask you guys what is the best way to migrate the files to the new field?
                                                                                                              • Open "Live Chat" from a hyperlink?

                                                                                                                Hi, I often write paragraphs and text on our company website, and usually say you can get in touch with us via live chat. Can the chat window be triggered to pop open without clicking the chat graphic in the bottom window, and use it in a hyperlink? ie:
                                                                                                              • Zoho Sites search box

                                                                                                                Is there a Search box that can be added to a Zoho site? It would be for searching within the site only.
                                                                                                              • What stops me from packaging and shipping an order when the inventory is negative?

                                                                                                                It seems if the inventory value is negative, that Zoho Inventory should not allow me to create a Package and Ship it.   But, there seems to be nothing to stop me from doing that other than when I go to physically package the item and realize that there is no stock. There also seems to be nothing on the screen that even indicates to me that I should not package and ship.  To me this is the fundamental point of an inventory system.  Am I doing something wrong?   
                                                                                                              • Conditional formatting based on another field

                                                                                                                Hi I have two fields on my form stage 1 complete and stage 1 deadline.  I am trying to setup conditional formatting so that if stage 1 complete is after stage 1 deadline the record is highlighted in red. I need both stage 1 complete and stage 1 deadline
                                                                                                              • The sending IP (136.143.188.15) is listed on spamrl.com as a source of spam.

                                                                                                                Hi, it just two day when i am using zoho mail for my business domain, today i was sending email and found that message "The sending IP (136.143.188.15) is listed on https://spamrl.com as a source of spam" I hope to know how this will affect the delivery
                                                                                                              • Changing a Single-Line Text field into a Multi-line Field without losing data

                                                                                                                Is it possible to change a Single-Line Text field into a Multi-line Field without losing data. I have a module with data for which I would like to change a single-line field into a multi-line field but I'm worried it might delete the pre-existing da
                                                                                                              • Webhook - Google Sheets

                                                                                                                I have 2 forms that are both integrated with Google Sheets. I've set up a webhook to pull form 1 data from Google Sheets to prefill data in Form 2. The issue I have is that the forms name fields are First Name & Last Name but the Google sheets integration
                                                                                                              • Verified Mark Certificate

                                                                                                                Hello Dears, Can anyone help and check my mail or direct me to the desired person who can add the verification tag to my mail https://www.zoho.com/blog/mail/email-authentication-with-bimi.html
                                                                                                              • Appointment booking is temporarily unavailable

                                                                                                                Embeded Zoho booking page in my WordPress website. When someone starts a booking, after choosing time and date, an error appears before payment - "Appointment booking is temporarily unavailable due to restricted settings." Used the embeded code given
                                                                                                              • Cannot connect to 365 business calendar and Teams, says personal but it is not.

                                                                                                                hi I have a number of users connected to their 365 business accounts. Adding a new user and it thinks hes got 365 personal edition. He does not.... Anyone know what's going on. Trying for days now. Bookings go into his MS calendar but as its thinks its
                                                                                                              • Limited review (/questions) for Bookings 2.0

                                                                                                                Hi all, I'm writing this review of Bookings 2.0 for two reasons: 1) it may be of interest to others, and 2) I'd like to be corrected if I'm wrong on any points. It's a very limited review, i.e. the things that have stood out as relevant, and particularly
                                                                                                              • Zoho Bookings - Reserve with Google

                                                                                                                Does Zoho Bookings plan to to integrate with Reserve with Google?
                                                                                                              • Tip #3: How to change your booking page language

                                                                                                                Displaying your booking page in your target audience's language can greatly increase customer satisfaction. By speaking their language, you will help customers feel more comfortable scheduling with you and create a stronger connection with them. Let's
                                                                                                              • Bigin Android app update: Alerts while creating tasks outside of working days, conflicting events and calls.

                                                                                                                Hello everyone! In the most recent version of the Bigin Android app, we have brought in support to display an alert if task is being scheduled outside of the working days. Also, when scheduling an event or call in the Activities module, a conflict alert
                                                                                                              • Bigin update: Link email messages to pipeline records.

                                                                                                                Hello everyone! In the latest version of the Bigin iOS(v1.11.9) and macOS(1.8.9) app, we have brought in support for an option to link email to pipeline records. This helps you to view emails specific to a deal, especially when a contact is associated
                                                                                                              • Bigin Android app update: Custom buttons and widgets

                                                                                                                Hello everyone! We are excited to introduce custom buttons and widgets on the Bigin Android app. Widgets: A widget is a customizable UI component in Bigin that improves efficiency and user experience. It lets businesses embed components, streamline interactions,
                                                                                                              • Collective-booking event not added to all staff calendars

                                                                                                                We assign two staff to certain events. When the client books this event, it adds it to one staff calendar (the 'organiser') but not the other. How can I ensure all staff assigned to a collective booking get the event in their calendar? (A side note: it
                                                                                                              • Project Management Bulletin: October, 2025

                                                                                                                Every need leads to innovation. Project Management tools were developed out of sheer necessity to drive large projects. With wide usage, the specifications grew precise, and so did the refinement. Over years we’ve crafted one of the best project management
                                                                                                              • Zoho Sheets saying locked when not locked

                                                                                                                Zoho Sheets won't let me add more rows to sheet because it's saying the sheet is locked, but the sheet is not locked. I tried using a different browser but I still have the same issue.
                                                                                                              • Identifying and Merging Accounts with Similar (Non-Exact) Names

                                                                                                                Hello everyone, I’m aware of the built-in deduplication feature in Zoho CRM that allows merging records with exactly matching values for selected fields. However, I’m running into a situation where our migrated data contains multiple variations of the
                                                                                                              • Option for super admin to recover the deleted chats in Zoho Cliq

                                                                                                                Currently, in Zoho Cliq, if a user accidentally deletes their chats, there is no option for the Super Admin to recover or view those deleted messages. I believe it would be helpful if Super Admins had a recovery option, perhaps within a certain time frame,
                                                                                                              • Zoho CRM iOS app updates: the Homepage, Zoho Survey integration, and support for multiple file uploads in subform

                                                                                                                Hello everyone! The Zoho CRM mobile app continues to evolve to bring you a smoother and more powerful CRM-on-the-go experience. We're excited to share some important updates now available in the iOS app. Here's what's new: Homepage support Zoho Survey
                                                                                                              • I am trying to integrate my module in sandbox environment to add data via API

                                                                                                                I went through the documents and tried to setup the API for adding the module via the api but the problem is the token setup is done on "https://accounts.zoho.in/oauth/v2/token" domain and the bulk write is done on "https://content.zohoapis.com/crm/v8/upload"
                                                                                                              • Setting up primary mobile number.

                                                                                                                Hi Sir Earlier I joined IIFL team and got an organizational email of zoho services. Later i quit and now my account is deactivated with IIFL but i am unable to link my mobile number to my own email id with zoho.
                                                                                                              • Tables for Europe Datacenter customers?

                                                                                                                It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?
                                                                                                              • Guided Conversations - Ticket Creation

                                                                                                                Hi there, Using Guided Conversations to Take Customer Data and apply it into a Support Ticket for internal use, Is there a way to take multiple Textual Variables Inputs (A series of questions), and have the answers all appear in the Description of the
                                                                                                              • How to send certain invoices for Approval based on condition?

                                                                                                                To streamline operations, I need the invoices to go for approval when certain conditions are met. For example, if my staff gives a discount of x amount, it must go for approval. If there is no discount, then the invoice will be approved automatically.
                                                                                                              • Unable to continue payment

                                                                                                                Hi, I want to make a payment for my email subscription, but I cannot proceed with the payment because my NITKU is invalid. In Indonesia, the NITKU consists of 22 digits, but Zoho only provides 20 digits, causing my NITKU to be invalid. Please help me
                                                                                                              • Is there a way to show contact emails in the Account?

                                                                                                                I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail
                                                                                                              • Massive spam pretending to come from our address – is this a Zoho security issue?

                                                                                                                Hi, We’ve been receiving more and more suspicious emails lately — many of them clearly look like scams. But yesterday, we got an email that appeared to be sent from our own address, which was very concerning. We're starting to wonder if this might be
                                                                                                              • Cant recieve mails

                                                                                                                I’m having an issue with my external IMAP account not fetching any emails into Zoho Mail, even though the connection test says “Success”. I can send, if someone sends an email to me. my original directory (home.pl host) recieves it in their portal but
                                                                                                              • Zoho Sheet Autofit Data

                                                                                                                While using Autofit Data function in Zoho Sheets with Devnagri Maratji or Hindi Fonts, a word or a number, it keeps couple of characters outside the right side border.
                                                                                                              • Next Page