Log receipts sent to Telegram in Excel

GRAPH = "https://graph.microsoft.com/v1.0"
TG = "https://api.telegram.org"
import base64
from clickruntime import on_event, credentials, http, state, ai

ALLOWED = {123456789}
TABLE = "/me/drive/root:/Finance/expenses.xlsx:/workbook/tables/Expenses/rows/add"
SCHEMA = {"type": "object", "properties": {"date": {"type": "string"}, "supplier": {"type": "string"}, "total": {"type": "number"}}, "required": ["date", "supplier", "total"]}

@on_event
def handle(event):
    msg = (event.json or {}).get("message", {})
    chat = msg.get("chat", {}).get("id")
    f = (msg.get("photo") or [None])[-1] or msg.get("document")
    if chat not in ALLOWED or not f:
        return {"skipped": True}
    bot = f"{TG}/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}"
    path = http.get(f"{bot}/getFile", params={"file_id": f["file_id"]}).json()["result"]["file_path"]
    data = http.get(f"{TG}/file/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/{path}").content
    r = ai.generate(["Read this receipt. Return date (YYYY-MM-DD), supplier and total.", base64.b64encode(data).decode()[:30000]],
                    json_schema=SCHEMA, max_output_tokens=80).json
    key = f"{r['date']}|{r['supplier'].lower()}|{r['total']}"
    if state.get(key):
        http.post(f"{bot}/sendMessage", json={"chat_id": chat, "text": "Already logged this one."})
        return {"duplicate": key}
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    http.post(f"{GRAPH}{TABLE}", headers=h, json={"values": [[r["date"], r["supplier"], r["total"], str(chat)]]}).raise_for_status()
    state.set(key, True)
    http.post(f"{bot}/sendMessage", json={"chat_id": chat, "text": f"Logged {r['supplier']} {r['total']:.2f} on {r['date']}"})
    return {"logged": key}