Fetch Records from Table
Retrieves records from a table in Zoho Sheet.
Query
The workbook resource ID.
Name of the table whose records needs to be fetched
Optional parameter. Can be used to filter records. Provide this value as a valid JSON string.
Required when more than 1 criteria is available under criteria_json
Optional parameter. Can be used to read particular columns data. By default all the columns data will be available in response. Multiple column names must be separated by comma.
Optional parameter. It defines how the value should be rendered. Possible options are formatted, unformatted, and formula.
Optional parameter. It denotes the number of records.
Optional parameter. By default it is true. Can be set as false for case insensitive search.
Alternatively table_id can be used instead of table_name
Comma-separated response fields to include.