Get a weekly list of cards nobody has touched

from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, http, credentials, notify

BOARD_ID = "CLIENT_WORK_BOARD_ID"

def trello(method, path, **params):
    params.update(key=credentials.secret("TRELLO_API_KEY"), token=credentials.secret("TRELLO_TOKEN"))
    r = http.request(method, f"https://api.trello.com/1{path}", params=params)
    r.raise_for_status()
    return r.json()

@on_trigger
def run(event):
    cutoff = datetime.now(timezone.utc) - timedelta(days=14)
    lists = {l["id"]: l["name"] for l in trello("GET", f"/boards/{BOARD_ID}/lists", fields="name")}
    cards = trello("GET", f"/boards/{BOARD_ID}/cards", fields="name,idList,dateLastActivity,shortUrl")
    stale = [c for c in cards if datetime.fromisoformat(c["dateLastActivity"].replace("Z", "+00:00")) < cutoff]
    stale.sort(key=lambda c: lists[c["idList"]])
    lines = [f"{lists[c['idList']]} · {c['name']} (last {c['dateLastActivity'][:10]}) {c['shortUrl']}" for c in stale]
    notify.email_me(f"{len(stale)} quiet cards on Client Work", "\n".join(lines) or "No stale cards.")
    return {"stale": len(stale)}