Import from Exact Online

The Import From Exact Online node retrieves data from Exact Online into a dataflow. It supports both single (regular) and bulk retrieval modes.

Retrieval modes

Regular (Single) Mode uses the standard Exact Online API. It retrieves data per request (paginated), is suitable for smaller datasets or incremental loads, and supports filtering. Only GET operations are used within this node.

Bulk Mode uses the bulk API of Exact Online for high-volume data retrieval. It retrieves up to 1000 records per API call and is ideal for initial loads or large datasets. Bulk mode requires selecting one or more fields via the Select fields configuration, and not all endpoints may support bulk retrieval.

Custom fields

When Include custom fields is enabled, custom fields are retrieved per record. The selected endpoint must support custom fields, and the Exact Online environment must support this feature.

Configuration

Setting	Required	Description
Division	No	The division from which data is retrieved. If not provided, the default division is used.
Retrieval Mode	Yes	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 (a maximum of 60 API calls per minute). Throttling is handled internally, so no additional configuration is required.

Tips

• 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.