{"source":"fhi","operation":"get_table_data","description":"Query a table's data and return it as labeled rows.","parameters":[{"name":"source_id","schema":{"type":"string"},"required":true,"default":null,"description":"Source id from list_sources(), e.g. \"abr\"."},{"name":"table_id","schema":{"type":"integer"},"required":true,"default":null,"description":"Table id from search_tables(), e.g. 588."},{"name":"selections","schema":{"anyOf":[{"additionalProperties":true,"type":"object"},{"type":"null"}]},"required":false,"default":null,"description":"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\"]}"},{"name":"limit","type":"integer","schema":{"type":"integer","minimum":1,"maximum":100,"default":25},"display_type":"integer","required":false,"default":25,"description":"Maximum list items returned by the gateway (default 25, maximum 100)."},{"name":"offset","type":"integer","schema":{"type":"integer","minimum":0,"default":0},"display_type":"integer","required":false,"default":0,"description":"Number of list items to skip before returning the page."}],"json_get_url_template":"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","schema_scope":"#/data in the successful operation envelope","response_schema":{"type":"object","properties":{"source_id":{"type":["string","null"]},"table_id":{"type":["string","null"]},"title":{"type":["string","null"]},"updated":{"x-allemannsdata-schema-status":"unresolved","description":"Response shape is not yet declared; any JSON value is permitted."},"unit":{"anyOf":[{"type":"null"},{"type":["string","null"]}]},"rows":{"type":"array","items":{"type":"object","properties":{"value":{"x-allemannsdata-schema-status":"unresolved","description":"Response shape is not yet declared; any JSON value is permitted."}},"additionalProperties":false}},"total_cells":{"x-allemannsdata-schema-status":"unresolved","description":"Response shape is not yet declared; any JSON value is permitted."},"truncated":{"type":"boolean"}},"additionalProperties":false},"response_schema_status":{"status":"incomplete","codegen_safe":false,"description":"Not suitable for typed model generation: the container shape and field names are useful, but unresolved values accept any JSON value."},"entity_projection":{"status":"projected","entity_types":["statistical_table"],"description":"Recognized records and stable operation identifiers are projected; an empty array means the successful payload contained no recognizable entity."},"error_contract":{"scope":"top-level HTTP error response; never part of a success payload","schema":{"type":"object","properties":{"error":{"type":"object","properties":{"code":{"type":"string"},"message":{"type":"string"},"retryable":{"type":"boolean"},"details":{"type":"object"}},"additionalProperties":false,"required":["code","message","retryable"]},"suggestion":{"type":"string"},"_meta":{"type":"object","properties":{"retrieved_at":{"type":"string","format":"date-time"},"language":{"type":"string","const":"en"},"content_languages":{"type":"array","items":{"type":"string"}},"sources":{"type":"array","items":{"type":"object"}}},"required":["retrieved_at","language","content_languages","sources"]},"_links":{"type":"object","properties":{"self":{"type":"string","format":"uri"},"api_index":{"type":"string","format":"uri"}},"required":["self","api_index"],"additionalProperties":false}},"additionalProperties":false,"required":["error","suggestion","_meta","_links"]},"statuses":{"400":{"codes":["MISSING_PARAMETER","INVALID_PARAMETER","INVALID_REQUEST"],"retryable":false},"404":{"codes":["SOURCE_NOT_FOUND","OPERATION_NOT_FOUND","ENTITY_NOT_FOUND"],"retryable":false},"429":{"codes":["RATE_LIMITED","GATEWAY_RATE_LIMITED"],"retryable":true},"502":{"codes":["SOURCE_UNAVAILABLE"],"retryable":true},"500":{"codes":["INTERNAL_ERROR"],"retryable":true}}},"_links":{"self":"https://allemannsdata.com/wiki/api/v1/kilder/fhi/get_table_data/schema","operation":"https://allemannsdata.com/wiki/api/v1/kilder/fhi/get_table_data","source":"https://allemannsdata.com/wiki/api/v1/kilder/fhi"},"output_fields":["source_id","table_id","title","updated","unit","rows","rows[].value","total_cells","truncated"],"output_fields_truncated":false,"canonical_field_aliases":{"name":["title"]}}