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

# JournalRunExportAuditTrailByJournalRunId: Loket.nl REST itgen_loketnl_journalrunexportaudittrailbyjournalrunid_plural

`read only` `REST`

- Catalog: `LoketNlRest`
- Schema: `JournalRun`
- Label: itgen_loketnl_journalrunexportaudittrailbyjournalrunid_plural

List export attempts for a journal run
__Activity name :__ GetJournalRunExportAuditTrailByJournalRunId

Returns the export audit trail for a journal run


Can only retrieve data.

## API Source

- Endpoint: `/providers/employers/payrolladministrations/journalruns/{journalrunId}/exportAuditTrail`
- Operation: `get /providers/employers/payrolladministrations/journalruns/{journalrunId}/exportAuditTrail`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `journalrunId` | `` | [x] |  | The unique identifier of the payroll run |

## Table Columns

The columns of the table `JournalRunExportAuditTrailByJournalRunId` 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 |
|---|---|---|:---:|---|---|
| `exportedBy_formattedName` | `varchar2` | itgen_loketnl_exportedby_formattedname | [ ] |  | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> |
| `exportedBy_id` | `guid` | itgen_loketnl_exportedby_id | [ ] |  | The unique identifier of an object (GUID/UUID) |
| `exportedBy_initials` | `varchar2(6)` | itgen_loketnl_exportedby_initials | [ ] |  | The initials of the user |
| `exportedBy_lastName` | `varchar2(25)` | itgen_loketnl_exportedby_lastname | [ ] |  | The last name of the user |
| `exportedBy_prefix` | `varchar2(10)` | itgen_loketnl_exportedby_prefix | [ ] |  | The prefix of the user |
| `exportedOn` | `datetime` | itgen_loketnl_exportedon | [ ] |  | The time at which the export was started |
| `exportedTo_key` | `int32` | itgen_loketnl_exportedto_key | [ ] |  |  |
| `exportedTo_value` | `varchar2` | itgen_loketnl_exportedto_value | [ ] |  |  |
| `exportStatus_key` | `int32` | itgen_loketnl_exportstatus_key | [ ] |  | The status of the export (succesfull or failed)              |
| `exportStatus_value` | `varchar2` | itgen_loketnl_exportstatus_value | [ ] |  | The value describing the current status of the payroll run. |
| `id` | `guid` | ID | [ ] |  | The unique identifier of an object (GUID/UUID) |
| `methodOfExporting_key` | `int32` | itgen_loketnl_methodofexporting_key | [ ] |  |  |
| `methodOfExporting_value` | `varchar2` | itgen_loketnl_methodofexporting_value | [ ] |  |  |
| `returendErrorMessage` | `varchar2(4000)` | itgen_loketnl_returenderrormessage | [ ] |  | Incase the export (by means of an API) failed the returned errors are provided here. |
| `sequenceNumber` | `int32` | Sequence Number | [ ] |  | Ascending sequence number over ALL journal runs within a yearfor the payroll administration. |



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

