Spot recurring incidents in ServiceNow every morning

from clickruntime import on_trigger, credentials, http, ai, notify

INSTANCE = "northwind.service-now.com"

def sn(method, path, **kw):
    r = http.request(method, f"https://{INSTANCE}/api/now/table/{path}", auth=(credentials.secret("SERVICENOW_USER"), credentials.secret("SERVICENOW_PASSWORD")),
                     headers={"Accept": "application/json"}, **kw)
    r.raise_for_status()
    return r.json()["result"]

@on_trigger
def run(event):
    incidents = sn("GET", "incident", params={"sysparm_query": "sys_created_on>=javascript:gs.daysAgoStart(7)", "sysparm_limit": "400",
                                              "sysparm_fields": "number,category,short_description"})
    if not incidents:
        return {"incidents": 0}
    lines = "\n".join(f"{i['number']} [{i['category']}] {i['short_description'][:120]}" for i in incidents)
    summary = ai.generate(f"Incidents from the last 7 days:\n{lines}\n\nGroup incidents describing the same underlying issue. "
                          "List groups with 3 or more incidents as: issue - count - up to 3 example numbers. Most frequent first.",
                          max_output_tokens=600).text.strip()
    notify.slack(f"🔁 Recurring issues, last 7 days ({len(incidents)} incidents):\n{summary}", channel="#it-ops")
    return {"incidents": len(incidents)}