Ctrlk
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Import from Exact Online

Category: ERP

Version: 1.0

Last updated: April 2, 2026

Author: Any2Info

Description

The Import Exact Online node allows you to retrieve data from Exact Online into your data flow. It supports both single (regular) and bulk retrieval modes.

Retrieval Modes:

Regular (Single) Mode

Uses the standard Exact Online API to retrieve data.

Characteristics:

  • Retrieves data per request (paginated)

  • Suitable for smaller datasets or incremental loads

  • Supports filtering

Note: Only GET operations are used within this node.

Bulk Mode

Uses the bulk API of Exact Online for high-volume data retrieval.

Characteristics:

  • Retrieves up to 1000 records per API call

  • Ideal for initial loads or large datasets

  • Requires selecting one or more fields using $select

Important:

  • Bulk mode requires the Select fields configuration

  • Not all endpoints may support bulk retrieval

** Custom Fields: **

When the Include custom fields option is enabled:

  • Custom fields are retrieved per record

  • The selected endpoint must support custom fields

  • Your Exact Online environment must support this feature

Configuration Options

Setting
Required
Description

Division

No

Specifies the division from which data is retrieved. If not provided, the default division is used.

Retrieval Mode

Yes

Determines how data is retrieved: Single or Bulk.

Custom Fields

No

When enabled, retrieves custom fields per record (if supported by the entity and Exact Online environment).

Rate Limiting

The node automatically respects the rate limits imposed by Exact Online.

  • Maximum: 60 API calls per minute

  • Throttling is handled internally, so no additional configuration is required

Tips & Best Practices

  • Use Bulk mode for initial full synchronizations or large datasets

  • Use SIngle mode for incremental updates or smaller queries

  • Always limit your dataset using filters where possible to improve performance

  • Only select the fields you need, especially in Bulk mode, to reduce load and improve speed

  • Not all endpoints support both retrieval modes

  • Custom fields availability depends on both the entity and Exact configuration

  • Division selection is optional but recommended when working with multiple divisions

Changelog

Version
Date
Change

1.0

April 2, 2026

Initial documentation version added.

PreviousImport from Exact GlobeNextImport from Exact Synergy

Last updated

Was this helpful?