query_resource
Query Ontario open data via CKAN Datastore API with filters, field selection, sort, limit, and offset.
Instructions
Query a resource via the CKAN Datastore API (remote, no download needed).
Only works for resources with datastore_active=True.
Args: resource_id: Prefixed resource ID (e.g. "toronto:abc123") or bare ID filters: Column filters as {column: value} pairs fields: List of columns to return (default: all) sort: Sort string (e.g. "date desc", "name asc") limit: Max rows (1-1000) offset: Row offset for pagination
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| resource_id | Yes | ||
| filters | No | ||
| fields | No | ||
| sort | No | ||
| limit | No | ||
| offset | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |