Get records
Path parameters
Headers
Bearer authentication of the form Bearer <token>, where token is your auth token.
Query parameters
Deprecated, use commitId
instead.
Deprecated, use sinceCommitId
instead.
Sort direction - asc (ascending) or desc (descending)
Search for the given value, returning matching rows. For exact matches, wrap the value in double quotes (“Bob”). To search for null values, send empty double quotes ("")
The Record Ids param (ids) is a list of record ids that can be passed to several record endpoints allowing the user to identify specific records to INCLUDE in the query, or specific records to EXCLUDE, depending on whether or not filters are being applied. When passing a query param that filters the record dataset, such as ‘searchValue’, or a ‘filter’ of ‘valid’ | ‘error’ | ‘all’, the ‘ids’ param will EXCLUDE those records from the filtered results. For basic queries that do not filter the dataset, passing record ids in the ‘ids’ param will limit the dataset to INCLUDE just those specific records. Maximum of 100 allowed.
Number of records to return in a page (default 10,000)
Based on pageSize, which page of records to return (Note - numbers start at 1)
DEPRECATED Use GET /sheets/:sheetId/counts