# AssessmentsByEmployerId List of assessments __Activity name :__ GetAssessmentsByEmployerId <span style="color:red">========== This endpoint is still under development and cannot be used yet. Subscribe to the newsletter to receive updates. ==========</span> Retrieve a list of assessments. Select loket.nl (REST) API URL: /providers/employers/{employerId}/assessments Insert loket.nl (REST) API URL: /providers/employers/{employerId}/assessments Update loket.nl (REST) API URL: /providers/employers/{employerId}/assessments Delete loket.nl (REST) API URL: /providers/employers/{employerId}/assessments Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/assessments - Catalog: `LoketNlRest` - Schema: `Assessment` - 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 `AssessmentsByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `invitedDate` | `datetime` | | ☐ | The date on which the invite for the Assessment was send | | `participant_email` | `string` | | ☐ | The email adresses of the initiator | | `participant_employeeOrConceptEmployee` | `string` | | ☐ | This field determines what the id belongs to. It may belong to an employee or a concept employee or no associated entity was found. | | `participant_firstName` | `string` | | ☐ | The first name of the initiator | | `participant_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `participant_lastName` | `string` | | ☐ | The last name of the initiator | | `requestedBy_email` | `string` | | ☐ | The email adresses of the initiator | | `requestedBy_firstName` | `string` | | ☐ | The first name of the initiator | | `requestedBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `requestedBy_lastName` | `string` | | ☐ | The last name of the initiator | | `resultUrl` | `string` | | ☐ | The url on which the report can be found | | `status` | `string` | | ☐ | |