Sample code for 30+ languages & platforms
PureBasic 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 PureBasic Downloads

PureBasic
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