# AddressByPostalCodeAndHouseNumber Acquire the address for a combination of `postalCode` and `houseNumber` __Activity name :__ GetAddressyByPostalCodeAndHouseNumber Acquire the address for a combination of `postalCode` and `houseNumber`. Only Dutch addresses are supported. Both the postalCode and houseNumber have to be specified as query parameters to perform a succesful call to this endpoint. The city and street name returned by this endpoint are according to the nen standard Select loket.nl (REST) API URL: /locationservices/address Insert loket.nl (REST) API URL: /locationservices/address Update loket.nl (REST) API URL: /locationservices/address Delete loket.nl (REST) API URL: /locationservices/address Select loket.nl (REST) API Operation: get /locationservices/address - Catalog: `LoketNlRest` - Schema: `Address` - 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 | |---|:---:|:---:|:---:|---| | `houseNumber` | `int64` | ☑ | | A valid house number (without addition) | | `postalCode` | `string` | ☑ | | A valid postal code | ## Columns of Table Function The columns of the table function `AddressByPostalCodeAndHouseNumber` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `city` | `string(24)` | | ☐ | City of the address | | `coordinates_latitude` | `decimal` | | ☐ | Lattitude of the location | | `coordinates_longitude` | `decimal` | | ☐ | Longitude of the location | | `houseNumber` | `int32` | | ☐ | House number of the address | | `postalCode` | `string(9)` | | ☐ | The postal code of the address | | `province_key` | `int32` | | ☐ | The key for the province. Posible values can be aquired via the metadata endpoint | | `province_value` | `string(50)` | | ☐ | The name of the province. Only the Dutch provices are supported and not translated | | `street` | `string(24)` | | ☐ | Streetname of the address |