Track competitor YouTube channel stats in Airtable

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

BASE = "https://api.airtable.com/v0/appXXXXXXXXXXXXXX"

def at(method, table, **kw):
    r = http.request(method, f"{BASE}/{table}", headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}, **kw)
    r.raise_for_status()
    return r.json()

@on_trigger
def run(event):
    ids = [r["fields"]["Channel ID"] for r in at("GET", "Channels", params={"fields[]": "Channel ID"})["records"]
           if r["fields"].get("Channel ID")]
    stats = []
    for i in range(0, len(ids), 50):
        stats += http.get("https://www.googleapis.com/youtube/v3/channels", params={
            "part": "snippet,statistics", "id": ",".join(ids[i:i + 50]), "key": credentials.secret("YOUTUBE_API_KEY")}).json().get("items", [])
    last, now, rows = state.get("last") or {}, {}, []
    for ch in stats:
        s = ch["statistics"]
        cur = {"subs": int(s.get("subscriberCount", 0)), "views": int(s["viewCount"]), "videos": int(s["videoCount"])}
        prev = last.get(ch["id"], cur)
        rows.append({"fields": {"Week": date.today().isoformat(), "Channel": ch["snippet"]["title"], "Channel ID": ch["id"],
                                "Subscribers": cur["subs"], "Subscriber change": cur["subs"] - prev["subs"],
                                "Views": cur["views"], "View change": cur["views"] - prev["views"],
                                "Videos": cur["videos"], "New videos": cur["videos"] - prev["videos"]}})
        now[ch["id"]] = cur
    for i in range(0, len(rows), 10):
        at("POST", "Weekly stats", json={"records": rows[i:i + 10], "typecast": True})
    state.set("last", now)
    return {"channels": len(rows)}