get_release_tables
Fetch a FRED release's table hierarchy: sections, tables, and series rows. Optionally include observation values for a specific date.
Instructions
Fetch a FRED release's table tree — the nested layout (sections, tables, and the series rows beneath them) it uses to present its series. Optionally scope to the subtree rooted at one element id, and optionally fold each series row's observation value (at observation_date, or FRED's latest) into the tree via include_observation_values. Returns the tree as structured JSON, with each element's children nested under it. Note: element_id takes precedence over release_id — FRED resolves the element by its own id, so an element from another release yields that release's subtree. Note: each returned row's observation_date is FRED's display label (e.g. "Jun 2026"), not an ISO YYYY-MM-DD date like the inputs — it is not round-trippable back into any date parameter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| element_id | No | Return only the subtree rooted at this element id (omit for the whole tree). Takes precedence over `release_id`: FRED resolves the element by its own id, so if it belongs to a different release you get *that* release's subtree and `release_id` is effectively ignored. Pass an element that belongs to `release_id`. | |
| release_id | Yes | The FRED release id, e.g. 10 (Consumer Price Index). | |
| observation_date | No | Observation value as of this date, `YYYY-MM-DD`. Implies `include_observation_values`. | |
| include_observation_values | No | Fold each series row's observation value into the tree (structure-only otherwise). FRED returns its latest value unless `observation_date` is set. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | The name of the requested element, when a subtree was requested. | |
| roots | Yes | The root elements of the tree, ordered by element id. (FRED's redundant top-level `release_id` — a string, unlike the numeric one on each element — is dropped; the caller already knows it.) On the wire FRED names this `elements` (a flattened object keyed by id); we read that, keep only the tree's true roots, and re-serialize as a `roots` array (see `roots_from_map`). | |
| element_id | Yes | The id of the requested element, when a subtree was requested. |