# PayslipPayrollPeriodsByEmploymentIdAndPayrollRunId Download payslips of an employment for a payrollrun __Activity name :__ GetPayslipsByEmploymentIdAndPayrollRunId __Availability:__ This is endpoint is available for the Loket.nl application only. It is not available for external parties Download the payslips or its underlying payroll results of an employment for the specified payrollrun **Please note: this endpoint has two types of output:** * the payslip(s) as a single PDF-file * the underlying payroll result data for the payslip(s) in JSON-format This may be specified by providing the desired format in the `Accept` header of your request. 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: `Payslip` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | | `payrollrunId` | `guid` | ☑ | | The unique identifier of the payroll run | ## Columns The columns of the table `PayslipPayrollPeriodsByEmploymentIdAndPayrollRunId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollPeriod_periodEndDate` | `datetime` | Payroll Period End Date | ☐ | The last day of the period for which the tax return message was created | | `payrollPeriod_periodNumber` | `int32` | Payroll Period Number | ☐ | The period number of the payroll period the record relates to | | `payrollPeriod_periodStartDate` | `datetime` | Payroll Period Start Date | ☐ | The first day of the period for which the tax return message was created | | `payrollPeriod_testYear` | `boolean` | Payroll Processing Period Test Year | ☐ | Indicates whether the payroll periode is part of a test year. In Loket it is possible to run a year of a payrolladministration as a so-called test year. This is typically done to test the configuration of a new payroll administration, by running payrollruns within the context of a test year. Please note: if the payroll run belongs to a test year the results of the run should not be regarded as actual data but as test data. | | `payrollPeriod_year` | `int32` | Payroll Processing Year Period | ☐ | The year of the payroll period the record relates to |