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

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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.