In the new release of Invantive Cloud, and release 22.0.142 and newer of on-premises products, the following tables have been added based on the Exact Online Sync APIs:
PjtTimeTransactionsIncremental: fast list of hours on projects in Exact Online as a replacement for
CostTransactionsIncremental: fast and conclusive list of costs on projects in Exact Online as replacement of
It is advised to switch for retrieval of hours and costs on projects to these new fast tables to gain considerable speed improvements and reduce the odds of hitting Exact Online API limits.
These are additions to the already existing incremental tables that are dozens of times faster than retrieving the data via the original Exact Online tables. The workings are described in Faster Exact Online download using incremental "sync API"-tables.
In addition, the number of Exact Online API calls used drops dramatically. The number of API calls needed after switching is comparable to using Trickle Loading on Data Replicator and often even slightly less. More tips to reduce the number of API calls are in Optimalisatie API calls zoals met Exact Online (Dutch).
Invantive Cloud users such as with Power BI can often replace the table
PjtTimeTransactionsIncremental. Note that derived fields are missing (see below).
Users of on-premises software of Invantive software first need to install an upgrade. After that queries, etc. can be modified. The most popular upgrades are:
- Invantive(R) Control for Excel 23.0.36 | Release Notes
- Invantive Query Tool 23.0.36 | Release Notes
- Invantive(R) Data Hub 23.0.36 | Release Notes
Derived fields such as
Project Code are not present in the new tables; besides the design limitations (Dutch) this also has the advantage that building a data model like in for example Power BI will faster lead to results.
The full names of the tables including catalog and schema are: