# LeaveMetadataOptionsByEmploymentId
Get the values for the metadata fields
__Activity name :__ GetLeaveMetadataByEmploymentId
Returns the metadata values for all the metadata fields.
Select loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/leave/metadata
Insert loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/leave/metadata
Update loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/leave/metadata
Delete loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/leave/metadata
Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/{employmentId}/leave/metadata
- Catalog: `LoketNlRest`
- Schema: `Leave`
- Field Selection Method: NotRequired
- Base Path: `_embedded[*].options[*]`
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 |
|---|:---:|:---:|:---:|---|
| `employmentId` | `guid` | ☑ | | The unique identifier of the employment |
## Columns of Table Function
The columns of the table function `LeaveMetadataOptionsByEmploymentId` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `field` | `string` | | ☐ | The field name of the metadata field |
| `key` | `int32` | | ☐ | The key for the metadata field. |
| `value` | `string` | | ☐ | The description for the metadata field |