PureBasic Requires Chilkat v11.7.0+
PureBasic
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 PureBasic Downloads
IncludeFile "CkCsv.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkJsonObject.pb"
IncludeFile "CkHttpCurl.pb"
Procedure ChilkatExample()
success.i = 0
; Requires an unlocked Chilkat bundle. See Global Unlock Sample.
; Supply a restricted sandbox key from merchant-controlled configuration.
apiKey.s = "YOUR_STRIPE_TEST_KEY"
curl.i = CkHttpCurl::ckCreate()
If curl.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
cmd.i = CkStringBuilder::ckCreate()
If cmd.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
json.i = CkJsonObject::ckCreate()
If json.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
replaced.i
; Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
fromTime.s = "1790812800"
untilTime.s = "1793491200"
ledger.i = CkCsv::ckCreate()
If ledger.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkCsv::setCkHasColumnNames(ledger, 1)
outputRow.i = 0
CkCsv::ckSetColumnName(ledger,0,"id")
CkCsv::ckSetColumnName(ledger,1,"created")
CkCsv::ckSetColumnName(ledger,2,"source")
CkCsv::ckSetColumnName(ledger,3,"reporting_category")
CkCsv::ckSetColumnName(ledger,4,"amount")
CkCsv::ckSetColumnName(ledger,5,"fee")
CkCsv::ckSetColumnName(ledger,6,"net")
CkCsv::ckSetColumnName(ledger,7,"currency")
pageSuffix.i = CkStringBuilder::ckCreate()
If pageSuffix.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
more.i = 1
cursor.s = ""
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"
CkStringBuilder::ckSetString(cmd,"curl -X GET " + Chr(34) + "https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@" + Chr(34))
CkStringBuilder::ckAppend(cmd," -u " + Chr(34) + "@KEY@:" + Chr(34))
CkStringBuilder::ckAppend(cmd," -H " + Chr(34) + "Stripe-Version: 2026-10-28.endive" + Chr(34))
replaced = CkStringBuilder::ckReplace(cmd,"@CURSOR@",CkStringBuilder::ckGetAsString(pageSuffix))
replaced = CkStringBuilder::ckReplace(cmd,"@FROM@",fromTime)
replaced = CkStringBuilder::ckReplace(cmd,"@UNTIL@",untilTime)
replaced = CkStringBuilder::ckReplace(cmd,"@KEY@",apiKey)
success = CkHttpCurl::ckDoYourThing(curl,CkStringBuilder::ckGetAsString(cmd))
If success <> 1
Debug "No HTTP response. Chilkat failure code: " + Str(CkHttpCurl::ckFailReason(curl))
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkCsv::ckDispose(ledger)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
success = CkHttpCurl::ckGetResponseJson(curl,json)
If (CkHttpCurl::ckStatusCode(curl) <> 200) OR (success <> 1)
Debug "Stripe HTTP " + Str(CkHttpCurl::ckStatusCode(curl)) + " Request-Id: " + CkHttpCurl::ckGetResponseHeaderField(curl,"Request-Id")
If success = 1
Debug CkJsonObject::ckStringOf(json,"error.message")
EndIf
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkCsv::ckDispose(ledger)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
i.i = 0
count.i = CkJsonObject::ckSizeOfArray(json,"data")
While (i < count)
CkJsonObject::setCkI(json, i)
CkCsv::ckSetCell(ledger,outputRow,0,CkJsonObject::ckStringOf(json,"data[i].id"))
CkCsv::ckSetCell(ledger,outputRow,1,CkJsonObject::ckStringOf(json,"data[i].created"))
CkCsv::ckSetCell(ledger,outputRow,2,CkJsonObject::ckStringOf(json,"data[i].source"))
CkCsv::ckSetCell(ledger,outputRow,3,CkJsonObject::ckStringOf(json,"data[i].reporting_category"))
CkCsv::ckSetCell(ledger,outputRow,4,CkJsonObject::ckStringOf(json,"data[i].amount"))
CkCsv::ckSetCell(ledger,outputRow,5,CkJsonObject::ckStringOf(json,"data[i].fee"))
CkCsv::ckSetCell(ledger,outputRow,6,CkJsonObject::ckStringOf(json,"data[i].net"))
CkCsv::ckSetCell(ledger,outputRow,7,CkJsonObject::ckStringOf(json,"data[i].currency"))
outputRow = outputRow + 1
i = i + 1
Wend
more = CkJsonObject::ckBoolOf(json,"has_more")
If more = 1
next.s = CkJsonObject::ckStringOf(json,"data[i].id")
If (count < 1) OR (next = "") OR (next = cursor)
Debug "Invalid pagination cursor."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkCsv::ckDispose(ledger)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
cursor = next
CkStringBuilder::ckSetString(pageSuffix,"&starting_after=")
CkStringBuilder::ckAppend(pageSuffix,cursor)
EndIf
Wend
success = CkCsv::ckSaveFile(ledger,"stripe-balance-transactions.csv")
If success = 0
Debug CkCsv::ckLastErrorText(ledger)
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkCsv::ckDispose(ledger)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
Debug "Exported rows: " + Str(outputRow)
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkCsv::ckDispose(ledger)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndProcedure