Skip to main content
lookup_table_rows Find records (rows) in a table and their rowIds, a page at a time. Rows come back in table order, each with its identifier (primary key) value and a preview of the first few columns. Without query, rowIndex is the row’s position in the table (1-based), so ‘the 2nd row’ is rowIndex 2. With query, only rows whose identifier contains that text (case-insensitive) are returned, e.g. ‘David Smith’. The result’s page says how many rows there are; pass page.nextOffset to continue.

​
Parameters

​
string
required
The ID of the table to look up rows in.
​
string
Optional: text the row’s identifier value must contain (case-insensitive).
​
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.