Tameson Odoo icon

Tameson Odoo

Consume Odoo API
Join our community

Actions20

Overview

The Tameson Odoo node for n8n allows you to interact with the Odoo API, specifically targeting the "Opportunity" resource. The Get Many (getAll) operation retrieves multiple opportunity records from your Odoo instance. This is useful for scenarios such as:

  • Listing all sales opportunities for reporting or dashboarding.
  • Fetching a filtered set of opportunities for further automation or integration.
  • Exporting opportunity data to other systems.

Practical examples:

  • Retrieve all open opportunities and send summary emails.
  • Sync Odoo opportunities with a CRM or spreadsheet.
  • Analyze opportunity fields for business intelligence.

Properties

Name Type Meaning
Return All boolean Whether to return all results (true) or limit the number of returned records (false).
Limit number Maximum number of results to return. Only shown if "Return All" is false.
Options collection Additional options for the request.
└─ Fields to Include multiOptions List of specific fields to include in the response. You can select from available fields or specify field IDs using an expression.

Output

  • The output is a JSON array where each element represents an Opportunity record from Odoo.
  • The structure of each object depends on the fields selected in "Fields to Include". If no fields are specified, default fields are returned by Odoo.
  • Example output (fields will vary):
[
  {
    "id": 123,
    "name": "Big Deal",
    "stage_id": 4,
    "expected_revenue": 10000,
    ...
  },
  ...
]
  • No binary data is produced by this operation.

Dependencies

  • Odoo API: Requires access to an Odoo instance.
  • Credentials: You must configure Odoo API credentials in n8n (URL, username, password, database name).
  • n8n Configuration: The node requires the odooApi credential type to be set up and tested.

Troubleshooting

Common Issues:

  • Invalid Credentials: If the Odoo API credentials are incorrect, authentication will fail. Error message:
    "Credentials are not valid"
    Resolution: Double-check your Odoo URL, username, password, and database name.

  • Insufficient Permissions: The user may lack permission to read opportunities.
    Resolution: Ensure the Odoo user has appropriate access rights.

  • Field Selection Errors: Specifying invalid or misspelled field names in "Fields to Include" may result in errors or missing data.
    Resolution: Use the field selector or verify field names via Odoo documentation.

  • Large Data Volumes: Retrieving all opportunities without filters may lead to performance issues.
    Resolution: Use the "Limit" property or apply server-side filtering if supported.

Links and References

Discussion