Skip to main content
POST
/
v1
/
ai
/
generate-query
Generate a query
curl --request POST \
  --url https://{instance}.omniapp.co/api/v1/ai/generate-query \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "modelId": "123e4567-e89b-12d3-a456-426614174000",
  "currentTopicName": "orders",
  "prompt": "Show me total revenue by product category for the last quarter"
}
'
{
  "query": {
    "model_job": {
      "model_id": "bcf0cffd-ec1b-44d5-945a-a261ebe407fc",
      "table": "order_items",
      "fields": [
        "products.item_name",
        "order_items.total_sale_price"
      ],
      "calculations": [],
      "filters": {},
      "sorts": [
        {
          "column_name": "order_items.total_sale_price",
          "sort_descending": true,
          "is_column_sort": false,
          "null_sort": "OMNI_DEFAULT"
        }
      ],
      "limit": 10,
      "pivots": [],
      "fill_fields": [],
      "column_totals": {},
      "row_totals": {},
      "column_limit": 50,
      "default_group_by": true,
      "join_via_map": {},
      "join_paths_from_topic_name": "order_items",
      "version": 5,
      "period_over_period_computations": [],
      "query_references": {},
      "metadata": {},
      "custom_summary_types": {}
    }
  }
}

Authorizations

​
Authorization
string
header
required

Can be either an Organization API Key or Personal Access Token (PAT).

Include in the Authorization header as: Bearer YOUR_TOKEN

Body

application/json
​
modelId
string<uuid>
required

The ID of the model to run the query against

​
prompt
string
required

Natural language instruction describing the desired query output

​
currentTopicName
string

Name of the base topic/table. If left empty, AI will automatically choose a topic based on the question.

​
workbookUrl
boolean

If true, return an Omni workbook URL that will open and run the generated query

Response

Successfully generated query

​
query
object