/odata/v1/CBS/{tableId}/BedrijfstakkenBranchesSBI2008CodesResolve an SBI code to the branch identifier a CBS table is actually keyed on — the call that makes every other query in this listing possible. Zet een SBI-code uit het Handelsregister om naar de CBS-bedrijfstakcode. CBS carries NO SBI field: the full row schema is Identifier, Index, Title, Description, DimensionGroupId, and the SBI code appears only as the leading token of Title ("642 Financiele holdings"). Resolve with $filter=startswith(Title,'642 '), and note the TRAILING SPACE is mandatory — startswith(Title,'64') also returns 641, 642 and 649. A KVK SbiBusinessCode is usually 5 digits and CBS usually publishes coarser, so truncate one digit at a time (64210, 6421, 642, 64) and take the first hit; report which level matched, because a division-level figure presented as a subclass figure is a wrong answer that looks right. Never fall back to T001081 "A-U Alle economische activiteiten" — that is the national total, not a sector. Skip composite titles ("4711, 472 ...", "24-30, 33 ...", "B-E ...") and the unparseable ones ("SBI-code onbekend").
GET /odata/v1/CBS/{tableId}/BedrijfstakkenBranchesSBI2008Codes — SBI code to CBS branch key. Trailing space in startswith is mandatory; truncate a 5-digit KVK code until it hits; never climb to T001081.
{
"properties": {
"$filter": {
"description": "Resolution filter. Use startswith(Title,'<sbi> ') WITH a trailing space, e.g. startswith(Title,'642 '). Omit to list every branch code the table publishes.",
"required": false,
"type": "string",
"x-parameter-location": "query"
},
"$select": {
"description": "Comma-separated fields, e.g. Identifier,Title.",
"required": false,
"type": "string",
"x-parameter-location": "query"
},
"$top": {
"description": "Maximum codes to return. The largest of the curated tables publishes 1487 branch codes.",
"required": false,
"type": "integer",
"x-parameter-location": "query"
},
"tableId": {
"description": "CBS table identifier, e.g. 82244NED. All six curated tables in this listing use the BedrijfstakkenBranchesSBI2008 dimension; for any other table call /Dimensions first, because the dimension name varies.",
"pattern": "^[0-9]{5}[A-Za-z]{3}$",
"required": true,
"type": "string",
"x-parameter-location": "path"
}
},
"required": [
"tableId"
],
"type": "object"
}{
"properties": {
"value": {
"items": {
"properties": {
"Description": {
"type": "string"
},
"DimensionGroupId": {
"type": "string"
},
"Identifier": {
"description": "The opaque CBS branch key, e.g. 397200. This is what an Observations $filter compares against. It has no arithmetic relation to the SBI code.",
"type": "string"
},
"Index": {
"type": "integer"
},
"Title": {
"description": "\"<SBI token> <Dutch label>\", e.g. \"642 Financiele holdings\". The SBI token may also be a section letter (A), a range (B-E, 24-30, 33) or absent.",
"type": "string"
}
},
"type": "object"
},
"type": "array"
}
},
"type": "object"
}{
"$filter": "startswith(Title,'642 ')",
"$select": "Identifier,Title",
"tableId": "82244NED"
}{
"@odata.context": "https://datasets.cbs.nl/odata/v1/CBS/82244NED/$metadata#BedrijfstakkenBranchesSBI2008Codes(Identifier,Title)",
"value": [
{
"Identifier": "397200",
"Title": "642 Financiële holdings"
}
]
}