get_resource_records
Retrieve data records from a CKAN datastore resource using filters, queries, and pagination to access structured open data.
Instructions
Get records from a specific datastore resource
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| resourceId | Yes | The ID of the resource to fetch records from | |
| limit | No | Maximum number of records to return | |
| offset | No | Number of records to skip (for pagination) | |
| filters | No | Datastore API filters to apply on the server (field:value mapping). | |
| q | No | Full-text query applied by CKAN's datastore_search endpoint. | |
| plain | No | When true, disables text highlighting in datastore results. | |
| distinct | No | Return only distinct rows from the datastore resource. | |
| fields | No | Subset of fields to return for each record. | |
| sort | No | Sort expression understood by datastore_search (e.g., "column desc"). | |
| includeTotal | No | Include the total record count from CKAN even when limit=0. | |
| recordsFormat | No | Optional datastore output format (e.g., objects or lists). |