news

BI Query API: Turn Any Odoo SQL Query Into a Secure REST Endpoint

November 17, 2026 · News
BI Query API: Turn Any Odoo SQL Query Into a Secure REST Endpoint

Odoo is excellent at storing your business data. Getting it out — into a dashboard, an automation or an agent — has always been the awkward part. We released a module that removes that friction: BI Query API.

Write a SQL query once inside Odoo, get a token-secured URL back, and call it from anything that speaks HTTP and JSON. No Python, no controller, no middleware, and no Odoo session to manage.

The headline: dynamic query parameters

Instead of one query per report variation, you declare parameters — a date range, a customer, a list of IDs — reference them in your SQL as %(name)s, and let the calling tool send the values with each request. One query, endless reports.

SQL-injection-safe by design

Parameter values are never concatenated into your SQL: they are type-checked and passed to PostgreSQL separately, so a value can never alter the query itself. Text, integer, decimal, boolean, date, datetime and lists are supported, with required flags and default values — and a wrong type returns a clear HTTP 400 naming the parameter instead of a confusing database error.

Built for the tools you already run

Every stored query carries its own cryptographically secure Bearer token.

← Back to the Blog