G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
Loading setup wizard...
Back to Export Odoo company data via API endpoint with JSON/Excel output options

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

Creates an API endpoint that retrieves company records from Odoo database with flexible search and export capabilities. Accepts query parameters for company name filtering and returns results as structured JSON for integrations or Excel files for reporting purposes.

What This Automation Does
1

Receive API request with parameters

Webhook receives GET request to /api/v1/get-companies endpoint with name and response_format query parameters.

2

Validate input parameters

Checks that required company name parameter is provided and validates the request format before proceeding.

3

Query Odoo for matching companies

Searches Odoo database for company records using partial name matching with like filter to find all relevant results.

4

Format and return response

Returns company data as JSON response or Excel file download based on the specified response_format parameter.

Prerequisites

  • Odoo instance with API access enabled
  • Valid Odoo API credentials
  • Company records in Odoo database
  • n8n instance for hosting the webhook endpoint

Services Used

Odoo

Services with alternatives — you can swap them in the next step.