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)

Topic		Antwoorden	Weergaven
Itgenclr217 goes unnoticed on Exact Online employees Vragen (en) exact-online , invantive-sql	3	22	1 oktober 2026
Itgensql056 Syntax error op result_set_name(*"ProjectTimeTransactions"*) Vragen (alle) exact-online , invantive-sql	7	26	1 oktober 2026
Retrieve SEPA files Loket Vragen (en) invantive-sql , loket-nl	14	844	25 maart 2022
Visma.net table SalesOrders not accessible Vragen (en) invantive-cloud , visma-net	19	65	16 oktober 2026
Itgengpr045 Facturen worden niet geimporteerd in exact foutmelding Vragen (alle) exact-online , invantive-query-tool	3	27	17 maart 2026

Fouten bij het ophalen van CSV van Loket-tabel PayrollRunBalanceSheetByPayrollRunIdAsCsv

Gerelateerde topics