Get an evening list of payments received

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

REALM_ID = "1234567890"
API = f"https://quickbooks.api.intuit.com/v3/company/{REALM_ID}"

def qb(method, path, **kw):
    headers = {"Authorization": f"Bearer {credentials.connection('quickbooks', 'company')}", "Accept": "application/json"}
    resp = http.request(method, f"{API}{path}", headers=headers, params={"minorversion": 73, **kw.pop("params", {})}, **kw)
    resp.raise_for_status()
    return resp.json()

def query(sql):
    return qb("GET", "/query", params={"query": sql})["QueryResponse"]

@on_trigger
def run(event):
    today = date.today().isoformat()
    payments = query(f"select * from Payment where TxnDate = '{today}'").get("Payment", [])
    if not payments:
        return {"payments": 0}
    lines = []
    for p in payments:
        invoice_ids = [t["TxnId"] for line in p.get("Line", []) for t in line.get("LinkedTxn", []) if t["TxnType"] == "Invoice"]
        numbers = [qb("GET", f"/invoice/{i}")["Invoice"]["DocNumber"] for i in invoice_ids]
        lines.append(f"- {p['CustomerRef']['name']}: ${p['TotalAmt']:,.2f} (invoice {', '.join(numbers) or 'none'})")
    total = sum(p["TotalAmt"] for p in payments)
    notify.email_me(f"Payments today: ${total:,.2f}", "\n".join(lines + ["", f"Total: ${total:,.2f}"]))
    return {"payments": len(payments), "total": total}