Overview
This node integrates with the Exact Online API, allowing users to perform various operations on Exact Online data. It supports multiple authentication methods and enables interaction with different divisions, services, resources, and operations within Exact Online.
Common scenarios where this node is beneficial include:
- Retrieving specific records or lists of records from Exact Online.
- Creating new records in Exact Online.
- Updating existing records by their ID.
- Deleting records by their ID.
- Applying filters and selecting specific fields when querying data.
Practical examples:
- Fetching all customers from a particular division with certain filter criteria.
- Creating a new sales invoice with specified field values.
- Updating contact information for a given record ID.
- Deleting an obsolete record by its ID.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method used to authenticate with Exact Online API. Options: "Access Token" or "OAuth2". |
| Division Name or ID | The division within Exact Online to get data from. Can be selected from a list or specified via expression. |
| Service Name or ID | The service to connect to within the chosen division. Options depend on the selected division; can be selected from a list or specified via expression. |
Output
The node outputs JSON data representing the results of the performed operation:
- For get and getAll operations, it returns arrays of objects corresponding to Exact Online records matching the query.
- For post (create) operations, it returns the newly created record's data.
- For put (update) operations, it returns a success message if the update was successful.
- For delete operations, it returns a success message confirming deletion.
- In case of errors (if "Continue On Fail" is enabled), error details are included in the output.
No binary data output is produced by this node.
Dependencies
- Requires an API key credential or OAuth2 credentials configured in n8n for authenticating with Exact Online.
- Uses Exact Online REST API endpoints dynamically based on selected division, service, resource, and operation.
- Relies on internal helper functions to load options dynamically (e.g., divisions, services, resources, operations, fields).
- No additional external dependencies beyond the Exact Online API and n8n credential setup.
Troubleshooting
Missing mandatory fields on create (post) operation:
Error message indicates which required fields were not provided. Ensure all mandatory fields are included in the input data.ID missing for update (put) or delete operations:
The node requires a valid record ID to update or delete. Provide a non-empty ID value.Invalid or expired authentication:
If authentication fails, verify that the API key or OAuth2 token is correctly configured and has not expired.Filter syntax errors:
When using filters in getAll operations, ensure operators and values match the expected types (string values quoted, booleans lowercase, numbers unquoted).Unexpected API errors ("Something went wrong"):
This generic error may indicate issues such as insufficient permissions, invalid endpoint, or malformed requests. Check Exact Online API documentation and credentials.Handling multiple items:
Errors occurring on individual items will either stop execution or be included in output depending on the "Continue On Fail" setting.