Get Started
Back to Templates

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

Created by

Created by: V3 Code Studio || v3codestudio

V3 Code Studio

Last update

Last update 4 days ago

Categories

Share

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