Send WhatsApp reminders for due dates in Supabase

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http

TABLE = "renewals"
SUPABASE_URL = "https://your-project.supabase.co"
sb = lambda: {"apikey": credentials.secret("SUPABASE_SECRET_KEY"), "Authorization": f"Bearer {credentials.secret('SUPABASE_SECRET_KEY')}"}
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa_template(to, name, params):
    body = {"messaging_product": "whatsapp", "to": to, "type": "template", "template": {"name": name, "language": {"code": "en"},
            "components": [{"type": "body", "parameters": [{"type": "text", "text": str(p)} for p in params]}]}}
    return http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"}, json=body).json()

@on_trigger
def run(event):
    due = (date.today() + timedelta(days=3)).isoformat()
    rows = http.get(f"{SUPABASE_URL}/rest/v1/{TABLE}", headers=sb(),
                    params={"due_date": f"eq.{due}", "reminded": "is.false", "select": "id,name,phone,due_date"}).json()
    sent = 0
    for r in rows:
        res = wa_template(r["phone"], "renewal_reminder", [r["name"], r["due_date"]])
        if "messages" in res:
            http.patch(f"{SUPABASE_URL}/rest/v1/{TABLE}", headers=sb(), params={"id": f"eq.{r['id']}"}, json={"reminded": True})
            sent += 1
    return {"due": len(rows), "sent": sent}