Exact PHP Client

Exact Online enforces minutely and daily rate limits. If you exceed these, the library throws an ApiException with code 429.

Monitoring Limits

You can inspect current limits using the following Connection methods:

• $connection->getDailyLimit(): Total daily calls allowed.
• $connection->getDailyLimitRemaining(): Remaining calls for today.
• $connection->getDailyLimitReset(): Timestamp when the daily limit resets.
• $connection->getMinutelyLimit(): Calls allowed per minute.
• $connection->getMinutelyLimitRemaining(): Remaining calls for this minute.
• $connection->getMinutelyLimitReset(): Timestamp when the minutely limit resets.

Automatic Waiting

You can instruct the client to automatically pause execution until the minutely limit resets by calling: $connection->setWaitOnMinutelyRateLimitHit(true);

To install the library, use Composer to add picqer/exact-php-client to your project dependencies.

composer require picqer/exact-php-client

To prevent memory exhaustion when retrieving large sets of data, use the generator methods. These allow you to iterate over results one by one instead of loading the entire collection into memory.

Use getAsGenerator() for a full list or filterAsGenerator($filter) to iterate over a filtered subset.

$item = new \Picqer\Financials\Exact\Item($connection);
$item->getAsGenerator();
$item->filterAsGenerator('IsWebshopItem eq 1');

Before you can make API calls, you must authorize your application. This involves redirecting the user to Exact Online to log in and grant permissions. You will need your Client ID, Client Secret, and the Callback URL configured in the Exact App Center.

Use the redirectForAuthorization() method on a Connection instance to initiate the oAuth dance.

$connection = new \Picqer\Financials\Exact\Connection();
$connection->setRedirectUrl('CALLBACK_URL'); // Same as entered online in the App Center
$connection->setExactClientId('CLIENT_ID');
$connection->setExactClientSecret('CLIENT_SECRET');
$connection->redirectForAuthorization();

If your application does not yet have an access token or refresh token, you must redirect the user to Exact Online to authorize your app.

1. Use getAuthUrl() to generate the URL for the authorization request.
2. Use redirectForAuthorization() to immediately trigger a PHP header redirect to that URL.
3. Optionally use setState(string $state) to pass a CSRF token to the authorization URL, which will be returned in the callback.
4. Use setForceLogin(bool $forceLogin) to force the user to enter their credentials even if they are already logged into Exact Online.

// Generate the URL to redirect the user to
$authUrl = $connection->getAuthUrl();

// Or redirect immediately
$connection->redirectForAuthorization();

If you encounter an ApiException stating that a $select or $top=1 statement is required, it is because the Exact API requires explicit field selection or result limiting to prevent over-fetching.

To resolve this, pass the selection or top parameter to the filter() method.

Example: Selecting specific fields

$test = new \Picqer\Financials\Exact\GeneralJournalEntry($connection);
var_dump($test->filter('', '', 'EntryID, FinancialYear'));

Example: Limiting to one result ($top=1)

$test = new \Picqer\Financials\Exact\GeneralJournalEntry($connection);
var_dump($test->filter('', '', '', ['$top'=> 1]));

Webhook subscriptions are managed via the WebhookSubscription entity.

To authenticate incoming webhook calls, use the Authenticatable trait. Pass the full JSON request body and your Exact-supplied Webhook secret to the authenticate method; it returns a boolean indicating if the request is valid.

By default, the client connects to the Netherlands (NL) instance. To connect to other Exact regions (e.g., Germany), use setBaseUrl() with the appropriate URL from the Exact developers guide.

$connection = new \Picqer\Financials\Exact\Connection();
$connection->setRedirectUrl('CALLBACK_URL');
$connection->setExactClientId('CLIENT_ID');
$connection->setExactClientSecret('CLIENT_SECRET');
$connection->setBaseUrl('https://start.exactonline.de');