Issue with Exact Phone Number Match in Zoho CRM Search Record API

Issue with Exact Phone Number Match in Zoho CRM Search Record API

Hello Everyone,

I am working on a custom function that works as a REST API. This function receives API calls via a third-party webhook, where the payload data contains various details, including phone numbers, names, dates, etc. A single payload can contain data for multiple records.

I am extracting the phone number from the payload and then generating different combinations of possible phone number formats that are stored in the phone field within Zoho CRM. The phone numbers in Zoho CRM can be stored in various formats, such as:

+1 9876543210
019876543210
+19876543210

Using the searchRecord function, I am trying to search for leads records based on the phone number and associate the matching record. However, I am encountering an issue where the search results return records where the phone number partially matches (e.g., the first two or last two digits), in addition to exact matches. This causes incorrect associations with records.

I would like to get only exact matches. Below is the search query I am using:

lead_mobile_response = zoho.crm.searchRecords("Leads","(" + Phone+ ":equals:" + raw_number + ") or (" + Phone+ ":equals:" + number_with_zero + ") or (" + Phone+ ":equals:" + plus_c_code + ") or (" + Phone+ ":equals:" + plus_c_code_with_space + ") or (" + Phone+ ":equals:" + c_code_with_space + ") or (" + Phone+ ":equals:" + plus_c_code_with_dash + ") or (" + Phone+ ":equals:" + c_code_with_number + ") or (" + Phone+ ":equals:" + number_with_leading_zero_and_country_code + ") or (" + Phone+ ":equals:" + number_with_space_and_zero_prefix + ")");

Has anyone encountered this issue or can offer guidance on how to ensure that only exact matches are returned when using the equals operator?

Any insights or suggestions would be greatly appreciated.

Thank you!

    • Sticky Posts

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

    • 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