get_table_data
Query a table's data and return it as labeled rows.
Direct GET
For navigating agents: open the HTML page with parameters in the URL. The result is fetched and displayed without screenshots or form filling.
https://allemannsdata.com/wiki/kilder/fhi/get_table_data/?source_id={source_id}&table_id={table_id}&selections={selections}&limit=25&offset=0
For software and dashboards:
Read the operation descriptor.
The JSON GET template is https://allemannsdata.com/wiki/api/v1/kilder/fhi/get_table_data?source_id={source_id}&table_id={table_id}&selections={selections}&limit=25&offset=0.
| Parameter | Requirement | JSON type | Description |
|---|---|---|---|
source_id | required | string | Source id from list_sources(), e.g. "abr". |
table_id | required | integer | Table id from search_tables(), e.g. 588. |
selections | optional | union | Dict of {dimension_code: [value_codes]}, codes from get_table_dimensions(). Any dimension you omit is filled with ALL its values, so only specify the ones you want to narrow, but narrow enough that the result stays under 50000 cells. Example: {"AARGANG": ["2023", "2024"], "MEASURE_TYPE": ["ANTALL"]} |
limit | optional | integer | Gateway page size; default 25, maximum 100. |
offset | optional | integer | Number of list items to skip; default 0. |
Generated JavaScript, Python and response structure
Use JSON when the user requests code, machine-readable data, value extraction or further computation. Use the HTML GET page to identify the correct source and verify parameters.
Example for generated JavaScript and Python
https://allemannsdata.com/wiki/api/v1/kilder/fhi/get_table_data?source_id={source_id}&table_id={table_id}&selections={selections}&limit=25&offset=0
Replace URL placeholders and remove unused optional parameters.
JavaScript in a dashboard
const url = "https://allemannsdata.com/wiki/api/v1/kilder/fhi/get_table_data?source_id={source_id}&table_id={table_id}&selections={selections}&limit=25&offset=0";
const response = await fetch(url);
if (!response.ok) {
const failure = await response.json();
throw new Error(`${failure.error.code}: ${failure.error.message} ${failure.suggestion}`);
}
const result = await response.json();
const data = result.data;
Python without additional packages
import json
from urllib.request import urlopen
url = "https://allemannsdata.com/wiki/api/v1/kilder/fhi/get_table_data?source_id={source_id}&table_id={table_id}&selections={selections}&limit=25&offset=0"
with urlopen(url) as response:
result = json.load(response)
data = result["data"]
Response structure
{
"source": "fhi",
"operation": "get_table_data",
"parameters": {},
"data": {},
"entities": [],
"_meta": {"retrieved_at": "...", "sources": [], "cache": {}},
"_links": {"self": "...", "source": "...", "wiki": "..."}
}
Form for manual use
The form is a fallback for people and browser agents that cannot open the GET URL directly.
Continue exploring
- Back to FHI Statistics
- All sources in Health, food safety and education
- Search for FHI Statistics in the wiki
How an AI agent should use this page
Ground rule: Navigate with HTML GET links to keep explanations and relationships. Use the page's JSON alternative only when concrete values must be extracted, compared or computed.
How to use the get_table_data lookup
- Replace the placeholders in the HTML GET template; remove optional parameters you do not need.
- Check types, units, limits and ID formats in the parameter table.
- Follow linked results to canonical pages before combining sources.
Misreading to avoid: An empty list means "no results for this lookup". An error message or unavailable source does not mean the data does not exist.
Source-specific next step
Go to the source page for other operations. Use the JSON template only after the HTML result shows that the parameters and source are correct.
AI agent? Read the complete navigation and programming guide.