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

# SepaFileBySepaFileId: Loket.nl REST itgen_loketnl_sepafilebysepafileid_plural

`read only` `REST`

- Catalog: `LoketNlRest`
- Schema: `PayrollRunDownloads`
- Label: itgen_loketnl_sepafilebysepafileid_plural

Download a SEPA file
__Activity name :__ GetSepaFileBySepaFileId

Returns the specified SEPA payments file as a XML file.

Can only retrieve data.

## API Source

- Endpoint: `/providers/employers/payrolladministrations/payrollruns/sepafiles/{sepafileId}`
- Operation: `get /providers/employers/payrolladministrations/payrollruns/sepafiles/{sepafileId}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `batchBooking` | `` | [ ] |  | Determines whether the Batch Booking \<BtchBookg\> tag is included in the SEPA file and if it is which value it is set to.  By defualt this value is set to Exclude.  Possible values for this parameter are: - Exclude: Do not include \<BtchBookg\> tag in SEPA file - IncludeTrue: Include \<BtchBookg\> tag in SEPA file and set it to 'True' - IncludeFalse: Include \<BtchBookg\> tag in SEPA file and set it to 'False'  (Waarden: BtchBookgExclude, BtchBookgTrue, BtchBookgFalse) |
| `paymentType` | `` | [ ] |  | Indicates the type of payment for the SEPA file. In case salary is selected the following will be included in the SEPA xml file ```   <CtgyPurp>     <Cd>SALA</Cd>   </CtgyPurp> ``` (Waarden: Other, Salary) |
| `requestedExecutionDate` | `` | [x] |  | This value is used when creating the (non) sepa file to set the value of \<ReqdExctnDt\> |
| `sepafileId` | `` | [x] |  | Sepa file ID |

## Table Columns

The columns of the table `SepaFileBySepaFileId` 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 |
|---|---|---|:---:|---|---|
| `DOCUMENT` | `blob` | Document | [ ] |  |  |



## 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)

