Zoho TablesInstall

Summary

Search for records in a Zoho Table based on specified criteria and options.

Inputs

• authentication (required) — The authentication method to access Zoho Tables, defaulting to OAuth2.
• portal (required) — The ID or name of the Zoho Tables portal containing the records.
• workspace (required) — The ID or name of the workspace within the portal.
• base (required) — The ID or name of the base containing the table.
• table (required) — The ID or name of the table from which to fetch records.
• criteria — A string defining the conditions to filter records; if empty, all records will be included.
• count — The maximum number of results to return, with a default of 100.
• options — Additional search options, including case sensitivity and whether to limit results to the first match.

Output shape

a list of matching records

Results will depend on the specified criteria and options. If the criteria is empty, all records will be returned, up to the limit set.

Examples

Example 1: Fetch all records where 'Name' is 'Rajin' and 'Amount' is greater than 30.

Set the criteria to '({Name} = "Rajin") and "Amount" > "30"' and define the limit as needed.