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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"dataset": "<dataset>"
},
"name": "query_dataset"
}
}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. |