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

質問 (en)

forums 2022 年 2 月 8 日午前 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

トピック		返信	表示
Retrieve SEPA files Loket Vragen (en) invantive-sql , loket-nl	14	839	2022 年 3 月 25 日
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	2022 年 5 月 29 日
HTTP 403 error on PayrollRunByPayrollRunId on Loket: Client does not have access to activity Vragen (en) invantive-sql , loket-nl	7	863	2022 年 3 月 25 日
Itgengpr015: Onbekende tabel 'TEST' Vragen (alle) invantive-cloud , invantive-sql , exceltable	3	151	2024 年 6 月 12 日
Itgenduy006 melding bij inlezen WICS shipment status in Exact Online Vragen (alle) exact-online	1	290	2022 年 6 月 2 日

Errors when fetching CSV from Loket table PayrollRunBalanceSheetByPayrollRunIdAsCsv

関連トピック