---
title: "LeaveImportDataByEmployerId (Loket.nl REST)"
description: "itgen_loketnl_leaveimportdatabyemployerid_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/loketnl/LoketNlRest.LeaveImport.LeaveImportDataByEmployerId
original: https://documentation.invantive.eu/en/datamodels/loketnl/LoketNlRest.LeaveImport.LeaveImportDataByEmployerId
updated: 2024-06-10T18:51:26Z
license: https://documentation.invantive.eu/en/
---

# LeaveImportDataByEmployerId: Loket.nl REST itgen_loketnl_leaveimportdatabyemployerid_plural

`read only` `REST`

- Catalog: `LoketNlRest`
- Schema: `LeaveImport`
- Label: itgen_loketnl_leaveimportdatabyemployerid_plural

Get data to create an importfile
__Activity name :__ GetLeaveImportDataByEmployerId

Returns, for the given employer, a set of data that can be used as a base for importing leave through a csv file.

Note that on importing, the columnnames must be in Dutch. (WerkgeverId	PersnrVerl	Persnr	Naam	Ingangsdatum	Einddatum	Soort	Factor	Eenheden)


Can only retrieve data.

## API Source

- Endpoint: `/providers/employers/{employerId}/import/leave"`
- Operation: `get /providers/employers/{employerId}/import/leave"`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `employerId` | `` | [x] |  | The unique identifier of the employer |

## Table Columns

The columns of the table `LeaveImportDataByEmployerId` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `employeeNumber` | `int32` | Employee Number | [ ] |  | The employee number to uniquely identify an employee within an employer  |
| `employerNumber` | `int32` | Employer Number | [ ] |  | The employer number is used in various overviews and exports to identify a specific employer in Loket (please note: this is not the identifier used in the REST API). |
| `endDate` | `datetime` | End Date | [ ] |  | The end date of the leave |
| `formattedName` | `varchar2` | itgen_loketnl_formattedname | [ ] |  | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> |
| `isAccrual` | `int64` | itgen_loketnl_isaccrual | [ ] |  | Indicates whether the request is for accrual of leave. - -1 will result in a reduction of the employee's leave entitlement - 1 will result in an increase of the employee's leave entitlement  |
| `leaveTypeKey` | `int32` | itgen_loketnl_leavetypekey | [ ] |  | The key for the leave type.  |
| `numberOfUnits` | `double` | Number of Units | [ ] |  | The number of leave units requested |
| `payrollEmployeeNumber` | `int32` | itgen_loketnl_payrollemployeenumber | [ ] |  | The number of the employment in relation to the payroll administration. |
| `startDate` | `datetime` | Start Date | [ ] |  | The start date of the leave |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Loket.nl REST](/en/release-notes/drivers?driver=loket-nl-rest)

