Sample code for 30+ languages & platforms
Xojo Plugin 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 Xojo Plugin Downloads

Xojo Plugin
Dim success As Boolean
success = False

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

Dim curl As New Chilkat.HttpCurl
Dim cmd As New Chilkat.StringBuilder
Dim json As New Chilkat.JsonObject

Dim replaced As Int32

//  Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
Dim fromTime As String
fromTime = "1790812800"
Dim untilTime As String
untilTime = "1793491200"

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

Dim pageSuffix As New Chilkat.StringBuilder
Dim more As Boolean
more = True
Dim cursor As String
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"
    success = cmd.SetString("curl -X GET ""https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@""")
    success = cmd.Append(" -u ""@KEY@:""")
    success = 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) Then
        System.DebugLog("No HTTP response. Chilkat failure code: " + Str(curl.FailReason))
        Return
    End If

    success = curl.GetResponseJson(json)
    If ((curl.StatusCode <> 200) Or (success <> True)) Then
        System.DebugLog("Stripe HTTP " + Str(curl.StatusCode) + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"))
        If (success = True) Then
            System.DebugLog(json.StringOf("error.message"))
        End If

        Return
    End If

    Dim i As Int32
    i = 0
    Dim count As Int32
    count = json.SizeOfArray("data")
    While (i < count)
        json.I = i
        success = ledger.SetCell(outputRow,0,json.StringOf("data[i].id"))
        success = ledger.SetCell(outputRow,1,json.StringOf("data[i].created"))
        success = ledger.SetCell(outputRow,2,json.StringOf("data[i].source"))
        success = ledger.SetCell(outputRow,3,json.StringOf("data[i].reporting_category"))
        success = ledger.SetCell(outputRow,4,json.StringOf("data[i].amount"))
        success = ledger.SetCell(outputRow,5,json.StringOf("data[i].fee"))
        success = ledger.SetCell(outputRow,6,json.StringOf("data[i].net"))
        success = ledger.SetCell(outputRow,7,json.StringOf("data[i].currency"))
        outputRow = outputRow + 1
        i = i + 1
    Wend
    more = json.BoolOf("has_more")
    If (more = True) Then
        Dim next As String
        next = json.StringOf("data[i].id")
        If ((count < 1) Or (next = "") Or (next = cursor)) Then
            System.DebugLog("Invalid pagination cursor.")
            Return
        End If

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

Wend

success = ledger.SaveFile("stripe-balance-transactions.csv")
If (success = False) Then
    System.DebugLog(ledger.LastErrorText)
    Return
End If

System.DebugLog("Exported rows: " + Str(outputRow))