Actions21
Overview
The Odoo Node for n8n, when configured with the Resource: Note and Operation: Get Many (getAll), retrieves multiple note records from an Odoo instance. This operation is useful for automating workflows that require fetching notes in bulk, such as synchronizing notes with other systems, generating reports, or monitoring changes in notes.
Practical examples:
- Fetching all notes related to a project for reporting.
- Syncing Odoo notes with another database or application.
- Filtering and exporting specific fields from notes for analysis.
Properties
| Name | Meaning |
|---|---|
| Return All | Whether to return all results or only up to a given limit. If enabled, all matching notes are returned; if disabled, the number of results is limited by the "Limit" property. |
| Limit | Max number of results to return. Only shown if "Return All" is set to false. Accepts values between 1 and 1000. |
| Options | Additional options for the request. Includes: • Fields to Include: Select which fields to include in the output. You can choose from a list or specify field IDs using an expression. |
Output
- The node outputs an array of JSON objects, each representing a note record from Odoo.
- The structure of each object depends on the fields selected in Options → Fields to Include. By default, standard note fields (such as
id,memo, etc.) are included. - If no fields are specified, a default set of fields is returned.
- Each output item corresponds to a single note.
Example output:
[
{
"id": 123,
"memo": "This is a note",
"create_date": "2024-06-01T12:00:00Z"
},
...
]
Dependencies
- Odoo API: Requires access to an Odoo instance with valid credentials (URL, username, password, and database name).
- n8n Credentials: Must configure the "odooApi" credential in n8n.
- No additional environment variables are required beyond standard n8n configuration.
Troubleshooting
Common issues:
- Invalid credentials: If the Odoo API credentials are incorrect, authentication will fail. Ensure the URL, username, password, and database name are correct.
- Insufficient permissions: The user account must have permission to read notes in Odoo.
- Field selection errors: Specifying invalid or non-existent fields in "Fields to Include" may result in empty or incomplete data.
Error messages:
"Credentials are not valid": Check your Odoo API credentials."Settings are not valid: ...": There may be a misconfiguration in the connection settings."error": "<message>"in output: If "Continue On Fail" is enabled, errors for individual items are returned in the output. Review the error message for details.