Datastore Query
datastore_queryRead actual table rows from a Jersey resource via CKAN datastore_search. Works only for resources with datastore_active=true (get the resource_id from dataset_details). Returns parsed records plus field definitions — e.g. population projections by Year/Age/Sex.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Full-text filter across the table. | |
| limit | No | Max rows, 1-32000 (default 100). | |
| offset | No | 0-based row offset for paging. | |
| filters | No | Exact-match column filters, e.g. {"Sex":"F","Year":2025}. | |
| resource_id | Yes | Resource UUID from dataset_details, e.g. "6e222cd7-d296-429a-abea-09001dcc45f6". |