Compare Jira progress with monday.com goals weekly

from datetime import date
from clickruntime import on_trigger, credentials, http, notify

BOARD = 1234567890
ITEMS = """query ($board: [ID!]) { boards(ids: $board) { items_page(limit: 200) { items {
  id name url column_values { id text } } } } }"""
def monday(query, **variables):
    resp = http.post("https://api.monday.com/v2", json={"query": query, "variables": variables},
                     headers={"Authorization": credentials.secret("MONDAY_API_TOKEN"), "API-Version": "2024-10"})
    resp.raise_for_status()
    return resp.json()["data"]

JIRA_URL = "https://api.atlassian.com/ex/jira/your-cloud-id/rest/api/3"

def jira(method, path, **kw):
    resp = http.request(method, JIRA_URL + path, headers={"Authorization": "Bearer " + credentials.connection("jira", "work")}, **kw)
    resp.raise_for_status()
    return resp.json() if resp.content else None

def count(jql):
    return jira("POST", "/search/approximate-count", json={"jql": jql})["count"]

@on_trigger
def run(event):
    today = date.today()
    expected = min((today - date(today.year, 3 * ((today.month - 1) // 3) + 1, 1)).days / 91, 1)
    lines, behind = [], 0
    for i in monday(ITEMS, board=[BOARD])["boards"][0]["items_page"]["items"]:
        epic = {c["id"]: c["text"] for c in i["column_values"]}.get("epic")
        if not epic:
            continue
        total = count(f'parent = "{epic}"')
        done = count(f'parent = "{epic}" AND statusCategory = Done') / total if total else 0
        flag = done < expected - 0.15
        behind += flag
        lines.append(f"{'⚠️ ' if flag else ''}{i['name']} ({epic}): {done:.0%} done, expected {expected:.0%}")
    notify.email_me(f"Goal health: {behind} behind", "\n".join(lines) or "No goals with linked epics.")
    return {"goals": len(lines), "behind": behind}