Get a Slack list of Chargebee trials ending soon

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

SITE = "yourcompany"  # yourcompany.chargebee.com
DAYS = 3

@on_trigger
def run(event):
    api, auth = f"https://{SITE}.chargebee.com/api/v2", (credentials.secret("CHARGEBEE_API_KEY"), "")
    params = {"status[is]": "in_trial", "trial_end[before]": int(time.time()) + DAYS * 86400,
              "sort_by[asc]": "updated_at", "limit": 100}
    rows = http.get(f"{api}/subscriptions", auth=auth, params=params).json()["list"]
    if not rows:
        return {"ending": 0}
    lines = []
    for r in sorted(rows, key=lambda r: (r["customer"].get("payment_method") is not None, r["subscription"]["trial_end"])):
        c, s = r["customer"], r["subscription"]
        name = c.get("company") or f"{c.get('first_name', '')} {c.get('last_name', '')}".strip() or c.get("email", c["id"])
        card = c.get("payment_method") is not None
        when = datetime.fromtimestamp(s["trial_end"]).strftime("%a %d %b")
        lines.append(f"{'✅' if card else '⚠️'} {name} ({c.get('email', '')}) · {s['subscription_items'][0]['item_price_id']} "
                     f"· ends {when} · {'card on file' if card else 'no card'}")
    notify.slack(f"⏳ {len(rows)} Chargebee trials end in the next {DAYS} days\n" + "\n".join(lines), channel="#sales")
    return {"ending": len(rows)}