New Exact Online API limitations for 2021

Ideas (en)
,
2

Thanks for bringing them to my attention. The Dutch policy on the new Exact Online API limit is located at Impact Exact Online API adjustments July 1, 2021.

Practically: the API limit specifications are yet unclear and there is no clear timeline for improvement. We therefore just await a possible down period.

Where things were clear, the necessary changes were already in place and live at most sites. The biggest threat is the Exact Online limit regarding errors per hour since the error raising mechanism of Exact is very diffuse and the Invantive SQL driver for Exact Online can not reliably detect what is a real problem on Exact or what is something customer-induced.

But in general, the soup is served lukewarm instead of hot.

The /sync/ endpoints have been available for some time, but were not supported. Since the Exact Online API servers have been stressed a lot since the end of December 2020, Exact has started throttling many applications. So far, the sites on Invantive SQL had no major issues. Most switched to trickle loading for data replication which fixes it.

There is no need to worry about executing too many requests for API calls, the daily limit or the minutely limits. The /sync/ endpoints on the REST API have been reviewed. Not all endpoints are available; there are some specifications lacking. The latest BETA release includes TransactionLinesIncremental and ItemsIncremental which have passed the review and can be used for use in controlled-production environments: it probably works well, but make sure to check the results carefully at intervals.

The software also automatically adapts to a changed value in minutely limit for the API call rate.

A wiki post will become available in the next few days to present how to analyze the incremental loading from the Exact Online API using Data Dictionary views on Exact Online.

UPDATE: the post is available at: Faster Exact Online download using incremental "sync API"-tables

UPDATE 2: The sync APIs are available where stable, but please note that other breaking changes scheduled for life on July 1, 2021, may cause interruption of your Exact Online production. See: