Delete a person's records on request

import hashlib
from datetime import datetime, timezone
from clickruntime import on_event, credentials, http, notify

BASE_ID = "appXXXXXXXXXXXXXX"

@on_event
def handle(event):
    email = ((event.json or {}).get("email") or "").strip().lower()
    if not email:
        return {"deleted": 0}
    api = f"https://api.airtable.com/v0/{BASE_ID}"
    headers = {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    found = http.get(f"{api}/Customers", headers=headers, params={
        "filterByFormula": f"LOWER({{Email}}) = '{email.replace(chr(39), '')}'"}).json()["records"]
    ids = [r["id"] for r in found]
    for i in range(0, len(ids), 10):
        http.delete(f"{api}/Customers", headers=headers, params={"records[]": ids[i:i + 10]}).raise_for_status()
    digest = hashlib.sha256(email.encode()).hexdigest()
    http.post(f"{api}/Deletion Log", headers=headers, json={"records": [{"fields": {
        "Email Hash": digest, "Records Deleted": len(ids),
        "Date": datetime.now(timezone.utc).isoformat(timespec="seconds")}}]}).raise_for_status()
    notify.email_me("Data deletion request completed", f"Deleted {len(ids)} record(s). Hash: {digest[:12]}…")
    return {"deleted": len(ids)}