Skip to main content
Requires the Odoo integration. This tool is read-only. Pass model, an Odoo JSON domain, and operation (search, count, or group). Search defaults to id and display_name; choose fields explicitly for other data.
limit is 1–200 (default 50), and offset defaults to 0. Follow next_offset while has_more is true. Queries are bounded pages, not complete datasets; concurrent changes can shift offset pagination. Use operation: "count" for the exact count visible to the API user. For grouped totals, provide groupby and aggregates:
Aggregates support sum, avg, min, max, count, and count_distinct, with one aggregate per field in each query. Date grouping supports day, week, month, quarter, and year. Group by currency when summing monetary values across currencies. The grouped result is also paginated. Set groupby: [] for a single total over the entire domain when the units/currency are consistent. All operations accept instance and context (allowed_company_ids, lang, tz, active_test). Odoo enforces the user’s permissions and record rules.