Get a weekly timesheet from Jira worklogs

from collections import defaultdict
from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, credentials, http, notify

JIRA = "https://api.atlassian.com/ex/jira/your-cloud-id"

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

def search(jql, fields, limit=100):
    return jira("POST", "/rest/api/3/search/jql", json={"jql": jql, "fields": fields, "maxResults": limit})["issues"]


@on_trigger
def run(event):
    since = datetime.now(timezone.utc) - timedelta(days=7)
    issues = search("worklogDate >= -7d", ["summary"], 200)
    by_person, by_issue = defaultdict(float), defaultdict(float)
    for i in issues:
        logs = jira("GET", f"/rest/api/3/issue/{i['key']}/worklog",
                    params={"startedAfter": int(since.timestamp() * 1000)})["worklogs"]
        for w in logs:
            hours = w["timeSpentSeconds"] / 3600
            by_person[w["author"]["displayName"]] += hours
            by_issue[f"{i['key']} {i['fields']['summary']}"] += hours
    table = "Per person\n" + "\n".join(f"  {h:6.1f}h  {p}" for p, h in sorted(by_person.items(), key=lambda x: -x[1]))
    table += "\n\nPer issue\n" + "\n".join(f"  {h:6.1f}h  {k}" for k, h in sorted(by_issue.items(), key=lambda x: -x[1]))
    notify.email_me(f"Jira time logged last week: {sum(by_person.values()):.1f}h", table)
    return {"hours": round(sum(by_person.values()), 1)}