Reply to texts with the weather and log each request

from clickruntime import on_event, credentials, http

BASE_ID, FROM = "appXXXXXXXXXXXXXX", "+447700900000"

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, place = msg.get("From"), (msg.get("Body") or "").strip()[:60]
    if not sender or not place:
        return {"ignored": True}
    found = http.get("https://geocoding-api.open-meteo.com/v1/search", params={"name": place, "count": 1}).json().get("results")
    if found:
        loc = found[0]
        now = http.get("https://api.open-meteo.com/v1/forecast", params={"latitude": loc["latitude"], "longitude": loc["longitude"],
                       "current": "temperature_2m,wind_speed_10m,precipitation"}).json()["current"]
        reply = (f"{loc['name']}: {now['temperature_2m']}C, wind {now['wind_speed_10m']} km/h, "
                 f"rain {now['precipitation']} mm now.")
    else:
        reply = f"Sorry, I couldn't find {place}. Try a nearby larger town."
    sms(sender, reply).raise_for_status()
    http.post(f"https://api.airtable.com/v0/{BASE_ID}/Requests",
              headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"},
              json={"records": [{"fields": {"From": sender, "Place": place, "Reply": reply,
                    "Received": event.received_at}}]}).raise_for_status()
    return {"found": bool(found)}