Developer APIResourcesData tables

Query records (v1)

Queries records in a data table based on filters you specify. Refer to Where field structure for information on how to add a set of conditions to filter the records you query.

QUERY RECORDS META-FIELDS
The following meta-fields can be used in select and order parameters with the fields you created: $record_id, $created_at, and $updated_at.

Path parameters

data_table_idstringRequired

The ID of the data table that contains the record you plan to update. You can use the List data tables endpoint to retrieve data table IDs.

Headers

AuthorizationstringRequired

Bearer authentication of the form Bearer <token>, where token is your auth token.

Response

Success reply
selectlist of any or null
Provide the list of columns to be retrieved from the data table.
wherestring or null
Set of conditions to filter the records.
orderstring or null

The column to order the results with. Provide either a string, or a hash for more advanced ordering configuration.

timezone_offset_secsinteger or null

The time zone offset for query. Required if the query includes comparison of a date-time field to a date value.

limitinteger or null
Limits the number of records to be returned per page.
continuation_token string or null
Provide the next page token from previous page's request to fetch the next set of results of the same query.

Errors