Get your open work items by email each morning

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

ORG, PROJECT = "acme", "Phoenix"
BASE = f"https://dev.azure.com/{ORG}/{PROJECT}/_apis/wit"

@on_trigger
def run(event):
    token = base64.b64encode(f":{credentials.secret('AZURE_DEVOPS_PAT')}".encode()).decode()
    headers = {"Authorization": f"Basic {token}"}
    wiql = {"query": "SELECT [System.Id] FROM WorkItems WHERE [System.TeamProject] = @project "
                     "AND [System.AssignedTo] = @me AND [System.State] <> 'Closed' ORDER BY [System.ChangedDate] DESC"}
    ids = [w["id"] for w in http.post(f"{BASE}/wiql", params={"api-version": "7.1"}, json=wiql,
                                      headers=headers).json()["workItems"]][:200]
    if not ids:
        notify.email_me("No open work items", "Nothing assigned to you in Phoenix.")
        return {"items": 0}
    items = http.get(f"{BASE}/workitems", headers=headers, params={
        "ids": ",".join(map(str, ids)), "fields": "System.Title,System.State,System.WorkItemType",
        "api-version": "7.1"}).json()["value"]
    lines = [f"#{w['id']} [{w['fields']['System.State']}] {w['fields']['System.WorkItemType']}: "
             f"{w['fields']['System.Title']}" for w in items]
    notify.email_me(f"{len(items)} open work items in {PROJECT}", "\n".join(lines))
    return {"items": len(items)}