Save a weekly trend report to SharePoint

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

SITE_ID = "contoso.sharepoint.com,1111-aaaa,2222-bbbb"  # Marketing site
SUBS = ["projectmanagement", "agile"]

@on_trigger
def run(event):
    posts = []
    for sub in SUBS:
        listing = http.get(f"https://www.reddit.com/r/{sub}/top.json", params={"t": "week", "limit": 15},
                           headers={"User-Agent": "clickruntime-trend-report/1.0"}).json()
        posts += [f"[r/{sub}] {p['data']['title']} ({p['data']['score']} pts): {p['data']['selftext'][:300]}"
                  for p in listing["data"]["children"]]
    report = ai.generate("\n".join(posts), max_output_tokens=1200,
                         system="Write a one-page Markdown report on the main trends in these posts: a short intro, "
                                "4-6 trends with a line of evidence each, and what it means for a marketing team.").text
    name = f"PM-trends-{date.today()}.md"
    resp = http.put(f"https://graph.microsoft.com/v1.0/sites/{SITE_ID}/drive/root:/Research/{name}:/content",
                    headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}",
                             "Content-Type": "text/markdown"}, data=report.encode())
    resp.raise_for_status()
    return {"file": resp.json()["webUrl"]}