Use Jev as semantic SQL filters

curl -sS https://router.flatkey.ai/api/alpha/decisions \
  -H "Authorization: Bearer $FLATKEY_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "model": "typesafe/jev-1.13",
  "state": "Table: support_tickets  id: 48213  plan: Business  mrr: $1,200\nSubject: Charged twice AND someone logged in from Brazil??\nBody: This is the third time I'\''ve written. We were billed twice this month, and today I got a login alert from São Paulo that wasn'\''t us. If this isn'\''t sorted by Friday we'\''re moving to another vendor.\nTask: team (billing/technical/security/sales), is_angry, urgency.",
  "questions": {
    "team": {
      "type": "choice",
      "instructions": "Which team should own this support ticket? Pick the single best queue based on what the customer actually needs.",
      "criteria": {
        "billing": "Charges, invoices, refunds, plan changes, payment failures",
        "technical": "Bugs, errors, outages, integrations, how-to questions about the product",
        "security": "Account takeover, suspicious access, leaked credentials, data exposure or vulnerability reports",
        "sales": "New purchases, upgrades, quotes, pricing questions from prospects or expanding customers"
      }
    },
    "is_angry": {
      "type": "noul",
      "instructions": "The customer is angry or seriously frustrated, including polite but clear threats to cancel or escalate."
    },
    "urgency": {
      "type": "score",
      "instructions": "How urgent is this ticket for the business, considering customer impact, money at risk and security exposure.",
      "criteria": [
        "low",
        "medium",
        "high"
      ]
    }
  }
}'

// Node.js 18+ (built-in fetch). Run: FLATKEY_API_KEY=... node jev.mjs
const body = {
  "model": "typesafe/jev-1.13",
  "state": "Table: support_tickets  id: 48213  plan: Business  mrr: $1,200\nSubject: Charged twice AND someone logged in from Brazil??\nBody: This is the third time I've written. We were billed twice this month, and today I got a login alert from São Paulo that wasn't us. If this isn't sorted by Friday we're moving to another vendor.\nTask: team (billing/technical/security/sales), is_angry, urgency.",
  "questions": {
    "team": {
      "type": "choice",
      "instructions": "Which team should own this support ticket? Pick the single best queue based on what the customer actually needs.",
      "criteria": {
        "billing": "Charges, invoices, refunds, plan changes, payment failures",
        "technical": "Bugs, errors, outages, integrations, how-to questions about the product",
        "security": "Account takeover, suspicious access, leaked credentials, data exposure or vulnerability reports",
        "sales": "New purchases, upgrades, quotes, pricing questions from prospects or expanding customers"
      }
    },
    "is_angry": {
      "type": "noul",
      "instructions": "The customer is angry or seriously frustrated, including polite but clear threats to cancel or escalate."
    },
    "urgency": {
      "type": "score",
      "instructions": "How urgent is this ticket for the business, considering customer impact, money at risk and security exposure.",
      "criteria": [
        "low",
        "medium",
        "high"
      ]
    }
  }
};

const res = await fetch("https://router.flatkey.ai/api/alpha/decisions", {
  method: "POST",
  headers: {
    Authorization: `Bearer ${process.env.FLATKEY_API_KEY}`,
    "Content-Type": "application/json",
  },
  body: JSON.stringify(body),
});
if (!res.ok) throw new Error(`Jev request failed: ${res.status} ${await res.text()}`);
const { answers, usage } = await res.json();
console.log(JSON.stringify(answers, null, 2), usage);

# Python 3.8+ (pip install requests). Run: FLATKEY_API_KEY=... python jev.py
import json, os, requests

body = json.loads(r"""{
  "model": "typesafe/jev-1.13",
  "state": "Table: support_tickets  id: 48213  plan: Business  mrr: $1,200\nSubject: Charged twice AND someone logged in from Brazil??\nBody: This is the third time I've written. We were billed twice this month, and today I got a login alert from São Paulo that wasn't us. If this isn't sorted by Friday we're moving to another vendor.\nTask: team (billing/technical/security/sales), is_angry, urgency.",
  "questions": {
    "team": {
      "type": "choice",
      "instructions": "Which team should own this support ticket? Pick the single best queue based on what the customer actually needs.",
      "criteria": {
        "billing": "Charges, invoices, refunds, plan changes, payment failures",
        "technical": "Bugs, errors, outages, integrations, how-to questions about the product",
        "security": "Account takeover, suspicious access, leaked credentials, data exposure or vulnerability reports",
        "sales": "New purchases, upgrades, quotes, pricing questions from prospects or expanding customers"
      }
    },
    "is_angry": {
      "type": "noul",
      "instructions": "The customer is angry or seriously frustrated, including polite but clear threats to cancel or escalate."
    },
    "urgency": {
      "type": "score",
      "instructions": "How urgent is this ticket for the business, considering customer impact, money at risk and security exposure.",
      "criteria": [
        "low",
        "medium",
        "high"
      ]
    }
  }
}""")

res = requests.post(
    "https://router.flatkey.ai/api/alpha/decisions",
    headers={"Authorization": f"Bearer {os.environ['FLATKEY_API_KEY']}"},
    json=body,
    timeout=60,
)
res.raise_for_status()
data = res.json()
print(json.dumps(data["answers"], indent=2), data.get("usage"))

No Flatkey key yet? Get one for Jev 1.13 →