Get a Friday sales and cash summary

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, state, 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):
    monday = (date.today() - timedelta(days=date.today().weekday())).isoformat()
    invoiced = sum(i["TotalAmt"] for i in query(
        f"select * from Invoice where TxnDate >= '{monday}' maxresults 1000").get("Invoice", []))
    received = sum(p["TotalAmt"] for p in query(
        f"select * from Payment where TxnDate >= '{monday}' maxresults 1000").get("Payment", []))
    open_ar = sum(i["Balance"] for i in query(
        "select * from Invoice where Balance > '0' maxresults 1000").get("Invoice", []))
    now = {"Invoiced": invoiced, "Payments received": received, "Open receivables": open_ar}
    prev = state.get("last_week") or {}
    lines = [f"{k}: ${v:,.2f}" + (f" (last week ${prev[k]:,.2f})" if k in prev else "") for k, v in now.items()]
    notify.email_me(f"QuickBooks week of {monday}", "\n".join(lines))
    state.set("last_week", now)
    return now