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 records or lists of records from Exact Online.
- Creating new records in Exact Online.
- Updating existing records by ID.
- Deleting records by ID.
- Filtering and selecting specific fields for retrieval.
Practical examples:
- Fetching all customers from a specific division and service.
- Creating a new sales order 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 requests. 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. Depends 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 the retrieved records.
- For post (create) operations, it returns the 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 array.
No binary data output is produced by this node.
Dependencies
- Requires connection to the Exact Online API.
- Needs either an access token or OAuth2 credentials configured in n8n.
- Uses dynamic loading of options for divisions, services, resources, operations, and fields via helper functions.
- No additional external dependencies beyond the Exact Online API and n8n credential setup.
Troubleshooting
- Missing or invalid ID for get/put/delete operations: The node throws an error if an ID is required but not provided. Ensure the ID parameter is set correctly.
- Mandatory fields missing for post operation: If mandatory fields are not supplied when creating a record, the node will throw an error listing the missing fields. Provide all required fields.
- Empty manual JSON body when enabled: When using manual JSON input for post or put, ensure the JSON body is not empty; otherwise, an error is thrown.
- API request failures: Errors from the Exact Online API are propagated. Check credentials, permissions, and API limits.
- Filter syntax issues: Filters must use supported operators and correct field names. Incorrect filters may cause no results or errors.
- "Something went wrong." error: Generic error for unexpected API responses during update or delete. Verify the correctness of IDs and data.
To resolve errors, verify input parameters, authentication credentials, and consult Exact Online API documentation for valid field names and operations.