invantive documentation
Invantive Support ForumsLog In / Sign Up

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 `` 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: