get_first_datastore_resource_records
Retrieve data records from the primary datastore resource within a CKAN dataset, supporting filtering, sorting, and pagination for analysis.
Instructions
Get records from the first active datastore resource in a dataset
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| packageId | Yes | The ID of the dataset containing the resource | |
| limit | No | Maximum number of records to return | |
| offset | No | Number of records to skip before returning results | |
| 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). |