DataFlex Requires Chilkat v11.7.0+
DataFlex
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 DataFlex Downloads
Use ChilkatAx-win32.pkg
Procedure Test
Boolean iSuccess
String sApiKey
Handle hoCurl
Handle hoCmd
Variant vJson
Handle hoJson
Integer iReplaced
String sFromTime
String sUntilTime
String sSelectedPayout
String sExpectedAmount
String sCurrency
Handle hoPageSuffix
Boolean iMore
String sCursor
Integer i
Integer iCount
String sNext
Integer iTotalNet
Handle hoNumber
Txn Handle hoPageSuffixTxn
Boolean iMoreTxn
String sCursorTxn
Integer iITxn
Integer iCountTxn
String sNetText
Integer iEntryNet
String sNextTxn
String sTemp1
String sTemp2
String sTemp3
String sTemp4
Integer iTemp1
Boolean bTemp1
Move False To iSuccess
// Requires an unlocked Chilkat bundle. See Global Unlock Sample.
// Supply a restricted sandbox key from merchant-controlled configuration.
Move "YOUR_STRIPE_TEST_KEY" To sApiKey
Get Create (RefClass(cComChilkatHttpCurl)) To hoCurl
If (Not(IsComObjectCreated(hoCurl))) Begin
Send CreateComObject of hoCurl
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoCmd
If (Not(IsComObjectCreated(hoCmd))) Begin
Send CreateComObject of hoCmd
End
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
// Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
Move "1790812800" To sFromTime
Move "1793491200" To sUntilTime
Move "po_SELECTED_BANK_DEPOSIT" To sSelectedPayout
Move "" To sExpectedAmount
Move "" To sCurrency
Get Create (RefClass(cComChilkatStringBuilder)) To hoPageSuffix
If (Not(IsComObjectCreated(hoPageSuffix))) Begin
Send CreateComObject of hoPageSuffix
End
Move True To iMore
Move "" To sCursor
While (iMore = True)
// 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"
Get ComSetString Of hoCmd 'curl -X GET "https://api.stripe.com/v1/payouts?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@"' To iSuccess
Get ComAppend Of hoCmd ' -u "@KEY@:"' To iSuccess
Get ComAppend Of hoCmd ' -H "Stripe-Version: 2026-10-28.endive"' To iSuccess
Get ComGetAsString Of hoPageSuffix To sTemp1
Get ComReplace Of hoCmd "@CURSOR@" sTemp1 To iReplaced
Get ComReplace Of hoCmd "@FROM@" sFromTime To iReplaced
Get ComReplace Of hoCmd "@UNTIL@" sUntilTime To iReplaced
Get ComReplace Of hoCmd "@KEY@" sApiKey To iReplaced
Get ComGetAsString Of hoCmd To sTemp1
Get ComDoYourThing Of hoCurl sTemp1 To iSuccess
If (iSuccess <> True) Begin
Get ComFailReason Of hoCurl To iTemp1
Showln "No HTTP response. Chilkat failure code: " iTemp1
Procedure_Return
End
Get pvComObject of hoJson to vJson
Get ComGetResponseJson Of hoCurl vJson To iSuccess
Get ComStatusCode Of hoCurl To iTemp1
If ((iTemp1 <> 200) Or (iSuccess <> True)) Begin
Get ComStatusCode Of hoCurl To iTemp1
Get ComGetResponseHeaderField Of hoCurl "Request-Id" To sTemp1
Showln "Stripe HTTP " iTemp1 " Request-Id: " sTemp1
If (iSuccess = True) Begin
Get ComStringOf Of hoJson "error.message" To sTemp1
Showln sTemp1
End
Procedure_Return
End
Move 0 To i
Get ComSizeOfArray Of hoJson "data" To iCount
While (i < iCount)
Set ComI Of hoJson To i
Get ComStringOf Of hoJson "data[i].id" To sTemp1
Get ComStringOf Of hoJson "data[i].amount" To sTemp2
Get ComStringOf Of hoJson "data[i].currency" To sTemp3
Get ComStringOf Of hoJson "data[i].reconciliation_status" To sTemp4
Showln sTemp1 " | " sTemp2 " | " sTemp3 " | " sTemp4
Get ComStringOf Of hoJson "data[i].id" To sTemp1
If (sTemp1 = sSelectedPayout) Begin
Get ComBoolOf Of hoJson "data[i].automatic" To bTemp1
Get ComStringOf Of hoJson "data[i].reconciliation_status" To sTemp1
If ((bTemp1 <> True) Or (sTemp1 <> "completed")) Begin
Showln "Select an automatic payout with completed reconciliation."
Procedure_Return
End
Get ComStringOf Of hoJson "data[i].amount" To sExpectedAmount
Get ComStringOf Of hoJson "data[i].currency" To sCurrency
End
Move (i + 1) To i
Loop
Get ComBoolOf Of hoJson "has_more" To iMore
If (iMore = True) Begin
Get ComStringOf Of hoJson "data[i].id" To sNext
If ((iCount < 1) Or (sNext = "") Or (sNext = sCursor)) Begin
Showln "Invalid pagination cursor."
Procedure_Return
End
Move sNext To sCursor
Get ComSetString Of hoPageSuffix "&starting_after=" To iSuccess
Get ComAppend Of hoPageSuffix sCursor To iSuccess
End
Loop
If (sExpectedAmount = "") Begin
Showln "The selected payout was not in this date range."
Procedure_Return
End
Move 0 To iTotalNet
// 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.
Get Create (RefClass(cComChilkatStringBuilder)) To hoNumber
If (Not(IsComObjectCreated(hoNumber))) Begin
Send CreateComObject of hoNumber
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoPageSuffixTxn
If (Not(IsComObjectCreated(hoPageSuffixTxn))) Begin
Send CreateComObject of hoPageSuffixTxn
End
Move True To iMoreTxn
Move "" To sCursorTxn
While (iMoreTxn = True)
// 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"
Get ComSetString Of hoCmd 'curl -X GET "https://api.stripe.com/v1/balance_transactions?payout=@PAYOUT@&limit=100@CURSOR@"' To iSuccess
Get ComAppend Of hoCmd ' -u "@KEY@:"' To iSuccess
Get ComAppend Of hoCmd ' -H "Stripe-Version: 2026-10-28.endive"' To iSuccess
Get ComGetAsString Of hoPageSuffixTxn To sTemp1
Get ComReplace Of hoCmd "@CURSOR@" sTemp1 To iReplaced
Get ComReplace Of hoCmd "@PAYOUT@" sSelectedPayout To iReplaced
Get ComReplace Of hoCmd "@KEY@" sApiKey To iReplaced
Get ComGetAsString Of hoCmd To sTemp1
Get ComDoYourThing Of hoCurl sTemp1 To iSuccess
If (iSuccess <> True) Begin
Get ComFailReason Of hoCurl To iTemp1
Showln "No HTTP response. Chilkat failure code: " iTemp1
Procedure_Return
End
Get pvComObject of hoJson to vJson
Get ComGetResponseJson Of hoCurl vJson To iSuccess
Get ComStatusCode Of hoCurl To iTemp1
If ((iTemp1 <> 200) Or (iSuccess <> True)) Begin
Get ComStatusCode Of hoCurl To iTemp1
Get ComGetResponseHeaderField Of hoCurl "Request-Id" To sTemp1
Showln "Stripe HTTP " iTemp1 " Request-Id: " sTemp1
If (iSuccess = True) Begin
Get ComStringOf Of hoJson "error.message" To sTemp1
Showln sTemp1
End
Procedure_Return
End
Move 0 To iITxn
Get ComSizeOfArray Of hoJson "data" To iCountTxn
While (iITxn < iCountTxn)
Set ComI Of hoJson To iITxn
Get ComStringOf Of hoJson "data[i].id" To sTemp1
Get ComStringOf Of hoJson "data[i].net" To sTemp2
Showln sTemp1 " " sTemp2
Get ComStringOf Of hoJson "data[i].currency" To sTemp1
If (sTemp1 <> sCurrency) Begin
Showln "Currency mismatch."
Procedure_Return
End
// Exclude the bank withdrawal itself if it appears in this batch.
Get ComStringOf Of hoJson "data[i].source" To sTemp1
If (sTemp1 <> sSelectedPayout) Begin
Get ComStringOf Of hoJson "data[i].net" To sNetText
Get ComIntOf Of hoJson "data[i].net" To iEntryNet
Set ComIntValue Of hoNumber To iEntryNet
Get ComGetAsString Of hoNumber To sTemp1
If (sTemp1 <> sNetText) Begin
Showln "Entry exceeds the supported int range: " sNetText
Procedure_Return
End
If (iEntryNet > 0) Begin
If (iTotalNet > (2147483647 - iEntryNet)) Begin
Showln "Total exceeds the supported int range."
Procedure_Return
End
End
If (iEntryNet < 0) Begin
If (iTotalNet < ((0 - 2147483647) - (iEntryNet + 1))) Begin
Showln "Total exceeds the supported int range."
Procedure_Return
End
End
Move (iTotalNet + iEntryNet) To iTotalNet
End
Move (iITxn + 1) To iITxn
Loop
Get ComBoolOf Of hoJson "has_more" To iMoreTxn
If (iMoreTxn = True) Begin
Get ComStringOf Of hoJson "data[i].id" To sNextTxn
If ((iCountTxn < 1) Or (sNextTxn = "") Or (sNextTxn = sCursorTxn)) Begin
Showln "Invalid pagination cursor."
Procedure_Return
End
Move sNextTxn To sCursorTxn
Get ComSetString Of hoPageSuffixTxn "&starting_after=" To iSuccess
Get ComAppend Of hoPageSuffixTxn sCursorTxn To iSuccess
End
Loop
Set ComIntValue Of hoNumber To iTotalNet
Showln "Settlement net: " iTotalNet " Bank payout: " sExpectedAmount " " sCurrency
Get ComGetAsString Of hoNumber To sTemp1
If (sTemp1 = sExpectedAmount) Begin
Showln "Payout reconciled."
End
Else Begin
Showln "Investigate the difference."
End
End_Procedure