Turn tenant repair texts into tickets and alert the vendor

from clickruntime import on_event, credentials, http, ai
BASE_ID, FROM = "appXXXXXXXXXXXXXX", "+447700900000"
SCHEMA = {"type": "object", "properties": {"trade": {"enum": ["Plumbing", "Electrical", "Heating", "General"]},
          "urgent": {"type": "boolean"}, "summary": {"type": "string"}}, "required": ["trade", "urgent", "summary"]}
def sms(to, body):
    sid = credentials.secret("TWILIO_ACCOUNT_SID")
    return http.post(f"https://api.twilio.com/2010-04-01/Accounts/{sid}/Messages.json",
                     auth=(sid, credentials.secret("TWILIO_AUTH_TOKEN")), data={"From": FROM, "To": to, "Body": body})
@on_event
def handle(event):
    msg = event.json or {}
    tenant, text = msg.get("From"), (msg.get("Body") or "").strip()
    if not tenant or not text:
        return {"ignored": True}
    job = ai.generate(text[:1500], json_schema=SCHEMA, max_output_tokens=120,
                      system="Classify this tenant repair request by trade; urgent if leak, no heat or hot water, electrical danger, gas or security.").json
    api = f"https://api.airtable.com/v0/{BASE_ID}"
    headers = {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    ticket = http.post(f"{api}/Maintenance", headers=headers, json={"typecast": True, "records": [{"fields": {
        "Tenant phone": tenant, "Message": text, "Trade": job["trade"], "Urgent": job["urgent"],
        "Summary": job["summary"], "Status": "Open"}}]}).json()["records"][0]
    ref = ticket["id"][-5:].upper()
    vendor = http.get(f"{api}/Vendors", headers=headers, params={"filterByFormula": f"{{Trade}}='{job['trade']}'", "maxRecords": 1}).json()["records"]
    if vendor:
        flag = "URGENT " if job["urgent"] else ""
        sms(vendor[0]["fields"]["Phone"], f"{flag}Job {ref}: {job['summary']}. Tenant: {tenant}")
    sms(tenant, f"Thanks, we've logged your request (ref {ref}) and passed it to our {job['trade'].lower()} contractor.")
    return {"ticket": ticket["id"], "urgent": job["urgent"]}