Search Records

Searching Records

The zoho.crm.searchRecords() method enables you to search records in CRM by expressions of the selected columns.

Syntax

<CRM Response>= zoho.crm.searchRecords("<moduleName >", "<criteria>", fromIndex, toIndex);

where,

<CRM Response> is the map variable returned by CRM as response.

<moduleName> refers to the name of the CRM module

<criteria> must be in the following format: ( <colName> | <operator> | <colValue> )

Regular Expressions

You can specify the following expressions in the criteria :

  • is OR =
  • isn't OR <>
  • contains(*srcString*)
  • starts with(srcString*)
  • ends with(*srcString)
  • doesn't contain
  • < OR is before
  • > OR is after
  • <=
  • =>

Example

crmResp = zoho.crm.searchRecords("Leads", "(Email|=|test@zohocorp.com)");

crmResp = zoho.crm.searchRecords("Accounts","(Account Name|starts with|A*)");

  Response Format

{
"SIC Code":"0",
"Account Owner":"Test",
"Employees":"0",
"Account Name":"Test",
"Account Number":"0",
"Created By":"Test",
"ACCOUNTID":"231356000000043001","MODIFIEDBY":"231356000000034003",
"Annual Revenue":"0",
"Created Time":"2010-07-06 10:15:01",
"Modified By":"Test",
"SMOWNERID":"231356000000084003",
"SMCREATORID":"231356000000034003",
"Modified Time":"2011-11-21 10:00:14"
}

 Related Links

https://www.zoho.com/crm/help/api/getsearchrecords.html 

Share this post :

FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohodeveloper.com