👋 Welcome to the new Omni docs! We're still migrating, but the old docs are available at docs-legacy.omni.co.
cURL
curl --request POST \ --url https://{instance}.omniapp.co/api/v1/query/run \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --data ' { "query": { "modelId": "123e4567-e89b-12d3-a456-426614174000", "table": "orders", "fields": [ "order_id", "total_amount" ], "limit": 100 } } '
{ "jobs_submitted": 123, "job_id": "<string>", "status": "<string>", "summary": {}, "cache_metadata": {}, "query": {}, "result": "<string>" }
Execute workbook query and retrieve results
Use either an Organization API Key or Personal Access Token (PAT). Include in the Authorization header as: Bearer YOUR_TOKEN
Bearer YOUR_TOKEN
Show child attributes
Model identifier
Base table/topic
Column names
Result limit (default 1000, null for unlimited, max 75000)
Sort specifications
Filter conditions
Pivot configurations
Custom calculations
Column total configuration
Row total configuration
Column limit for pivots
Topic name for join paths
Query version
Enable default grouping
DBT mode
SQL rewrite mode
Execute query as specified user
Cache policy (e.g., "SkipRequery")
Export format (e.g., "csv")
Return execution plan only
Query results (streaming response)
Base64-encoded Apache Arrow format
Was this page helpful?