PureBasic Requires Chilkat v11.7.0+
PureBasic
Stripe: Match an automatic bank payout to its transactions
See more Stripe Examples
Reconcile a selected automatic payout by comparing its amount with the sum of its settlement entries across all result pages.
Stripe documentation and cURL example
Chilkat PureBasic Downloads
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"
selectedPayout.s = "po_SELECTED_BANK_DEPOSIT"
expectedAmount.s = ""
currency.s = ""
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/payouts?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/payouts?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)
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)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
i.i = 0
count.i = CkJsonObject::ckSizeOfArray(json,"data")
While (i < count)
CkJsonObject::setCkI(json, i)
Debug CkJsonObject::ckStringOf(json,"data[i].id") + " | " + CkJsonObject::ckStringOf(json,"data[i].amount") + " | " + CkJsonObject::ckStringOf(json,"data[i].currency") + " | " + CkJsonObject::ckStringOf(json,"data[i].reconciliation_status")
If CkJsonObject::ckStringOf(json,"data[i].id") = selectedPayout
If (CkJsonObject::ckBoolOf(json,"data[i].automatic") <> 1) OR (CkJsonObject::ckStringOf(json,"data[i].reconciliation_status") <> "completed")
Debug "Select an automatic payout with completed reconciliation."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
expectedAmount = CkJsonObject::ckStringOf(json,"data[i].amount")
currency = CkJsonObject::ckStringOf(json,"data[i].currency")
EndIf
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)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
cursor = next
CkStringBuilder::ckSetString(pageSuffix,"&starting_after=")
CkStringBuilder::ckAppend(pageSuffix,cursor)
EndIf
Wend
If expectedAmount = ""
Debug "The selected payout was not in this date range."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
ProcedureReturn
EndIf
totalNet.i = 0
; This portable example uses int for arithmetic. Reject an out-of-range entry
; or sum before adding. A larger ledger can sum the exact strings using decimal arithmetic.
number.i = CkStringBuilder::ckCreate()
If number.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
pageSuffixTxn.i = CkStringBuilder::ckCreate()
If pageSuffixTxn.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
moreTxn.i = 1
cursorTxn.s = ""
While (moreTxn = 1)
; curl -X GET "https://api.stripe.com/v1/balance_transactions?payout={selectedPayout}&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?payout=@PAYOUT@&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(pageSuffixTxn))
replaced = CkStringBuilder::ckReplace(cmd,"@PAYOUT@",selectedPayout)
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)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
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)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndIf
iTxn.i = 0
countTxn.i = CkJsonObject::ckSizeOfArray(json,"data")
While (iTxn < countTxn)
CkJsonObject::setCkI(json, iTxn)
Debug CkJsonObject::ckStringOf(json,"data[i].id") + " " + CkJsonObject::ckStringOf(json,"data[i].net")
If CkJsonObject::ckStringOf(json,"data[i].currency") <> currency
Debug "Currency mismatch."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndIf
; Exclude the bank withdrawal itself if it appears in this batch.
If CkJsonObject::ckStringOf(json,"data[i].source") <> selectedPayout
netText.s = CkJsonObject::ckStringOf(json,"data[i].net")
entryNet.i = CkJsonObject::ckIntOf(json,"data[i].net")
CkStringBuilder::setCkIntValue(number, entryNet)
If CkStringBuilder::ckGetAsString(number) <> netText
Debug "Entry exceeds the supported int range: " + netText
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndIf
If entryNet > 0
If totalNet > (2147483647 - entryNet)
Debug "Total exceeds the supported int range."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndIf
EndIf
If entryNet < 0
If totalNet < ((0 - 2147483647) - (entryNet + 1))
Debug "Total exceeds the supported int range."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndIf
EndIf
totalNet = totalNet + entryNet
EndIf
iTxn = iTxn + 1
Wend
moreTxn = CkJsonObject::ckBoolOf(json,"has_more")
If moreTxn = 1
nextTxn.s = CkJsonObject::ckStringOf(json,"data[i].id")
If (countTxn < 1) OR (nextTxn = "") OR (nextTxn = cursorTxn)
Debug "Invalid pagination cursor."
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndIf
cursorTxn = nextTxn
CkStringBuilder::ckSetString(pageSuffixTxn,"&starting_after=")
CkStringBuilder::ckAppend(pageSuffixTxn,cursorTxn)
EndIf
Wend
CkStringBuilder::setCkIntValue(number, totalNet)
Debug "Settlement net: " + Str(totalNet) + " Bank payout: " + expectedAmount + " " + currency
If CkStringBuilder::ckGetAsString(number) = expectedAmount
Debug "Payout reconciled."
Else
Debug "Investigate the difference."
EndIf
CkHttpCurl::ckDispose(curl)
CkStringBuilder::ckDispose(cmd)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(pageSuffix)
CkStringBuilder::ckDispose(number)
CkStringBuilder::ckDispose(pageSuffixTxn)
ProcedureReturn
EndProcedure