curl -X POST https://api.trellis.sh/v1/queries \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "title": "Customer Spend by Region",
    "prompt": "Rank customers by total spend in the selected region.",
    "sql": "SELECT CustomerId, SUM(Amount) AS TotalSpend FROM dbo.Orders WHERE Region = '\''{{region}}'\'' GROUP BY CustomerId ORDER BY TotalSpend DESC",
    "description": "Ranks customers by total spend for a selected region"
  }'

import requests

response = requests.post(
    "https://api.trellis.sh/v1/queries",
    headers={
        "Authorization": "Bearer YOUR_TOKEN",
        "Content-Type": "application/json"
    },
    json={
        "title": "Customer Spend by Region",
        "prompt": "Rank customers by total spend in the selected region.",
        "sql": "SELECT CustomerId, SUM(Amount) AS TotalSpend FROM dbo.Orders WHERE Region = '{{region}}' GROUP BY CustomerId ORDER BY TotalSpend DESC",
        "description": "Ranks customers by total spend for a selected region"
    }
)
new_query = response.json()

const response = await fetch("https://api.trellis.sh/v1/queries", {
  method: "POST",
  headers: {
    Authorization: "Bearer YOUR_TOKEN",
    "Content-Type": "application/json",
  },
  body: JSON.stringify({
    title: "Customer Spend by Region",
    prompt: "Rank customers by total spend in the selected region.",
    sql: "SELECT CustomerId, SUM(Amount) AS TotalSpend FROM dbo.Orders WHERE Region = '{{region}}' GROUP BY CustomerId ORDER BY TotalSpend DESC",
    description: "Ranks customers by total spend for a selected region",
  }),
});
const newQuery = await response.json();

{
  "id": "b2c3d4e5-f6a7-8901-bcde-f12345678901",
  "organization_id": "20000000-0000-4000-8000-000000000001",
  "title": "Customer Spend by Region",
  "description": "Ranks customers by total spend for a selected region",
  "prompt": "Rank customers by total spend in the selected region.",
  "sql": "SELECT CustomerId, SUM(Amount) AS TotalSpend FROM dbo.Orders WHERE Region = '{{region}}' GROUP BY CustomerId ORDER BY TotalSpend DESC",
  "parameters": ["region"],
  "last_updated_by": "30000000-0000-4000-8000-000000000001",
  "last_updated_by_name": "Jane Smith",
  "created_at": "2026-08-08T10:00:00+00:00",
  "updated_at": "2026-08-08T10:00:00+00:00"
}

{
  "detail": [
    {"type": "missing", "loc": ["body", "title"], "msg": "Field required"}
  ]
}