Search Record IDs
odoo.search
ActionCRM & salesconnection required
Calls the Odoo API with the connection's credentials.
Search a model with a domain and return only the matching record ids, which is the cheapest way to feed a loop or a later write.
Connection
- Required
- Yes — the node will not save without one
- Auth type
- API key
- Providers
- Odoo
- Secret shape
- the API key, or {"api_key": "…"} — Odoo takes it in place of the password
- Config it needs
- base_url, db, username, uid
- Resolved by
- config.connection_id, else node.connection_id
Configuration
5 fields, 1 required. A dotted path is a nested object and name[] an array of objects — the editor renders the same tree.
| Field | Type | Required | Default | Constraints | Example |
|---|---|---|---|---|---|
model Technical name of the Odoo model to act on, such as 'res.partner' or 'sale.order'. | string | Yes | — | — | res.partner |
domain Odoo search domain: a JSON array of conditions, e.g. [["is_company", "=", true]]. Leave it empty to match every record the user may read. | array | No | — | — | [["is_company","=",true]] |
offset How many matching records to skip before the first one returned. | number | No | 0 | ≥ 0 | — |
limit Maximum number of records to return; 0 asks Odoo for all of them. | number | No | 0 | ≥ 0 | — |
order Sort clause in SQL form, such as 'create_date desc, name asc'. | string | No | — | — | create_date desc |
Example configuration
Every value below is the contract’s own example or default — nothing invented.
{
"domain": [
[
"is_company",
"=",
true
]
],
"limit": 0,
"model": "res.partner",
"offset": 0,
"order": "create_date desc"
}Output
One shape.
result
| Field | Type | Example |
|---|---|---|
ids Ids of the matching records, in the requested order. | array | — |
count How many records the call returned or affected. | number | — |
model The model the call was made against. | string | — |
{
"count": 0,
"ids": [],
"model": ""
}Notes
- Each call authenticates first unless the connection carries a 'uid', which halves the requests this node makes.
See Search Record IDs run in a workflow.
In a technical demo we add the Odoo connection, drop the node on the canvas and let Workflow Health pre-flight it before the first real run.