Export Odoo company data via API endpoint with JSON/Excel output options
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Prepare Dynamic Filter, Prepare Output Data | Code node, mode 'Run Once for All Items' |
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - Function
n8n-nodes-base.function - Odoo
n8n-nodes-base.odoo - If
n8n-nodes-base.if - Convert to File
n8n-nodes-base.convertToFile - Respond to Webhook
n8n-nodes-base.respondToWebhook - Code
n8n-nodes-base.code
What it does
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: 1. Accepts query parameters (name, responseformat). 2. Validates the name input (required for company search). 3. Fetches all matching companies from Odoo using a like filter for partial name matches. 4. Returns results as a JSON response or Excel file depending on the responseformat parameter. This makes it ideal for quickly exporting or syncing company information with other tools. Setup steps 1. Open the Webhook node and note the endpoint /api/v1/get-companies. 2. Connect your Odoo API credentials in the Odoo node. 3. Optionally update the fieldsList in the Odoo node to include more company details (VAT, address, etc.). 4. Test using a browser or Postman: - /api/v1/get-companies?name=Tech&responseformat=json - /api/v1/get-companies?name=Tech&responseformat=excel