Sample code for 30+ languages & platforms
Visual Basic 6.0 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 Visual Basic 6.0 Downloads

Visual Basic 6.0
Dim success As Long
success = 0

'  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 ChilkatHttpCurl
Dim cmd As New ChilkatStringBuilder
Dim json As New ChilkatJsonObject

Dim replaced As Long

'  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 ChilkatCsv
ledger.HasColumnNames = 1
Dim outputRow As Long
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 ChilkatStringBuilder
Dim more As Long
more = 1
Dim cursor As String
cursor = ""
Do While (more = 1)
    '  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 <> 1) Then
        Debug.Print "No HTTP response. Chilkat failure code: " & curl.FailReason
        Exit Sub
    End If

    success = curl.GetResponseJson(json)
    If ((curl.StatusCode <> 200) Or (success <> 1)) Then
        Debug.Print "Stripe HTTP " & curl.StatusCode & "  Request-Id: " & curl.GetResponseHeaderField("Request-Id")
        If (success = 1) Then
            Debug.Print json.StringOf("error.message")
        End If

        Exit Sub
    End If

    Dim i As Long
    i = 0
    Dim count As Long
    count = json.SizeOfArray("data")
    Do 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
    Loop
    more = json.BoolOf("has_more")
    If (more = 1) Then
        Dim next As String
        next = json.StringOf("data[i].id")
        If ((count < 1) Or (next = "") Or (next = cursor)) Then
            Debug.Print "Invalid pagination cursor."
            Exit Sub
        End If

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

Loop

success = ledger.SaveFile("stripe-balance-transactions.csv")
If (success = 0) Then
    Debug.Print ledger.LastErrorText
    Exit Sub
End If

Debug.Print "Exported rows: " & outputRow