Get a weekly receivables and payments email

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

ORG_ID = "your-zoho-organization-id"
ZB = "https://www.zohoapis.com/books/v3"

def zoho(path, **params):
    token = credentials.connection("zoho-books", "work")
    resp = http.get(f"{ZB}/{path}", headers={"Authorization": f"Zoho-oauthtoken {token}"},
                    params={"organization_id": ORG_ID, **params})
    resp.raise_for_status()
    return resp.json()

@on_trigger
def run(event):
    unpaid = zoho("invoices", status="unpaid", per_page=200)["invoices"]
    by_customer = defaultdict(float)
    for i in unpaid:
        by_customer[i["customer_name"]] += i["balance"]
    top = sorted(by_customer.items(), key=lambda kv: -kv[1])[:5]
    week_ago = (date.today() - timedelta(days=7)).isoformat()
    payments = [p for p in zoho("customerpayments", sort_column="date", sort_order="D")["customerpayments"] if p["date"] >= week_ago]
    body = (f"Unpaid total: {sum(by_customer.values()):,.2f}\n\nTop customers:\n"
            + "\n".join(f"{n}: {v:,.2f}" for n, v in top)
            + "\n\nPayments last week:\n" + "\n".join(f"{p['date']} {p['customer_name']}: {p['amount']:,.2f}" for p in payments))
    notify.email_me("Weekly receivables", body)
    return {"unpaid": len(unpaid), "payments": len(payments)}