Tameson Odoo icon

Tameson Odoo

Consume Odoo API

Actions20

Overview

The Tameson Odoo node for n8n allows you to interact with the Odoo API, specifically targeting the "Contact" resource. The Get Many operation (getAll) retrieves multiple contact records from your Odoo instance. This is useful for scenarios where you need to fetch and process lists of contacts, such as syncing contacts to another system, generating reports, or performing bulk updates.

Practical examples:

  • Retrieve all contacts to synchronize them with a CRM or marketing platform.
  • Fetch a limited number of contacts for batch processing.
  • Selectively retrieve only specific fields (e.g., name, email) for lightweight data transfer.

Properties

Name Type Meaning
Return All Boolean Whether to return all results or only up to a given limit. If enabled, all matching contacts are returned; otherwise, the result is limited.
Limit Number Max number of results to return. Only shown if "Return All" is false. Controls how many contacts are fetched in one execution.
Options Collection Additional options for the request.
└─ Fields to Include MultiOptions Specify which fields of the contact to include in the response. You can select from available fields or specify field IDs via expressions.

Output

  • The output is an array of JSON objects, each representing a contact record retrieved from Odoo.
  • Each object contains the fields specified in "Fields to Include" (or all default fields if none are specified).
  • Example output structure:
[
  {
    "id": 123,
    "name": "John Doe",
    "email": "john@example.com"
    // ...other fields as requested
  },
  {
    "id": 124,
    "name": "Jane Smith",
    "email": "jane@example.com"
    // ...other fields as requested
  }
]
  • No binary data is produced by this operation.

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, the node will throw an authentication error. Double-check the URL, username, password, and database name.
  • Field Selection Errors: Specifying invalid or non-existent fields in "Fields to Include" may result in errors or missing data.
  • Large Data Volumes: Retrieving all contacts without a limit may lead to performance issues if your Odoo instance has a large number of contacts.

Error messages:

  • "Credentials are not valid": Indicates authentication failure. Verify your Odoo credentials.
  • "Settings are not valid: ...": There may be a configuration issue with your Odoo connection settings.
  • Other errors may be passed through from the Odoo API and will appear in the node's error output.

Links and References

Discussion