Query a dataset
query_datasetFetch rows or per-column statistics from Danish energy datasets, filtered by time range, columns, and allowed values.
Instructions
Fetch rows from any dataset. start/end filter on the dataset's own time column (see describe_dataset). Keep results small: name the columns you need, and use summary=true to get per-column statistics instead of rows when the range is long. Amounts and units are whatever the dataset documents; this tool does not convert them.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end | No | End of the period, excluded. Danish local time. Either a timestamp (2026-01-01 or 2026-01-01T00:00) or a relative expression: now, StartOfDay, StartOfMonth, StartOfYear, optionally with an ISO 8601 offset such as now-P1D, now-PT15M, StartOfYear, now+P1D. | |
| sort | No | e.g. 'HourUTC desc' or 'PriceArea,HourUTC'. Defaults to newest first. | |
| limit | No | Maximum rows (default 200, or 5000 when summary=true). 0 is rejected here: to this API it means every row ever. | |
| start | No | Start of the period, included. Danish local time. Either a timestamp (2026-01-01 or 2026-01-01T00:00) or a relative expression: now, StartOfDay, StartOfMonth, StartOfYear, optionally with an ISO 8601 offset such as now-P1D, now-PT15M, StartOfYear, now+P1D. | |
| filter | No | Column to allowed values, e.g. {"PriceArea": ["DK1", "DK2"]}. Values within a column are OR-ed, columns are AND-ed. | |
| offset | No | Rows to skip, for paging through a large result | |
| columns | No | Columns to return. Omitting this returns all of them, which is often far more than you need. | |
| dataset | Yes | Exact datasetName from list_datasets | |
| summary | No | Return min/max/mean/sum per numeric column and the distinct values of category columns, instead of the rows themselves |