Query
queryQuery records from a SNCF Open Data dataset with ODSQL. Filter (where), aggregate (group_by/select), sort (order_by), paginate (limit/offset).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max records (1-100, default 20). | |
| query | No | Free-text keyword across all fields (optional). | |
| where | No | ODSQL filter, e.g. `year >= 2020 AND city = "Paris"` (overrides query). | |
| offset | No | Pagination offset (default 0). | |
| select | No | ODSQL select/aggregation, e.g. `count(*) as n, sum(amount)`. | |
| group_by | No | ODSQL group_by field(s). | |
| order_by | No | Sort, e.g. `date desc`. | |
| dataset_id | Yes | Dataset id from search_datasets. |