Extension Pointers - JS SDK Series #8: Use the SearchRecord API in a widget to simplify business operations

Extension Pointers - JS SDK Series #8: Use the SearchRecord API in a widget to simplify business operations

Looking up relevant business information is easier when you have an internal search feature that targets certain keywords or phrases. Often times, this information will be worked with and manipulated to be useful for the current task the searcher is doing, which means that a faster internal search process will lead to better productivity.

The SearchRecord API is used to retrieve records that match your search criteria. It performs a module-level search based on either a phone number, email address, word, or other piece of criteria. It's most helpful to search for text in the fields of data type "string", "phone", or "Email".

In this post, we will look at an example that involves searching for and updating records using the searchRecord and updateRecord APIs. We'll first give the syntax followed by an example scenario.

SearchRecord API

Syntax

ZOHO.CRM.API.searchRecord(config, page, per_page) 

Here, config refers to the configuration object of the 'object' type, page refers to the page number, and per_page refers to the number of records to be generated per page.

Configuration Object

Name
Type
Description
Entity
String
SysRefName (of the module)
Type
String
Allowed values "email|phone|word|criteria"
Query
String
Query string
delay
Boolean
Query string

Note : Please check here for more details and limitations on SearchRecord API.

UpdateRecord API

Syntax

ZOHO.CRM.API.updateRecord(config) 

Here, config refers to the configuration object of the 'object' type.

Configuration Object

Name
Type
Description
Entity
String
SysRefName (of the module)
Trigger
list
The trigger input can be "workflow", "approval", or "blueprint". If the trigger is not mentioned, the workflows, approvals, and blueprints related to the API will get executed. Enter the trigger value as [] to not execute the workflows.

API data
String
The data to be updated is constructed as
updateRecord's API Data parameter.

Let's take a simple scenario where a Zoho CRM user is handling a customer case. They would like to check if a similar problem has already been addressed in another case and if they can use any of those solutions for their own case. In our example, we will see:
  • How the SearchRecord API can help the user find solutions using keywords related to the current case
  • How the Search API returns the description and the solution of cases based on the keywords we enter
  • How the user can update the correct solution to the current case if the relevant solution is found
SearchAPI.js code snippet

Util={};
var EntityIds;
var EntityName;
var inputtext;
var solutiontext;
var solutiondescription;

//Subscribe to the EmbeddedApp onPageLoad event before initializing the widget 
ZOHO.embeddedApp.on("PageLoad",function(data)
{
EntityIds=data.EntityId;
EntityName=data.Entity;

//Search for solutions using input search words
Util.search=function()
{
inputtext=document.getElementById("inputword").value;

//Searches across the cases module for the input text entered 
ZOHO.CRM.API.searchRecord({Entity:"Cases",Type:"word",Query:inputtext})
.then(function(data){
console.log(data);
rec=data.data;
$('#solutionlist').empty();

//Looping through the solutions
for (i = 0; i < rec.length; i++) 
{

/*populating the solution list list with the solutions and description of all the cases associated with the input text provided*/
solutionsid=rec[i].id;
solutionname=rec[i].Solution;
solutiondescription=rec[i].Description;
solutionsname=rec[i].Description+"-"+rec[i].Solution;

/* Add the description-solution to the list only if the description or solution field is not null for the cases searched based on the input text */
if(solutionname!=null && solutiondescription!=null)
{
var solutionlist = document.getElementById("solutionlist");
var option = document.createElement("OPTION");
option.innerHTML = solutionsname;
option.value = solutionsid;
solutionlist.appendChild(option);
}
}
})
}

//Updates the solution to the solution field of the current case and changes the case status to closed 
Util.update=function()
{
solutiontext=document.getElementById("solutiontext").value;

var config={
Entity:"Cases",
APIData:{
"id": EntityIds[0],
"Solution":solutiontext,
"Status":"Closed"
},
Trigger:[]
}
ZOHO.CRM.API.updateRecord(config)
.then(function(data){
console.log(data)
})
}

// Closes the widget popup
Util.cancel=function()
{
ZOHO.CRM.UI.Popup.close()
.then(function(data){
console.log(data)
})
}
})

In the above code snippet, the input text keyed in is retrieved and passed as the Query parameter to the searchRecord API. The type parameter is passed as 'word', and the Entity parameter as 'Cases'. This searches across the Cases module for the input text and returns all the cases with the word present.

From the retrieved cases, the descriptions and solutions are fetched and populated into a select list. The user can have a look at the solutions and choose one if it resolves the current case issue.

The chosen solution is populated in the 'Enter solution here' textbox. The user can choose to edit the solution further according to their needs in the textbox and then click the 'Update Solution and close Case' button.

The updateRecord API will then update the solution entered to the solution field of the current case, and will change the status of the case to "Closed".

Sample Widget:

The user handles a case about a hardware issue. In the widget, they enter the word 'hardware' in the input field because it is a relevant word associated with the current case.



When the user clicks the 'Check for solutions' button, the searchRecord API returns all the descriptions and solutions involving 'hardware'. The user chooses a solution if it is relevant and makes further edits relevant to their case in the solution textbox. The 'Update Solution and close Case' button will update the solution to the solution field of the current case and close the ticket.



