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 to tailor the data retrieved.
Practical examples:
- Fetching all customers from a particular division and service with specific filtering criteria.
- Creating a new sales invoice with required field data.
- Updating contact information for a given customer ID.
- Deleting an obsolete record by its unique identifier.
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 Exact Online service to connect to, dependent on the chosen division. Selectable 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 containing the requested Exact Online records.
- For post (create) operations, it returns the newly created record's data as confirmation.
- 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.
- Depends on Exact Online API endpoints, which require valid division, service, resource, and operation parameters.
- Uses 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): If mandatory fields are not provided when creating a record, the node throws an error listing missing fields. Ensure all required fields are included.
- ID required for update (put) and delete: Operations that modify or delete records require a valid record ID. Omitting this causes an error.
- Invalid filter syntax: Filters must use supported operators and field names; otherwise, the API may reject the request.
- Authentication errors: Incorrect or expired credentials will cause authentication failures. Verify API keys or OAuth2 tokens.
- API rate limits or connectivity issues: Network problems or API limits can cause errors; retry or check API status.
- Empty manual JSON body: When using manual JSON input for post/put, ensure the JSON is valid and not empty.
- Operation not supported: Selecting an unsupported operation for a resource/service combination may cause errors.
Links and References
If you need details about other resources or operations, feel free to ask!