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 "Opportunity" resource in this context. The Get operation retrieves detailed information about a specific opportunity from your Odoo instance using its unique ID. This is useful for workflows that need to fetch and process opportunity data, such as syncing CRM records, generating reports, or triggering follow-up actions based on opportunity status.

Example scenarios:

  • Retrieve an opportunity's details to enrich data before sending it to another system.
  • Fetch opportunity information for reporting or analytics.
  • Use opportunity data to trigger conditional logic in your workflow (e.g., send an email if the opportunity is at a certain stage).

Properties

Name Type Meaning
Opportunity ID String The unique identifier of the opportunity to retrieve.
Options Collection Additional options for the request.
Fields to Include MultiOptions (Within Options) Specify which fields of the opportunity to include in the response.

Output

  • The output is a JSON object containing the details of the requested opportunity.
  • The structure of the output depends on the fields selected in "Fields to Include". If no fields are specified, default fields are returned by Odoo.
  • Example output:
{
  "id": 123,
  "name": "Big Deal",
  "stage_id": [4, "Qualified"],
  "expected_revenue": 10000,
  ...
}
  • If an error occurs and "Continue On Fail" is enabled, the output will contain an error field with the error message.

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 the Odoo credentials are incorrect, authentication will fail. Ensure the URL, username, password, and database name are correct.
  • Missing Opportunity: If the provided Opportunity ID does not exist, the node may return an error or empty result.
  • Insufficient Permissions: The Odoo user must have permission to read opportunities.
  • Field Selection Errors: Specifying invalid or non-existent fields in "Fields to Include" may cause errors or missing data in the output.

Error messages:

  • "Credentials are not valid": Check your Odoo credentials.
  • "Settings are not valid: ...": There may be a configuration issue; verify all connection parameters.
  • "Cannot read property '...' of undefined": Likely due to a missing or incorrect Opportunity ID.

Links and References

Discussion