Read rows
query_datasetReads rows from a dataset so you can inspect or analyse what is stored (e.g. to see the latest month before adding the next one). Supports simple filters, ordering and paging. The response includes the total row count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Default 50. | |
| where | No | Filter. Equality: {"campaign": "brand"}. Operators: {"month": {"gte": "2026-01", "lt": "2026-07"}}; ops are gt, gte, lt, lte, ne, contains. | |
| offset | No | Rows to skip, for paging. Default 0. | |
| dataset | Yes | The dataset's name, e.g. "ad_spend_daily". | |
| order_by | No | Column to sort by. Defaults to key order. | |
| descending | No | Sort newest or largest first. |