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…

Errors when fetching CSV from Loket table 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
Itgenpse009: Differences when running a query in the SQL Editor compared to a stored procedure Vragen (en) invantive-cloud , invantive-sql , loket-nl , invantive-psql	7	712	29 mei 2022
HTTP 403 error on PayrollRunByPayrollRunId on Loket: Client does not have access to activity Vragen (en) invantive-sql , loket-nl	7	863	25 maart 2022
Itgengpr015: Onbekende tabel 'TEST' Vragen (alle) invantive-cloud , invantive-sql , exceltable	3	151	12 juni 2024
Itgenduy006 melding bij inlezen WICS shipment status in Exact Online Vragen (alle) exact-online	1	290	2 juni 2022

Errors when fetching CSV from Loket table PayrollRunBalanceSheetByPayrollRunIdAsCsv

Gerelateerde topics