Get a monthly CSV of all your posts

import csv, io
from clickruntime import on_trigger, credentials, http, notify

SITE = "https://blog.example.com"

def wp(method, path, **kw):
    resp = http.request(method, f"{SITE}/wp-json/wp/v2/{path}", **kw,
                        auth=("admin", credentials.secret("WP_APP_PASSWORD")))
    resp.raise_for_status()
    return resp.json()

@on_trigger
def run(event):
    cats = {c["id"]: c["name"] for c in wp("GET", "categories", params={"per_page": 100})}
    out = io.StringIO()
    writer = csv.writer(out)
    writer.writerow(["title", "url", "status", "date", "categories"])
    page, total = 1, 0
    while True:
        resp = http.get(f"{SITE}/wp-json/wp/v2/posts", auth=("admin", credentials.secret("WP_APP_PASSWORD")),
                        params={"per_page": 100, "page": page, "status": "any", "context": "edit"})
        resp.raise_for_status()
        for p in resp.json():
            writer.writerow([p["title"]["raw"], p["link"], p["status"], p["date"][:10],
                             "; ".join(cats.get(c, "") for c in p["categories"])])
            total += 1
        if page >= int(resp.headers.get("X-WP-TotalPages", 1)):
            break
        page += 1
    notify.email_me(f"WordPress posts export ({total} posts)", out.getvalue())
    return {"posts": total}