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 various resources such as Opportunities.
For the Opportunity → Update operation, this node updates an existing opportunity in your Odoo system using its unique ID and a set of fields you wish to modify.

Common scenarios:

  • Automating sales pipeline management by updating opportunity details from other systems.
  • Keeping Odoo opportunities synchronized with external CRMs or lead sources.
  • Bulk-updating opportunity records based on workflow logic.

Example use case:
When a lead's probability or expected revenue changes in another system, you can trigger this node to update the corresponding opportunity in Odoo automatically.

Properties

Name Type Meaning
Opportunity ID String The unique identifier of the opportunity to update.
Update Fields Collection A group of fields to update on the opportunity. Each field below is optional:
— Email String The email address associated with the opportunity.
— Expected Revenue Number The anticipated revenue value for the opportunity.
— Internal Notes String Additional notes or description for internal reference.
— Name String The name/title of the opportunity.
— Phone String The phone number linked to the opportunity.
— Priority Options The priority level of the opportunity (1, 2, or 3).
— Probability Number The likelihood of closing the opportunity, as a percentage (0–100).

Output

  • The output is a JSON object representing the updated opportunity record as returned by the Odoo API.
  • 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 field with the error message.

Example output:

[
  {
    "id": 123,
    "name": "Updated Opportunity",
    "email_from": "contact@example.com",
    "expected_revenue": 5000,
    "description": "Updated via automation",
    "phone": "+123456789",
    "priority": "2",
    "probability": 80
    // ...other Odoo fields
  }
]

Dependencies

  • Odoo instance: You must have access to an Odoo server with the appropriate modules enabled.
  • API Credentials: Requires valid Odoo API credentials (url, username, password, and optionally db).
  • n8n Configuration: The node uses the odooApi credential type, which must be configured in n8n.

Troubleshooting

Common issues:

  • Invalid Opportunity ID: If the provided ID does not exist, the node may return an error or no data.
  • Missing Required Fields: If required fields are omitted or incorrectly formatted, Odoo may reject the update.
  • Authentication Errors: Incorrect credentials will result in authentication failures.

Error messages and resolutions:

  • "Credentials are not valid": Check your Odoo URL, username, password, and database name.
  • "Settings are not valid: ...": There may be a misconfiguration in your credentials or network issues.
  • "error": "<message>" in output: Indicates a problem with the specific item; review the error message for details.

Links and References

Discussion