Sample code for 30+ languages & platforms
Python Requires Chilkat v11.7.0+

Stripe: Export a period of account activity

See more Stripe Examples

Export account activity for a UTC date range to CSV, including transaction references, fees, net amounts, and currencies.

Stripe documentation and cURL example

Chilkat Python Downloads

Python
import sys
import chilkat2

success = False

# Requires an unlocked Chilkat bundle. See Global Unlock Sample.
# Supply a restricted sandbox key from merchant-controlled configuration.
apiKey = "YOUR_STRIPE_TEST_KEY"

curl = chilkat2.HttpCurl()
cmd = chilkat2.StringBuilder()
json = chilkat2.JsonObject()

# Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
fromTime = "1790812800"
untilTime = "1793491200"

ledger = chilkat2.Csv()
ledger.HasColumnNames = True
outputRow = 0
ledger.SetColumnName(0,"id")
ledger.SetColumnName(1,"created")
ledger.SetColumnName(2,"source")
ledger.SetColumnName(3,"reporting_category")
ledger.SetColumnName(4,"amount")
ledger.SetColumnName(5,"fee")
ledger.SetColumnName(6,"net")
ledger.SetColumnName(7,"currency")

pageSuffix = chilkat2.StringBuilder()
more = True
cursor = ""
while (more == True) :
    # curl -X GET "https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D={fromTime}&created%5Blt%5D={untilTime}&limit=100" \
    #   -u "$STRIPE_API_KEY:" \
    #   -H "Stripe-Version: 2026-10-28.endive"
    cmd.SetString("curl -X GET \"https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\"")
    cmd.Append(" -u \"@KEY@:\"")
    cmd.Append(" -H \"Stripe-Version: 2026-10-28.endive\"")
    replaced = cmd.Replace("@CURSOR@",pageSuffix.GetAsString())
    replaced = cmd.Replace("@FROM@",fromTime)
    replaced = cmd.Replace("@UNTIL@",untilTime)
    replaced = cmd.Replace("@KEY@",apiKey)
    success = curl.DoYourThing(cmd.GetAsString())
    if (success != True):
        print("No HTTP response. Chilkat failure code: " + str(curl.FailReason))
        sys.exit()

    success = curl.GetResponseJson(json)
    if ((curl.StatusCode != 200) or (success != True)):
        print("Stripe HTTP " + str(curl.StatusCode) + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"))
        if (success == True):
            print(json.StringOf("error.message"))

        sys.exit()

    i = 0
    count = json.SizeOfArray("data")
    while (i < count) :
        json.I = i
        ledger.SetCell(outputRow,0,json.StringOf("data[i].id"))
        ledger.SetCell(outputRow,1,json.StringOf("data[i].created"))
        ledger.SetCell(outputRow,2,json.StringOf("data[i].source"))
        ledger.SetCell(outputRow,3,json.StringOf("data[i].reporting_category"))
        ledger.SetCell(outputRow,4,json.StringOf("data[i].amount"))
        ledger.SetCell(outputRow,5,json.StringOf("data[i].fee"))
        ledger.SetCell(outputRow,6,json.StringOf("data[i].net"))
        ledger.SetCell(outputRow,7,json.StringOf("data[i].currency"))
        outputRow = outputRow + 1
        i = i + 1

    more = json.BoolOf("has_more")
    if (more == True):
        next = json.StringOf("data[i].id")
        if ((count < 1) or (next == "") or (next == cursor)):
            print("Invalid pagination cursor.")
            sys.exit()

        cursor = next
        pageSuffix.SetString("&starting_after=")
        pageSuffix.Append(cursor)

success = ledger.SaveFile("stripe-balance-transactions.csv")
if (success == False):
    print(ledger.LastErrorText)
    sys.exit()

print("Exported rows: " + str(outputRow))