Skip to main content

Export Odoo company data via API endpoint with JSON/Excel output options

n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

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, response_format).
  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 response_format 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&response_format=json
    • /api/v1/get-companies?name=Tech&response_format=excel