Sample code for 30+ languages & platforms
DataFlex Requires Chilkat v11.7.0+

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

DataFlex
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