Tameson Odoo icon

Tameson Odoo

Consume Odoo API
Join our community

Actions21

Overview

The Tameson Odoo node for n8n allows you to interact with the Odoo API, specifically targeting the "Note" resource. 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 fetching and processing notes in bulk, such as reporting, synchronization, or data migration tasks.

Practical examples:

  • Retrieve all notes for archiving or backup.
  • Fetch a subset of notes for review or further processing in downstream workflow steps.
  • Selectively include specific fields from each note to optimize data handling.

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 Specify which fields of the note to include in the output. You can select from a list or use expressions to specify field IDs.

Output

  • The output is an array of JSON objects, each representing a note retrieved from Odoo.
  • The structure of each note object depends on the fields selected in "Fields to Include". If no fields are specified, default fields are returned by the Odoo API.
  • Example output (fields will vary):
[
  {
    "id": 123,
    "memo": "This is a note",
    "create_date": "2024-06-01T12:00:00Z"
  },
  {
    "id": 124,
    "memo": "Another note",
    "create_date": "2024-06-02T09:30:00Z"
  }
]
  • No binary data is produced by this operation.

Dependencies

  • Odoo API: Requires access to an Odoo instance with appropriate permissions.
  • Credentials: You must configure Odoo API credentials in n8n (URL, username, password, and database name).
  • n8n Configuration: The node uses the odooApi credential type, which must be set up and tested in your n8n instance.

Troubleshooting

  • Invalid Credentials: If authentication fails, you may see errors like Credentials are not valid or Settings are not valid. Double-check your Odoo URL, username, password, and database name.
  • Field Selection Issues: If you specify invalid field names in "Fields to Include", the Odoo API may return errors or incomplete data. Use the provided field selector or verify field names via Odoo documentation.
  • API Limits: Large result sets may cause timeouts or performance issues. Use the "Limit" property to restrict the number of records fetched.
  • Connection Errors: Network issues or incorrect URLs can lead to connection failures. Ensure your n8n instance can reach the Odoo server.

Links and References

Discussion