stripe subscriber data

stripe-subs.sh

#!/bin/sh

# bash script for exporting subscriber data from stripe, using the stripe cli:
# https://docs.stripe.com/stripe-cli
# make sure you sign in first:
# https://docs.stripe.com/stripe-cli/install#login-account

echo "id,name,shipping.name,shipping.address.city,shipping.address.country,shipping.address.line1,shipping.address.line2,shipping.address.postal_code,shipping.address.state,subscriptions.count,subscriptions.status,subscriptions.plan.product"

STARTING_AFTER=""
while :; do
    if [ -z "$STARTING_AFTER" ]; then
        RESPONSE=$(stripe customers list --live --expand "data.subscriptions" --limit 100)
    else
        RESPONSE=$(stripe customers list --live --expand "data.subscriptions" --limit 100 --starting-after "$STARTING_AFTER")
    fi

    echo $RESPONSE | \
        jq -r '.data[] | [.id, .name, .shipping.name, .shipping.address.city, .shipping.address.country, .shipping.address.line1, .shipping.address.line2, .shipping.address.postal_code, .shipping.address.state, (.subscriptions.data | length), .subscriptions.data[0].status, .subscriptions.data[0].plan.product] | @csv'

    HAS_MORE=$(echo "$RESPONSE" | jq -r '.has_more')

    if [ "$HAS_MORE" != "true" ]; then
        break
    fi

    STARTING_AFTER=$(echo $RESPONSE | jq -r ".data[-1].id")    
done