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

Exposes Odoo company data via API endpoint with flexible JSON or Excel export options for integrations and reporting.

workflowcrm

by V3 Code Studioon n8n

Nodes

Platform

n8n

Tech Stack

Odoo

How It Works

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.

Receive API request with parameters

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

Validate input parameters

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

Query Odoo for matching companies

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

Format and return response

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

What You'll Need

Attached Files

workflow.json