Large and slow download for SalesInvoiceLinesIncremental

[yha54]

When we update are sales invoice lines from Exact Online through Invantive to our PowerBI-model, it takes a long time to transfer ±80MB each time.

I read in the Invantive support notes (Snel en met minder API-calls Exact Online uitlezen met de incrementele "sync API"-tabellen) that we should switch to the Exact Online’s incremental tables.

So, we’ve built a new PowerBI model based on the REST-table Incremental.SalesInvoiceLinesIncremental.

Because this table is normalized, we’ve joined it with SalesInvoices.SalesInvoices@eol (for which there is no incremental alternative) and a local ‘Items’-table.

For the moment this also works (and gives the exact powerBI results compared to the non-incremental model), but it still takes 80MB for each update!

[forums]

Recommendation is to replace SalesInvoices by SalesInvoicesIncremental (see SalesInvoicesIncremental: Exact Online Verkoopfacturen (incrementeel) - Exact Online API Data Model) or SalesInvoiceLinesIncremental where LineNumber equals 0 (see also Special line number such as 0 and 9999 on financial transactions in Exact Online).

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.