Odoo icon

Odoo

Consume Odoo API

Actions21

Note → Get Many

AI-generated

Overview

The Odoo node for n8n allows you to interact with the Odoo API. Specifically, when using the Note resource and the Get Many (getAll) operation, this node retrieves multiple note records from your Odoo instance. This is useful for automating processes that require fetching notes in bulk, such as reporting, synchronization with other systems, or monitoring changes in notes.

Practical examples:

  • Retrieve all notes for analysis or backup.
  • Fetch a limited number of recent notes for review.
  • Integrate Odoo notes into another workflow or system.

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 output is an array of JSON objects, each representing a note record retrieved from Odoo.
  • The structure of each object depends on the fields selected in "Fields to Include". By default, standard note fields are included.
  • Example output (fields will vary based on selection):
[
  {
    "id": 123,
    "memo": "This is a note",
    "create_date": "2024-06-01T12:00:00Z"
    // ...other fields as specified in "Fields to Include"
  },
  {
    "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 valid credentials (URL, username, password, and database name).
  • n8n Credentials: You must configure Odoo API credentials in n8n under the name odooApi.

Troubleshooting

Common issues:

  • Invalid credentials: If the Odoo API credentials are incorrect, authentication will fail. Error message: Credentials are not valid or Settings are not valid.
    • Resolution: Double-check the URL, username, password, and database name in your n8n credentials.
  • Field selection errors: Specifying invalid or non-existent fields in "Fields to Include" may result in empty or incomplete output.
    • Resolution: Use the provided field selector or verify field names in your Odoo model.
  • API connection issues: Network problems or incorrect Odoo URL can cause connection failures.
    • Resolution: Ensure your Odoo instance is reachable from the n8n server.

Links and References

Discussion