Post weekly support numbers to Slack

from datetime import date, timedelta
from statistics import median
from clickruntime import on_trigger, http, credentials, state, notify

ZD, AGENT = "https://yourcompany.zendesk.com/api/v2", "you@yourcompany.com"

def zd(method, path, **kw):
    r = http.request(method, ZD + path, auth=(f"{AGENT}/token", credentials.secret("ZENDESK_API_TOKEN")), **kw)
    return r.raise_for_status() or (r.json() if r.content else None)


@on_trigger
def run(event):
    start, end = (date.today() - timedelta(days=7)).isoformat(), date.today().isoformat()
    created = zd("GET", "/search/count", params={"query": f"type:ticket created>={start} created<{end}"})["count"]
    solved = zd("GET", "/search/count", params={"query": f"type:ticket solved>={start} solved<{end}"})["count"]
    metrics = zd("GET", "/ticket_metrics", params={"per_page": 100})["ticket_metrics"]
    replies = [m["reply_time_in_minutes"]["business"] for m in metrics
               if m["created_at"][:10] >= start and (m.get("reply_time_in_minutes") or {}).get("business")]
    now = {"created": created, "solved": solved, "reply": round(median(replies)) if replies else 0}
    last = state.get("last") or now
    diff = lambda k: f"{now[k] - last[k]:+d}"
    notify.slack(f"Support last week\nNew tickets: {now['created']} ({diff('created')})\nSolved: {now['solved']} ({diff('solved')})\n"
                 f"Median first reply: {now['reply']} min ({diff('reply')})", channel="#support")
    state.set("last", now)
    return now