Get record cells by field
Returns record cell values grouped by all fields in the sheet
Path parameters
sheetId
ID of sheet
Headers
Authorization
Bearer authentication of the form Bearer <token>, where token is your auth token.
X-Disable-Hooks
Query parameters
fieldKey
Returns results from the given field only. Otherwise all field cells are returned
sortField
Name of field by which to sort records
sortDirection
Sort direction - asc (ascending) or desc (descending)
Allowed values:
filter
Options to filter records
Allowed values:
filterField
Name of field by which to filter records
pageSize
Number of records to return in a page (default 1000 if pageNumber included)
pageNumber
Based on pageSize, which page of records to return
distinct
Must be set to true
includeCounts
When both distinct and includeCounts are true, the count of distinct field values will be returned
searchValue
A value to find for a given field in a sheet. Wrap the value in "" for exact match
q
An FFQL query used to filter the records to be queried
Response
This endpoint returns an object.
data
Cell values grouped by field key