Actions20
Overview
The Tameson Odoo node for n8n allows you to interact with the Odoo API, specifically targeting the "Note" resource in this context. The Get Many (getAll) operation retrieves multiple notes from your Odoo instance, either all available notes or a limited number based on user input. This is useful for automating workflows that require bulk retrieval of notes, such as reporting, synchronization, or data analysis.
Practical examples:
- Fetching all notes for backup or migration.
- Retrieving a subset of notes for review or processing in another system.
- Filtering and exporting specific fields from notes for analytics.
Properties
| Name | Type | Meaning |
|---|---|---|
| Return All | boolean | Whether to return all results (true) or only up to a specified limit (false). |
| Limit | number | Maximum number of results to return. Only shown if "Return All" is false. Minimum value is 1. |
| Options | collection | Additional options for the request. |
| Fields to Include | multiOptions | List of note fields to include in the output. You can select from available fields or specify field IDs using an expression. |
Output
- The output is a JSON array where each element represents a note retrieved from Odoo.
- Each note object contains fields as returned by the Odoo API, which may vary depending on the "Fields to Include" option.
- If no fields are specified, default fields are returned.
- Example output structure:
[
{
"id": 123,
"memo": "This is a note",
"create_date": "2024-06-01T12:00:00Z"
// ...other fields depending on selection
},
...
]
Dependencies
- Odoo API: Requires access to an Odoo instance with valid credentials (URL, username, password, database name).
- n8n Credentials: You must configure Odoo API credentials in n8n under the name
odooApi.
Troubleshooting
Common issues:
- Invalid credentials: If authentication fails, ensure your Odoo URL, username, password, and database name are correct.
- Insufficient permissions: The Odoo user must have permission to read notes.
- Field selection errors: Specifying invalid or non-existent fields in "Fields to Include" may result in empty or error responses.
Error messages:
"Credentials are not valid": Check your Odoo credentials."Settings are not valid: ...": There may be a misconfiguration in your Odoo connection settings."Cannot read property 'fieldsList' of undefined": Ensure the "Options" property is set correctly.