Match bank statements to open invoices every day

GRAPH = "https://graph.microsoft.com/v1.0"
import csv, io
from clickruntime import on_trigger, credentials, http, state, notify, ai

BOOK = "/me/drive/root:/Finance/invoices.xlsx:/workbook/worksheets/Invoices"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    files = http.get(f"{GRAPH}/me/drive/root:/Statements:/children", headers=h, params={"$orderby": "lastModifiedDateTime desc", "$top": 1}).json()["value"]
    if not files or files[0]["id"] == state.get("last_file"):
        return {"summary": "No new statement"}
    lines = list(csv.DictReader(io.StringIO(http.get(f"{GRAPH}/me/drive/items/{files[0]['id']}/content", headers=h).text)))
    rows = http.get(f"{GRAPH}{BOOK}/usedRange", headers=h).json()["values"]
    open_inv = {r[0]: (i, float(r[2])) for i, r in enumerate(rows[1:], start=2) if r[3] != "Paid"}
    unmatched = []
    for p in lines:
        hit = next((n for n, (_, amt) in open_inv.items() if n in p["description"] and abs(amt - float(p["amount"])) < 0.01), None)
        if hit:
            http.patch(f"{GRAPH}{BOOK}/range(address='D{open_inv.pop(hit)[0]}')", headers=h, json={"values": [["Paid"]]})
        else:
            unmatched.append(f"{p['date']} {p['description']} {p['amount']}")
    report = "\n".join(unmatched) or "Everything matched."
    if unmatched and open_inv:
        report += "\n\nSuggested:\n" + ai.generate(f"Payments:\n{report}\nOpen invoices:\n" + "\n".join(f"{n} {a}" for n, (_, a) in open_inv.items()),
                                                    system="Suggest likely invoice for each payment, one per line, or 'none'.", max_output_tokens=400).text
    notify.email_me("Reconciliation report", report)
    state.set("last_file", files[0]["id"])
    return {"unmatched": len(unmatched)}