Python Requires Chilkat v11.7.0+
Python
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
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))