Please make sure that the Exact Online user of the database data container has actually the necessary privileges. When privileges are missing, a table is returned as empty.
To acquire more information on the rather complex privilege structure of Exact Online please refer to:
- Exact Online API rechten van een user op specifieke endpoint (Dutch)
- How do I revoke app permissions for Exact Online?
- Op administratieniveau rechten verlenen aan Exact Online Apps met DivisionLevelScoping (Dutch)
- Bestaande PowerBI dashboards halen geen data meer op uit Exact Online (Dutch)
- What is "division scoping"?
- Wat is "data scoping" op Exact Online? (Dutch)
Also, please consider the use of the REST-version such as
The rule of thumb to select the probably best choice of table when there are multiple candidate tables is (see also the opening page of the Exact Online documentation of Invantive):
- Table name ends with
Incremental - Table name ends with
Bulk - Table name starts with
ExactOnlineREST - Table name starts with
ExactOnlineXML
With three notable exceptions which we strongly recommend XML for:
-
BalanceLinesPerPeriod: periodic balances, -
BalanceLinesPerPeriodCostAnalysis: periodic balances (analytical), -
APOutstandingItems: outstanding purchase invoices, -
AROutstandingItems: outstanding receivable invoices.