List Records
Finds records in a Grist table.
GET
Query
Arguments
stringrequired
Document ID
stringrequired
Table ID (e.g. Table1)
number
Max records to return
Uncommon arguments
string
JSON filter object, e.g. {"Name": ["Alice"]}
string
Comma-separated columns, prefix - for desc
boolean
Include hidden columns
FiltersNarrow list results with a provider-supported where expression. Learn more
string
RSQL expression used to filter list results.
SortingChoose the order of returned rows when this action supports sorting. Learn more
string
Comma-separated sort fields; prefix with - for descending.
Field selectionChoose which fields should be included in the response. Learn more
string
Comma-separated response fields to include.