Export Odoo Company Data via API Endpoint with JSON/Excel Output Options

Description

How it works
This workflow provides an API endpoint /api/v1/get-companies that retrieves company records directly from your Odoo database. It’s built for teams who need to query or export company data — either as structured JSON for integrations or as Excel (.xlsx) for reporting.

When a request is made, the workflow:
Accepts query parameters (name, response_format).
Validates the name input (required for company search).
Fetches all matching companies from Odoo using a like filter for partial name matches.
Returns results as a JSON response or Excel file depending on the response_format parameter.

This makes it ideal for quickly exporting or syncing company information with other tools.

Setup steps
Open the Webhook node and note the endpoint /api/v1/get-companies.
Connect your Odoo API credentials in the Odoo node.
Optionally update the fieldsList in the Odoo node to include more company details (VAT, address, etc.).
Test using a browser or Postman:
/api/v1/get-companies?name=Tech&response_format=json
/api/v1/get-companies?name=Tech&response_format=excel