Odoo API

Description

The Odoo API module allows connecting to Odoo or Open Bravo endpoints to read data via GET requests with basic authentication. It supports automatic pagination following the links.next links in the response, retries on ECONNRESET errors with exponential backoff, and dynamic variables in the URL. It is ideal for extracting product catalogs, price lists, inventories and any data accessible via REST API from Odoo or Open Bravo. The module normalizes multiple response formats (arrays, objects with data, nested payloads) to always provide a unified array.

Configuration

Parameter	Type	Required	Description
credentials_id	credentials	Yes	Odoo / Open Bravo access credentials
url	text	Yes	Endpoint URL (supports {{variable}} variables)
pageSize	number	No	Number of records per page (default: 100)
delayMs	number	No	Wait time between requests in milliseconds (default: 500)

Credentials

The credential must contain the fields:

• username: Username for basic authentication
• password: Password for basic authentication

The module generates an Authorization: Basic <base64> header with these credentials for each request.

Output

{
  "nextModule": "siguiente_modulo",
  "data": {
    "data": [
      { "id": 1, "name": "Producto A" },
      { "id": 2, "name": "Producto B" }
    ],
    "links": { "next": null }
  }
}

Usage Example

Basic case

{
  "credentials_id": "cred_odoo_01",
  "url": "https://mi-odoo.com/api/products",
  "pageSize": 100,
  "continu_next_link": true,
  "totalIterations": 0,
  "delayMs": 500
}

API Used

Any REST endpoint compatible with Odoo / Open Bravo. The URL is built with _page and _pageSize pagination parameters.

Notes

• Supports dynamic {{variable}} variables in the URL
• Automatic pagination is activated with continu_next_link: true and follows the links.next from each response
• totalIterations: 0 means no iteration limit
• Includes automatic retries (up to 3) with exponential backoff for ECONNRESET errors
• The continueOnError: true parameter allows the workflow to continue even if an error occurs
• The module normalizes multiple API response formats to always return a unified array in data.data

Related Nodes

• OdooWrite - Write to Odoo / Open Bravo