Odoo Query Model
odoo_query_modelPower-user generic query: run search_read on ANY Odoo model. Provide model (e.g. "product.template"), domain (Odoo list-of-triples, e.g. [["list_price",">",100]]), fields, and limit. Use when no specific tool above fits.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | Yes | Odoo database name. | |
| url | Yes | Odoo instance base URL, e.g. https://mycompany.odoo.com (trailing slash optional). Works for Odoo Online and self-hosted. | |
| limit | No | Max records (default 20). | |
| model | Yes | Odoo model name, e.g. "product.template", "stock.picking", "hr.employee". | |
| order | No | Sort spec, e.g. "create_date desc". | |
| domain | No | Odoo search domain — a list of triples [field, operator, value], e.g. [["active","=",true],["name","ilike","acme"]]. Empty array [] matches all. | |
| fields | No | Field names to return, e.g. ["name","create_date"]. Omit to let Odoo return its default field set. | |
| offset | No | Number of records to skip (pagination). | |
| _apiKey | Yes | Odoo API key (Settings → Account Security → API Keys) or account password. | |
| username | Yes | Odoo login email. |