# AvailableApplicationsByEmployerId List of all the applications available to the employer __Activity name:__ GetAvailableApplicationsByEmployerId List of all the applications available to the employer. Select loket.nl (REST) API URL: /providers/employers/{employerId}/applications Insert loket.nl (REST) API URL: /providers/employers/{employerId}/applications Update loket.nl (REST) API URL: /providers/employers/{employerId}/applications Delete loket.nl (REST) API URL: /providers/employers/{employerId}/applications Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/applications - Catalog: `LoketNlRest` - Schema: `Application` - Field Selection Method: NotRequired - Base Path: `_embedded[*]` 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 | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | ## Columns of Table Function The columns of the table function `AvailableApplicationsByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activationUrl` | `string` | | ☐ | An URI to a webpage of the application where the user can initiate the integration. | | `dateAddedToStore` | `datetime` | | ☐ | The date to which the application was added to the store | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `isActivatedForEmployer` | `boolean` | | ☐ | Indicates whether the application is configured for the given employer. If one (or more) users with access to the employer have a connection with the application (the isBlocked boolean from both application and application user are ignored for this field) | | `isHighlighted` | `boolean` | | ☐ | Indicates whether the application is highlighted (shown at the top of the list by default) | | `logo` | `string` | | ☐ | An URI to the logo of the application | | `marketplaceDescription` | `string` | | ☐ | A description of the application. The description must be in HTML. | | `marketplaceSummary` | `string(200)` | | ☐ | A short summary of the application. The description must be in plain text. | | `name` | `string(100)` | | ☐ | | | `website` | `string` | | ☐ | An URI to the website of the application |