See your 10 best posts from last week

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

API = "https://api.sproutsocial.com/v1"

def sprout():
    h = {"Authorization": f"Bearer {credentials.secret('SPROUT_API_TOKEN')}"}
    cid = http.get(f"{API}/metadata/client", headers=h).json()["data"][0]["customer_id"]
    return h, cid

@on_trigger
def run(event):
    h, cid = sprout()
    ids = ",".join(str(p["customer_profile_id"]) for p in http.get(f"{API}/{cid}/metadata/customer", headers=h).json()["data"])
    end = date.today()
    body = {"filters": [f"customer_profile_id.eq({ids})", f"created_time.in({end - timedelta(days=7)}T00:00:00..{end}T00:00:00)"],
            "fields": ["perma_link", "text"], "metrics": ["lifetime.impressions", "lifetime.engagements"], "limit": 100}
    posts = http.post(f"{API}/{cid}/analytics/posts", json=body, headers=h).json()["data"]
    top = sorted(posts, key=lambda p: -(p["metrics"].get("lifetime.engagements") or 0))[:10]
    lines = [f"{i}. {p['metrics'].get('lifetime.engagements', 0):,} eng · {p['metrics'].get('lifetime.impressions', 0):,} impr  "
             f"{(p.get('text') or '')[:60]}\n   {p['perma_link']}" for i, p in enumerate(top, 1)]
    notify.email_me("Top 10 posts last week", "\n".join(lines))
    return {"posts": len(top)}