Fetch Odoo customer data and export to JSON or Excel
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Prepare Dynamic Filter1, Prepare Output Data1 | Code node, mode 'Run Once for All Items' |
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - Function
n8n-nodes-base.function - If
n8n-nodes-base.if - Convert to File
n8n-nodes-base.convertToFile - Respond to Webhook
n8n-nodes-base.respondToWebhook - Odoo
n8n-nodes-base.odoo - Code
n8n-nodes-base.code
What it does
Odoo Customers API – Export to JSON or Excel Odoo Customers API – Export to JSON or Excel provides a simple way to fetch customer records from your Odoo database and get them back either as a structured JSON response or a downloadable Excel (.xlsx) file. ⚙️ What it does - Listens for HTTP GET requests on the endpoint /api/v1/get-customers. - Checks for the required name parameter and builds a search filter automatically. - Queries the res.partner model to return only customer contacts (iscompany = false). - Delivers results in JSON by default, or as an Excel (.xlsx) export when responseformat=excel is included. 📥 Parameters - name — Required. Used for partial matching on customer names (via Odoo’s Like filter). - responseformat — Optional. Accepts json (default) or excel. 🔗 Examples Excel Example GET /api/v1/get-customers?name=Demo&responseformat=excel JSON Example GET /api/v1/get-customers?name=Demo&responseformat=json 🧩 Default fields displayname, name, email, phone, mobile, parentid, companyid, countrycode, countryid 🛠️ Setup - Open the Odoo node and connect your Odoo API credentials. - Adjust the fieldsList in the node if you want to include more data fields (e.g., address, city, or VAT). - Trigger the flow from its webhook URL or run it manually inside n8n to test the output. 💡 Notes - Built and tested for n8n v1.108.2+