Odoo icon

Odoo

Consume Odoo API

Actions21

Opportunity → Get

AI-generated

Overview

The Odoo Opportunity - Get operation node retrieves detailed information about a specific opportunity record from an Odoo instance using its unique Opportunity 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:

  • Fetching opportunity details to enrich sales dashboards.
  • Retrieving opportunity data for automated email follow-ups.
  • Integrating Odoo opportunities with other business tools (e.g., marketing automation).

Properties

Name Meaning
Opportunity ID The unique identifier of the opportunity you want to retrieve. This is required.
Options Additional options for the request. Contains:
• Fields to Include: Select which fields of the opportunity to include in the response. You can choose from a list or specify field IDs using an expression.

Output

  • The output is a JSON object containing the fields of the requested opportunity.
  • The structure of the output depends on the selected "Fields to Include" option:
    • If no fields are specified, default fields are returned.
    • If specific fields are chosen, only those fields will be present in the output.
  • Example output (fields will vary):
{
  "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 API credentials (URL, username, password, database name).
  • n8n Credentials: Must configure "odooApi" credentials in n8n.

Troubleshooting

Common issues:

  • Invalid Opportunity ID: If the provided ID does not exist, the node may return an empty result or an error.
  • Missing Fields: Specifying non-existent fields in "Fields to Include" may cause errors or missing data in the output.
  • Authentication Errors: Incorrect Odoo credentials will prevent the node from connecting; check your n8n credential settings.
  • Connection Issues: Network problems or incorrect Odoo URL can lead to connection failures.

Error messages:

  • "Credentials are not valid": Check your Odoo API credentials.
  • "Settings are not valid: ...": Review your Odoo configuration and ensure all required fields are set.
  • "error": "<message>" in output: Indicates a runtime error for that item; review the message for details.

Links and References

Discussion