# AvailableApplicationsByEmployerId__embeddedTargetIndustries List of all the applications available to the employer __Activity name:__ GetAvailableApplicationsByEmployerId List of all the applications and premium modules available to the employer. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `Marketplace` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | ## Columns The columns of the table `AvailableApplicationsByEmployerId__embeddedTargetIndustries` 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` | ID | ☐ | 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) | | `key` | `guid` | Key | ☐ | The unique identifier of an object (GUID/UUID) | | `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)` | Name | ☐ | | | `productType_key` | `int32` | | ☐ | The key of the product type. Possible values: 1. Koppeling 2. Module | | `productType_value` | `string(50)` | | ☐ | Description of the product. | | `value` | `string` | Value | ☐ | - accountancy & administratie - agrosector - bouw, installatie & infrastructuur - cultuur & sport - energie - financiële dienstverlening - gezondheidszorg & maatschappelijke dienstverlening - groothandel - horeca - ICT, media & communicatie - industrie - kinderopvang - onderwijs & training - onroerend goed - persoonlijke dienstverlening & non-profit - retail - vervoer, post & opslag - water & afval - zakelijke dienstverlening | | `website` | `string` | | ☐ | An URI to the website of the application |