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

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

PureBasic
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