Hear when daily sales look unusual

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):
    day = (date.today() - timedelta(days=1)).isoformat()
    invoices = query(f"select * from Invoice where TxnDate = '{day}'").get("Invoice", [])
    receipts = query(f"select * from SalesReceipt where TxnDate = '{day}'").get("SalesReceipt", [])
    total = sum(i["TotalAmt"] for i in invoices) + sum(r["TotalAmt"] for r in receipts)
    history = state.get("history") or []
    average = sum(history) / len(history) if history else None
    state.set("history", (history + [total])[-30:])
    if average and abs(total - average) / average > 0.3:
        notify.email_me(f"Unusual sales day: ${total:,.2f} on {day}",
                        f"Invoices + sales receipts: ${total:,.2f}\n30-day average: ${average:,.2f}\n"
                        f"Difference: {(total - average) / average:+.0%}")
    return {"total": total, "average": average}