Get a Monday list of overdue tasks by owner

import json
from collections import defaultdict
from datetime import date, timedelta
from clickruntime import on_trigger, notify, http, credentials

API = "https://www.wrike.com/api/v4"
FOLDER = "IEAAAAAAI4AAAAAB"  # your Marketing folder id

@on_trigger
def run(event):
    headers = {"Authorization": "Bearer " + credentials.connection("wrike", "main")}
    today = date.today()
    tasks = http.get(f"{API}/folders/{FOLDER}/tasks", headers=headers, params={
        "status": "Active", "descendants": "true", "fields": json.dumps(["responsibleIds"]),
        "dueDate": json.dumps({"end": (today - timedelta(days=1)).isoformat()}),
    }).json()["data"]
    ids = {r for t in tasks for r in t["responsibleIds"]}
    names = {c["id"]: f"{c['firstName']} {c['lastName']}" for c in http.get(f"{API}/contacts/{','.join(ids)}", headers=headers).json()["data"]} if ids else {}
    groups = defaultdict(list)
    for t in tasks:
        late = (today - date.fromisoformat(t["dates"]["due"][:10])).days
        for person in [names.get(r, "?") for r in t["responsibleIds"]] or ["Unassigned"]:
            groups[person].append(f"  {late} days late  {t['title']}\n  {t['permalink']}")
    body = "\n\n".join(f"{p}\n" + "\n".join(items) for p, items in sorted(groups.items()))
    notify.email_me(f"{len(tasks)} overdue Marketing tasks", body or "Nothing overdue in Marketing.")
    return {"overdue": len(tasks)}