Trying another endpoint (TotalSepaFileByPayrollRunId) I get a similiar response. Is this also not implemented yet? Response: itgensgr045 The table ‘LoketNlRest.PayrollRunDownloads.TotalSepaFileByPayrollRunId’ must produce data in at least one of the supported MIME-types: application/json, applic…

There is a metadata issue on the Loket specification for XML-documents. Currently an error will occur on binary XML (itgenrst004). Once the metadata is corrected, the query will work. There are no plans to implement a workaround. A manual workaround would be to use NativeScalarRequests to construct …

The message code itgensgr045 signals that the Loket API specification provides the data on TotalSepaFileByPayrollRunId in a format not yet supported. Currently the following formats are supported: application/json application/pdf text/plain text/csv However, the message does not yet clearly displ…

Tried again today: SQL: select * from LoketNlRest.PayrollRunDownloads.TotalSepaFileByPayrollRunId('{validPayrollRunId}' , 'Salary', 'BtchBookgTrue', '2019-08-24') limit 1000 Response: The table ‘LoketNlRest.PayrollRunDownloads.TotalSepaFileByPayrollRunId’ must produce data in at least one of…

Thank you for the additional information. We recommend to give delegation for one week to our support team to analyze the issue. Is there also a SQL-statement that relates to PayrollRunDownloadsSepaFileBySepaFileId?

Sure, how can I delegate to Invantive Support Team? Lets put the PayrollRunDownloadsSepaFileBySepaFileId on hold for now. We have no SepaFileId to try with.

A test was done using: select * from PayrollAdministrationPayrollRuns prn join LoketNlRest.PayrollRunDownloads.TotalSepaFileByPayrollRunId(prn.prn_id, 'Salary', 'BtchBookgTrue', '2019-08-24') limit 5 But an error was returned due to missing scopes assigned to the Invantive client ID: itgenl…

Is there any update on this issue?

The current status is unknown. Please contact your contact person within the Organisation using Loket regarding their meeting with Loket.

I got the news this might be solved. I tried the same query as above and this time I got a new error: itgenjdn003: Can’t find the column ‘XML’ in the current list of 1 columns. Possible alternative column names: DOCUMENT, DOCUMENT.

Retrieve SEPA files Loket

Vragen (en)

forums 16 februari 2022 om 12:58 6

To delegate to a person please use the email address of that Invantive Support Team-member as described in Access via delegation on Invantive Cloud for consultants. You can delegate to me as first line.

Topic		Antwoorden	Weergaven
Request to access more Loket endpoints: SepaFilesByPayrollRunId Vragen (en) invantive-cloud , loket-nl	6	424	25 maart 2022
Errors when fetching CSV from Loket table PayrollRunBalanceSheetByPayrollRunIdAsCsv Vragen (en) invantive-cloud , loket-nl , invantive-psql	7	901	15 februari 2022
Loket: tabelnaam voor GetRunOverviewsByPayrollRunId endpoint Vragen (nl) loket-nl	2	1016	27 januari 2021
HTTP 403 error on PayrollRunByPayrollRunId on Loket: Client does not have access to activity Vragen (en) invantive-sql , loket-nl	7	861	25 maart 2022
Opvragen JSON van Loket loonstroken via PayrollPeriodResults By EmploymentId And Year Vragen (nl) loket-nl	7	951	25 juli 2021

Retrieve SEPA files Loket

Gerelateerde topics