Need details on search criteria for zoho.crm.searchRecords
Hi,
If I understood correctly the integrated functions (getRecords, searchRecords, etc..) I can use inside Functions in Zoho CRM are actually using the Zoho CRM V2 API.
I am looking for all the field types and criteria I can use with searchRecords.
The V8 API documentation
HERE has a very nice table of all field types and criteria (See below)
But Neither:
- the integration tasks documentation
HERE- the V2 API documentation
HEREhave an equivalent of that V8 Table.
How can I get that list for V2 (and therefore the integration task) please?
V8 Table:
Note
The following section gives you the field types and the operators you can use in the criteria parameter
- Date, DateTime : equals, not_equal, greater_equal, greater_than, less_equal, less_than, between, in.
- Integer, Currency, Decimal : equals, not_equal, greater_equal, greater_than, less_equal, less_than, between, in.
- Boolean : equals, not_equal.
- textarea : equals, not_equal, starts_with.
- Lookup(user/owner) : equals, not_equal, in.
- Picklist, Autonumber : equals, not_equal, in.
- Text, Email, Phone, Website : equals, not_equal, starts_with, in.
- multiselectpicklist : equals, not_equal, in, starts_with.
- bigint: equals, not_equal, greater_than, greater_equal, less_than, less_equal, between, in.
- percent : equals, not_equal, greater_than, greater_equal, less_than, less_equal, between, in.
- formula: Operators depend on the formula's return type. Check the corresponding datatype's supported operators.