query_rows
Rows of a data table as JSON objects keyed by column name, plus each row's id (for update_rows and delete_rows). where: { "": value } matches exactly (case-insensitive; select columns by option name; a multi-select contains it), or an operator: {"not": v}, {"in": [a, b]}, {"contains": "text"}, {"empty": true}, {"gt"|"gte"|"lt"|"lte": n or "YYYY-MM-DD"}. All conditions must match. sort: [{ column, desc }]. Pages: pass the cursor you got back for the next page (null: no more).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | ||
| limit | No | default 50, max 500 | |
| table | Yes | the data table's id or name (list_data_tables) | |
| where | No | ||
| cursor | No | ||
| workspace | No | Which Caddie: leave it out for the user's personal one, or give a team workspace's name or id (list_workspaces). Use the same one you found the item in. |