Visual Basic 6.0 Requires Chilkat v11.7.0+
Visual Basic 6.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
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