query_data_table
Fetch specific records from a Workato Data Table by applying filters, selecting fields, ordering, and paginating results.
Instructions
Query rows in a Workato Data Table (its record API, on a separate host). table_id is the table UUID from list_data_tables. Optional where_json is a JSON filter like {"Status":{"$eq":"Approved"}} (operators: $eq,$ne,$gt,$gte,$lt,$lte,$in,$starts_with,$and); select_json is a JSON array of field names; limit defaults to 20; order is a field name. Returns rows as name->value dicts including $record_id.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| order | No | ||
| table_id | Yes | ||
| where_json | No | ||
| select_json | No | ||
| continuation_token | No |