Classify developer questions into Notion and Airtable

from clickruntime import on_event, credentials, http, state, ai, notify

NOTION_DB, AIRTABLE_BASE, AIRTABLE_TABLE = "your-notion-database-id", "appXXXXXXXXXXXXXX", "Issues"
SCHEMA = {"type": "object", "properties": {"category": {"enum": ["api", "billing", "auth", "docs", "other"]},
          "severity": {"enum": ["low", "medium", "high"]}, "summary": {"type": "string"}}, "required": ["category", "severity", "summary"]}

@on_event
def handle(event):
    if state.get(f"done:{event.event_id}"):
        return {"skipped": "duplicate"}
    text = str((event.json or {}).get("text") or event.body)[:4000]
    try:
        c = ai.generate(text, system="Classify this developer question or error report.", json_schema=SCHEMA, max_output_tokens=120).json
    except ai.AIError:
        c = {"category": "other", "severity": "medium", "summary": text[:120]}
    http.post("https://api.notion.com/v1/pages", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}", "Notion-Version": "2022-06-28"}, json={"parent": {"database_id": NOTION_DB},
              "properties": {"Name": {"title": [{"text": {"content": c["summary"][:200]}}]}, "Category": {"select": {"name": c["category"]}}, "Severity": {"select": {"name": c["severity"]}}},
              "children": [{"object": "block", "type": "paragraph", "paragraph": {"rich_text": [{"text": {"content": text[:1900]}}]}}]}).raise_for_status()
    http.post(f"https://api.airtable.com/v0/{AIRTABLE_BASE}/{AIRTABLE_TABLE}", headers={"Authorization": f"Bearer {credentials.secret('AIRTABLE_TOKEN')}"},
              json={"fields": {"Summary": c["summary"], "Category": c["category"], "Severity": c["severity"]}}).raise_for_status()
    if c["severity"] == "high":
        notify.slack(f"🚨 High severity {c['category']} report: {c['summary']}", channel="#dev")
    state.set(f"done:{event.event_id}", True)
    return {"category": c["category"], "severity": c["severity"]}