lookup_table_cells
Look up cells in a table a page at a time, returning cell IDs and row IDs alongside their values. Pass match to find particular rows and columnNames to limit the columns. The result’s page says how many rows there are; pass page.nextOffset to continue. Essential before setting linked identifiers, linkCell values, oneMany references, or formula expressions. For linked identifiers: use the returned rowId to build {“linkedTableId”: tableId, “linkedRowId”: rowId}. Returns rows with { rowId, cells: [{ cellId, columnName, columnType, value, isIdentifier }] }.
Parameters
string
required
array<string>
Limit results to these columns. Omit for all columns.
object
Return only the rows matching one condition, instead of reading the whole table — a large table does not fit in one result. Examples: {“column”: “Cause Uid”, “value”: “CAUSE-202608-0042”}, {“column”: “Binding Deadline”, “op”: “on_or_before”, “value”: “2026-09-29”}, {“column”: “Dollars At Risk”, “op”: “gte”, “value”: 500}.
integer
Where to start. Pass the previous result’s page.nextOffset. Minimum: 0.
integer
How many to return at most; the result may hold fewer to fit. Minimum: 1.