Odoo icon

Odoo

Consume Odoo API

Actions21

Overview

The Odoo n8n node allows you to interact with custom resources in your Odoo instance. Specifically, the Custom Resource → Update operation updates fields of a specified custom resource record by its ID. This is useful when you need to programmatically modify data in any custom model within Odoo, such as updating status fields, changing values, or correcting information.

Practical scenarios:

  • Updating a custom CRM record after a lead qualification.
  • Modifying inventory details in a custom warehouse model.
  • Automating changes to custom project management records based on workflow triggers.

Properties

Name Meaning
Custom Resource Name or ID Select the Odoo model (custom resource) to update. You can choose from a list or specify the model name using an expression.
Custom Resource ID The unique identifier of the record in the selected custom resource that you want to update. This field is required.
Update Fields List of fields and their new values to update in the record. Each entry includes:
• Field Name or ID: Select or specify the field to update.
• New Value: The value to set for this field.

Output

  • The output will be a JSON object representing the updated custom resource record as returned by Odoo after the update operation.
  • If multiple items are processed, the output will be an array of such objects.
  • In case of error and if "Continue On Fail" is enabled, the output will include an error property with the error message.

Example output:

{
  "id": 123,
  "field1": "new value",
  "field2": 42,
  ...
}

Dependencies

  • Odoo API: Requires access to an Odoo instance with the appropriate permissions to read and update the target model.
  • Credentials: You must configure the odooApi credential in n8n, including:
    • Odoo URL
    • Database name
    • Username
    • Password

Troubleshooting

Common issues:

  • Invalid credentials: If authentication fails, ensure your Odoo URL, database, username, and password are correct.
  • Model or field not found: If you specify a model or field that does not exist, Odoo will return an error. Double-check the model and field names/IDs.
  • Insufficient permissions: The Odoo user must have write access to the target model.
  • Error messages:
    • "Credentials are not valid": Check your Odoo credentials.
    • "Settings are not valid: ...": There may be a configuration issue; verify all connection parameters.
    • "Record not found" or similar: Ensure the provided Custom Resource ID exists.

Links and References

Discussion