This was just an example, but there are many similar ways you can use the SearchRecord API to suit your specific business needs.

We hope you found this information useful. Keep following this space for more info!


SEE ALSO


    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





                                                            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

                                                                                                            • Enable / show scroll bar when Mega Menu is opened

                                                                                                              Hey there I am using the mega menu add-on and experience a "flicker" whenever the mega menu opens. The reason is, that the scrollbar, which has a width of a few pixels, stops showing when the mega menu opens. As the scrollbar disappears the whole page
                                                                                                            • Item images

                                                                                                              Can we get an "On hover" expanded image for items please ?
                                                                                                            • Free webinar—Redefining workforce security with Zoho Vault: Passwords, passkeys, and multi-factor authentication

                                                                                                              Hi everyone! Did you know that in Q2 alone, 94 million data records were leaked globally? Behind every breach is a combination of poor password habits, phishing attacks, privilege misuse, and simple human error. The fallout—including reputational damage,
                                                                                                            • Zoho Sign product updates - Q3 2025

                                                                                                              Hello everyone! Q3 was all about AI. Here's the list of features and enhancements that have gone live, along with a list of what we have in pipeline for the last quarter: AI-powered agreement management Sending documents and authenticating recipients
                                                                                                            • Feature Suggestion for Zoho Websites – Inspired by Squarespace Systems

                                                                                                              Dear Zoho Team, I’m a Zoho user and also a Squarespace Platinum Circle member, and I recently noticed the launch of Zoho Websites in India. I wanted to share some ideas for features that could enhance the platform for professional users and agencies.
                                                                                                            • Zoho sites header

                                                                                                              Good day, Im stuck with this situation. I choose a template for my website creation. I have tweaked every instance of the visual editor, regarding the header, I have created created customize fonts presets... I have followed every single step. and my
                                                                                                            • Zoho Books Sandbox environment

                                                                                                              Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need a
                                                                                                            • Quick Create needs Client Script support

                                                                                                              As per the title. We need client scripts to apply at a Quick Create level. We enforce logic on the form to ensure data quality, automate field values, etc. However, all this is lost when a user attempts a "Quick Create". It is disappointing because, from
                                                                                                            • 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
                                                                                                            • DNS set up

                                                                                                              I want to create an email with my company domain. When I tried to add new record with cloudflare it didn't work. The DNS record can't be manually added. I followed the instruction but still can't add it. Could you help?
                                                                                                            • Pocket from Mozilla is closing shop. Don’t lose your favorites . Move them to Zoho Mail Bookmarks now! 📥🔖

                                                                                                              The end of Pocket shouldn't mean the end of your important links and content. Easily import them into Zoho Mail's Bookmarks and continue right where you left off. You can bring over your entire Saves, Collections, and tags just the way they are. Bookmarks
                                                                                                            • How to Send Email from within a custom module (with or without an email template)

                                                                                                              It is possible to send an email from the Deals module. However, I can't find a way to send an email from any of our custom modules. I have tried adding an email field to the modules (even though we don't really want one or need it there). That doesn't
                                                                                                            • General suggestions

                                                                                                              Hello, I've picked this forum as it is at the top of the list! :) First suggestion: A general forum for issues and comments that are not specific to a particular Zoho application. Second suggestion: Put a link on the home page to "Zoho Identity Access Manager" The first suggestion came about because I didn't know where to post the second! ;) Regards Mark
                                                                                                            • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                                                                                              The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Managing addresses
                                                                                                            • Can't upload attachments.

                                                                                                              I can't upload attachment in Zoho Mail.
                                                                                                            • Need Guidance on SPF Flattening for Zoho Mail Configuration

                                                                                                              Hi everyone, I'm hoping to get some advice on optimizing my SPF record for a Zoho Mail setup. I use Zoho Mail along with several other Zoho services, and as a result, my current SPF record has grown to include multiple include mechanisms. My Cloudflare
                                                                                                            • How use

                                                                                                              Good morning sir I tried Zoho Mail
                                                                                                            • Zoho Mail Desktop App Not Loading + Can’t Manage Multiple Accounts

                                                                                                              Hi everyone, I’ve been having ongoing issues with the Zoho Mail desktop app for the past few weeks. The app starts to load but gives up midway and never actually opens — there’s no error message, it just stops loading. The main reason I use the desktop
                                                                                                            • not able to convert pdf to jpg and other forms and vice versa.

                                                                                                              i want to change my pdf to jpg, word, etc and some times jpg to pdf. i don't know how to do in this.
                                                                                                            • Connecting two modules - phone number

                                                                                                              Hi, I’d like some guidance on setting up an automation in Zoho CRM that links records between the Leads module and a custom module called Customer_Records whenever the phone numbers match. Here’s what I’m trying to achieve: When a new Lead is created
                                                                                                            • Changing an agents email address

                                                                                                              How do you change an agent's email address? I keep getting a red circle even though I am an admin. And on one of my agents he has two email addresses? How is that possible?
                                                                                                            • Error when sending emails from Zoho

                                                                                                              Hello, When trying to send an email from Zoho CRM I keep getting the below error: javax.mail.AuthenticationFailedException: 535 5.7.139 Authentication unsuccessful, the user credentials were incorrect. Any support on this will be much appreciated. Thanks,
                                                                                                            • Zoho Tables is now live in Australia & New Zealand!

                                                                                                              Hey everyone! We’ve got some great news to share — Zoho Tables is now officially available in the Australian Data Center serving users across Australia and New Zealand regions! Yes, it took us a bit longer to get here, but this version of Zoho Tables
                                                                                                            • Zoho Inventory - How to pay a supplier up front then receive multiple deliveries

                                                                                                              How do we manage situations where we pay a supplier up front, then the receive the products in increments? Example Workflow: Create Purchase Order > Receive Bill for full amount > Receive Items 2 or more deliveries. Currently, once a Bill is created against
                                                                                                            • Not all emails from outlook365 migrated to my new zoho account

                                                                                                              I recently setup a new email address hosted by zoho. I migrated all my folders and email from my Outlook365 account to my new zoho account, but not all my emails migrated. Looks like only the past 12 months, or so, made the move. How do I get the rest
                                                                                                            • Zoho Inventory - Composite Items - Assembly - Single Line Item Quantity of One

                                                                                                              Hi Zoho Inventory Team, Please consider relaxing the system rules which prevent an assembly items from consisting of a single line item and outputting a quantity of 1. A client I'm currently working with sells cosmetics and offers testers of their products
                                                                                                            • Clients not receiving emails

                                                                                                              I've been informed that my emails are not being received. Is there anything that I should look into to rectify this? Many thanks!
                                                                                                            • Max numbr of IMAP Accounts in Zoho Mail?

                                                                                                              In Zoho mail, you can manage the inboxes of other accounts using IMAP (and POP, actually) https://www.zoho.com/mail/help/external-imap-accounts.html Is there a max to the number of inboxes we can add?
                                                                                                            • Formula Fields Trouble

                                                                                                              Hi,  I can't get even a simple formula field to work and must be doing something dumb. This formula: If(Len(Trim(${Quotes.Subject}))=0,1,2) Gives the error: You used the wrong type of data in an argument. Check what you entered between the parentheses of your functions to make sure you put the right kind of data in the right place. This formula: Len(Trim(${Quotes.Subject}))=0 Gives the error: Syntax Error. Check the examples for any functions you're using to see if you formatted them correctly. Make
                                                                                                            • OPTED FOR STORAGE BY DESCRIPTIVE MISGUIDANCE

                                                                                                              We've opened a domain with three mail ids and payment has also been processed now the bill raised is for single use ID with additional storage capacity. Kindly request you to modify the purchase.
                                                                                                            • How can I add a new organization on Zoho Campaign

                                                                                                              I want to create a new organization with my Zoho Campaign
                                                                                                            • White Label certificate

                                                                                                              Hi all, About 72 hours ago, we fulfilled all steps for white labeling (CNAME to point to mail.cs.zohohost.eu), but since then the configuration page is now stuck at "generating certificate" since 3 days. When I execute an NSLOOKUP mail.webfoundry.be it
                                                                                                            • www.abc.com is working but abc.com is not

                                                                                                              I have my domain in godaddy. I have created a website using zoho sites and now I want to publish it and I tried doing it. Mapped the domain www.abc.com, abc.com. In godaddy changed the CNAME values. A, @ was parked and updated with zoho's IP address.
                                                                                                            • Split my account

                                                                                                              Hello, I recently bought an email service for a friend. But, looks like I used my personal account to buy the plan. Please split the account so that the email service stays in a different account than my personal account.
                                                                                                            • Remote Server is misconfigured

                                                                                                              Dear Team, I am unable to use email id as remote server is misconfigured. It would be really great if you could help on this and get this resolved. Thanks & Regard Rohit Gupta
                                                                                                            • Have Mail Lite, wish to add/purchase 2nd domain and use email

                                                                                                              Hello, I have recently created two new businesses. I have successfully used Zoho to create a domain for one business and have set up two email addresses / users on that domain. I am trying to figure out how to create a second domain, just like I did the
                                                                                                            • Zoho Learn - AI Translate

                                                                                                              Hi Learn team, I had a situation today where I was providing training to a client team and I had written articles into their Zoho Learn to support their learning. I realised that one of the team members was a non-native English speaker and they were struggling
                                                                                                            • Need support in setting up the company email and few other setups

                                                                                                              Need support in setting up the company email and few other setups
                                                                                                            • This mobile number has been marked spam.

                                                                                                              Dear zoho team, I am very happy to use zoho,because it india 🇮🇳 own app, but when we login into zoho account we facing some issue, please solve below issue ASAP. Add your mobile number As an added security measure for Accounts, you need to verify and
                                                                                                            • Add an external email to the allowed list

                                                                                                              I need to allow an external email to raise a ticket on Manage Engine ServiceDesk Plus. The external email is a outside of our domain and is not a domain user. The email address that needs to be allowed to raise a ticket request is noreply@formsatack.com.
                                                                                                            • Next Page