I’m trying to fetch a CSV from the Loket table PayrollRunBalanceSheetByPayrollRunIdAsCsv, see below stored procedure code. I get an error: itgensgr045: No supported MIME-type produced ‘text/csv’ on table ‘LoketNlRest.PayrollRunDownloads.PayrollRunBalanceSheetByPayrollRunIdAsCsv’. Do you know a…

Thanks for the background. The CSV currently can not be generated without using NativeScalarRequests. The specific Loket API is essentially a wrapper around another specification. This specification is forwarded to the Loket server using the X-ReportInput header. Calculating and setting the speci…

@gls This is still an issue. And quite urgent, do you have any input for us on this?

This is a rather new table which has not yet been covered. It will be covered in a future release.

A request has been filed with Loket helpdesk on #213421 to have more scopes granted to the Invantive application registrations.

For the time being, use of NativeScalarRequests may prove helpful. Samples are: Create an Exact Online Sales Order with Details through REST Calls Triggering the new error rate limit active of 10 per app, endpoint, Exact Online division, user and hour

The API has been granted access and tested, but it seems part of the metadata is missing. A number of tickets have been created with Loket. It is a good moment to ask what the business need is to download the data as CSV and in using another API or format. Can you provide some background?

Business need : There are no reliable tables within Invantive to get to the right level of detail and reliability to make the bookings in our ERP. We’ve checked all tables and the one with debit/credit (JournalRunResults > JournalRunResultsByJournalRunId) doesn’t have the right level of detail (Payr…

Fouten bij het ophalen van CSV van Loket-tabel PayrollRunBalanceSheetByPayrollRunIdAsCsv

Vragen (en)

forums 8 februari 2022 om 10:33 5

For the time being, use of NativeScalarRequests may prove helpful. Samples are:

Create an Exact Online Sales Order with Details through REST Calls
Triggering the new error rate limit active of 10 per app, endpoint, Exact Online division, user and hour

Topic		Antwoorden	Weergaven
Retrieve SEPA files Loket Vragen (en) invantive-sql , loket-nl	14	839	25 maart 2022
Itgensql056 Syntax error op result_set_name(*"ProjectTimeTransactions"*) Vragen (alle) exact-online , invantive-sql	6	11	17 september 2026
Itgengpr045 Facturen worden niet geimporteerd in exact foutmelding Vragen (alle) exact-online , invantive-query-tool	3	26	17 maart 2026
Error itgensql151 Vragen (alle) get-my-report	2	7	10 augustus 2026
Error itgenuty039 starting Invantive Data Hub Vragen (en) exact-online , invantive-data-hub	6	22	6 maart 2026

Fouten bij het ophalen van CSV van Loket-tabel PayrollRunBalanceSheetByPayrollRunIdAsCsv

Gerelateerde topics