get_sdmx_rows
Returns SDMX observations as inline rows for embedding in charts, tables, or widgets, enabling data inclusion at construction time and easy sorting/filtering of small result sets.
Instructions
Fetch SDMX observations and always return rows inline — use this when you need to embed data in an artifact or widget.
Use this tool when you need rows embedded directly in an artifact or widget:
Building a chart, table, or widget artifact that needs data at construction time
Sorting/filtering a small result set before embedding
Same key syntax and time parameters as get_sdmx_data — see that tool's description for key construction rules and wildcard warnings.
Rows are capped at MAX_SDMX_ROWS. For large dimensions use get_sdmx_key_for_dimension to build a precise OR key before calling this.
IMPORTANT: In your final response to the user, cite the _sdmx_url, table productId, and key used.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | Dot-separated dimension codes in position order (e.g. '1.2.1'). Use '+' for OR ('1+2.2.1' = Geography 1 or 2). Omit a value for wildcard ('.2.1' = all geographies, Gender=2, Age=1). Code numbers match WDS memberIds — no translation needed. Call get_sdmx_structure first to see dimension positions and valid codes. | |
| endPeriod | No | End period in YYYY or YYYY-MM format. | |
| productId | Yes | ||
| startPeriod | No | Start period in YYYY or YYYY-MM format. | |
| lastNObservations | No | Return only the last N observations per series (e.g. 12 for one year of monthly data). |