# CompanyInformationByChamberOfCommerceNumber Acquire company information __Activity name:__ GetCompanyInformationByChamberOfCommerceNumber This endpoint allows the user to acquire basic company information for a specific chamber of commerce number. Select loket.nl (REST) API URL: /chamberofcommerce/{chamberOfCommerceNumber}/companyinformation Insert loket.nl (REST) API URL: /chamberofcommerce/{chamberOfCommerceNumber}/companyinformation Update loket.nl (REST) API URL: /chamberofcommerce/{chamberOfCommerceNumber}/companyinformation Delete loket.nl (REST) API URL: /chamberofcommerce/{chamberOfCommerceNumber}/companyinformation Select loket.nl (REST) API Operation: get /chamberofcommerce/{chamberOfCommerceNumber}/companyinformation - Catalog: `LoketNlRest` - Schema: `ChamberOfCommerce` - Field Selection Method: NotRequired - Base Path: `content` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `chamberOfCommerceNumber` | `string` | ☑ | | The unique identifier of the kvk (8 numbers) | ## Columns of Table Function The columns of the table function `CompanyInformationByChamberOfCommerceNumber` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `address_city` | `string(24)` | | ☐ | City of the address | | `address_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `address_country_key` | `int32` | | ☐ | The key for the country. Posible values can be aquired via the metadata endpoint | | `address_country_value` | `string(50)` | | ☐ | The name of the country | | `address_houseNumber` | `int32` | | ☐ | House number of the address | | `address_houseNumberAddition` | `string(4)` | | ☐ | An addition to further specify the house/door/postbox. For example used to specifty a room of floor number in addition to the house number. | | `address_postalCode` | `string(9)` | | ☐ | The postal code of the address | | `address_street` | `string(24)` | | ☐ | Streetname of the address | | `deviatingPostalAddress_city` | `string(24)` | | ☐ | City of the address | | `deviatingPostalAddress_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `deviatingPostalAddress_country_key` | `int32` | | ☐ | The key for the country. Possible values can be aquired by the metadata endpoint | | `deviatingPostalAddress_country_value` | `string(50)` | | ☐ | The name of the country | | `deviatingPostalAddress_houseNumber` | `int32` | | ☐ | House number of the address. Filled when poBox is empty. | | `deviatingPostalAddress_houseNumberAddition` | `string(4)` | | ☐ | An addition to further specify the house/door/postbox. For example used to specifty a room of floor number in addition to the house number. | | `deviatingPostalAddress_poBox` | `int32` | | ☐ | Post office box | | `deviatingPostalAddress_postalCode` | `string(9)` | | ☐ | The postal code of the address, only nullable if country is not The Netherlands (NL). | | `deviatingPostalAddress_street` | `string(24)` | | ☐ | Streetname of the address | | `legalForm_key` | `int32` | | ☐ | The key of the legal form. Possible values can be aquired via the metadata endpoint | | `legalForm_value` | `string(50)` | | ☐ | Description of the legal form. Posible values are the legel forms supported by Dutch law | | `name` | `string(255)` | | ☐ | The company name | | `sbi_key` | `int32` | | ☐ | The key of the SBI code. Possible values can be aquired via the metadata endpoint | | `sbi_sbiCode` | `string(32)` | | ☐ | Posible values are the values from the Dutch SBI 2008 | | `sbi_value` | `string(255)` | | ☐ | Description of the SBI code | | `website` | `string(255)` | | ☐ | The website of the employer |