Check row count in Exact Online incremental tables and auto-correct when necessary to solve authorisation problems

Ideas (en)
,
1

See Ontbrekende rijen in Exact Online Online TransactionsIncremental via Application.

On refresh and no more often than every x hours compare row count in incremental table with row count from $count. When very different, reload full cache.

2

Interesting, can we count() from exact API ? I can’t find it in their API documentation.

3

Yes, the use of count() on OData 3 (which is Exact Online’s OData version) is described in Estimate size of an Exact Online company.