5/12/26, 2:28 PM API Reference
Products Resources Other Releases Logout
Temenos Transact
API Reference
Updated On 16 April 2026 | 2 Min(s) read
Feedback
The backend exposes REST API endpoints for querying COB data and managing configuration.
Query Endpoints
Method Endpoint Description
POST /ask Main query endpoint used by the chatbot. Generates SQL from natural-language questions, executes it,
and returns structured results.
The endpoint accepts { "question": "...", "history": [] } as a JSON body.
System Endpoints
Method Endpoint Description
GET /health Database connectivity check with row counts per table.
GET /config Returns the chatbot API URL (derived from PORT).
Query Routing
The ROUTER_MODE environment variable controls how the system routes questions:
Mode Behavior
sql Always generates and executes SQL queries. This is the default and recommended mode.
SQL Safety
All AI-generated SQL passes through multiple safety layers before execution:
[Link] 1/2
5/12/26, 2:28 PM API Reference
Table allowlist - The system permits queries only on the observer_runs, observer_control_list, observer_agent_metrics, and
related tables.
Mutation blocking - INSERT, UPDATE, DELETE, and DDL statements are rejected.
Row limit - Results are capped at DB_SQLITE_LIMIT (default 200 rows).
Dialect normalization - Fixes common SQLite incompatibilities (EXTRACT, date formats, alias scoping).
Optional LLM validator - Second-pass AI review of generated SQL for correctness.
EXAMPLE:
curl -X POST [Link] \
-H "Content-Type: application/json" \
-d '{"question": "show top 10 slowest jobs"}'
The response includes the response type (table or text), the generated SQL query, structured tabular data, and a narrative text
answer.
[Link] 2/2