Answer texted questions from your Airtable info

from clickruntime import on_event, credentials, http, ai

BASE_ID, FROM, PHONE = "appXXXXXXXXXXXXXX", "+447700900000", "01632 960 123"

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 {}
    sender, question = msg.get("From"), (msg.get("Body") or "").strip()
    if not sender or not question:
        return {"ignored": True}
    courses = http.get(f"https://api.airtable.com/v0/{BASE_ID}/Courses",
                       headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"},
                       params={"pageSize": 100}).json()["records"]
    info = "\n".join("; ".join(f"{k}: {v}" for k, v in r["fields"].items()) for r in courses)[:20000]
    answer = ai.generate(f"Courses:\n{info}\n\nQuestion: {question[:500]}", max_output_tokens=150,
                         system=f"Answer in under 300 characters using only the course data. If unsure, say so and give {PHONE}.").text
    sms(sender, answer[:320]).raise_for_status()
    return {"answered": True}