---
title: "Get data to create an importfile"
method: GET
path: "/v2/providers/employers/payrolladministrations/{payrollAdministrationId}/import/wage\""
tags: ["Wage import"]
---

# Get data to create an importfile

`GET /v2/providers/employers/payrolladministrations/{payrollAdministrationId}/import/wage"`

## Request

- Base URL: `https://api.loket.nl`
- URL: `https://api.loket.nl/v2/providers/employers/payrolladministrations/{payrollAdministrationId}/import/wage"`
- Auth: none required

__Activity name :__ <a href="https://developer.loket.nl/Activities/GetWageImportDataByPayrollAdministrationId" target="_blank">GetWageImportDataByPayrollAdministrationId</a>

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

Note that on importing, the columnnames must be in Dutch. (Clientnr	PersnrVerl	Persnr	Naam	Ingangsdatum	Basisloon BasisloonEenheid Nettoloon NettoloonEenheid Loonkosten LoonkostenEenheid)

## Path parameters

- `payrollAdministrationId` string, uuid, required

## Query parameters

- `filter` string
- `orderBy` string
- `pageNumber` integer
- `pageSize` integer

## Headers

- `Authorization` string, required
- `Accept` string, required

## Response `200`

OK

- object: a warning indacateds that the given payload is valide, however take notice of the warning this might ifluence behavour.
  - `version` Version
    - `obsoleteDate` string, date, nullable: The date (can be null) on which the `resourceVersion` is no longer supported/available
    - `resourceVersion` string, date: The resource version of the object in the response
  - `messages` object[]
    - `type` string: Indication of the type of message. See [the general documentation for more information](./#section/Response/Messages)
    - `description` string: Describes the message
    - `id` string, uuid, nullable: In some cases when the message may relate to a specific entity, or specific group of entities, this field provides the identifier of that entity
    - `code` integer: Identifying code for the message
    - `properties` string[]: An array that can contain additional information
  - `_embedded` WageImportData[]
    - `clientNumber` integer: 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).
    - `payrollEmployeeNumber` integer: The number of the employment in relation to the payroll administration.
    - `employeeNumber` integer: The employee number to uniquely identify an employee within an employer
    - `formattedName` string: preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\>
    - `startDate` string, date: The start date of the Wage
    - `grossWage` number, double, nullable: The gross wage for the employee
    - `grossWageTypeKey` integer
    - `netWage` number, double, nullable: Net wage for the employment
    - `netWageTypeKey` integer
    - `employerCosts` number, double, nullable: The cost for the employer for this employee.
    - `employerCostsTypeKey` integer

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `403`: Forbidden
- `404`: Not Found
- `500`: Internal Server Error

---

[API](https://skmtc.dev/loket/apis/loket-api.md) - [All operations](https://skmtc.dev/loket/apis/loket-api/llms.txt) - [OpenAPI document](https://skmtc.dev/loket/apis/loket-api/revisions/32170564148f?raw)