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

Unicode C
#include <C_CkHttpCurlW.h>
#include <C_CkStringBuilderW.h>
#include <C_CkJsonObjectW.h>
#include <C_CkCsvW.h>

void ChilkatSample(void)
    {
    BOOL success;
    const wchar_t *apiKey;
    HCkHttpCurlW curl;
    HCkStringBuilderW cmd;
    HCkJsonObjectW json;
    int replaced;
    const wchar_t *fromTime;
    const wchar_t *untilTime;
    HCkCsvW ledger;
    int outputRow;
    HCkStringBuilderW pageSuffix;
    BOOL more;
    const wchar_t *cursor;
    int i;
    int count;
    const wchar_t *next;

    success = FALSE;

    //  Requires an unlocked Chilkat bundle. See Global Unlock Sample.
    //  Supply a restricted sandbox key from merchant-controlled configuration.
    apiKey = L"YOUR_STRIPE_TEST_KEY";

    curl = CkHttpCurlW_Create();
    cmd = CkStringBuilderW_Create();
    json = CkJsonObjectW_Create();

    //  Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
    fromTime = L"1790812800";
    untilTime = L"1793491200";

    ledger = CkCsvW_Create();
    CkCsvW_putHasColumnNames(ledger,TRUE);
    outputRow = 0;
    CkCsvW_SetColumnName(ledger,0,L"id");
    CkCsvW_SetColumnName(ledger,1,L"created");
    CkCsvW_SetColumnName(ledger,2,L"source");
    CkCsvW_SetColumnName(ledger,3,L"reporting_category");
    CkCsvW_SetColumnName(ledger,4,L"amount");
    CkCsvW_SetColumnName(ledger,5,L"fee");
    CkCsvW_SetColumnName(ledger,6,L"net");
    CkCsvW_SetColumnName(ledger,7,L"currency");

    pageSuffix = CkStringBuilderW_Create();
    more = TRUE;
    cursor = L"";
    while ((more == TRUE)) {
        //  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"
        CkStringBuilderW_SetString(cmd,L"curl -X GET \"https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\"");
        CkStringBuilderW_Append(cmd,L" -u \"@KEY@:\"");
        CkStringBuilderW_Append(cmd,L" -H \"Stripe-Version: 2026-10-28.endive\"");
        replaced = CkStringBuilderW_Replace(cmd,L"@CURSOR@",CkStringBuilderW_getAsString(pageSuffix));
        replaced = CkStringBuilderW_Replace(cmd,L"@FROM@",fromTime);
        replaced = CkStringBuilderW_Replace(cmd,L"@UNTIL@",untilTime);
        replaced = CkStringBuilderW_Replace(cmd,L"@KEY@",apiKey);
        success = CkHttpCurlW_DoYourThing(curl,CkStringBuilderW_getAsString(cmd));
        if (success != TRUE) {
            wprintf(L"No HTTP response. Chilkat failure code: %d\n",CkHttpCurlW_getFailReason(curl));
            CkHttpCurlW_Dispose(curl);
            CkStringBuilderW_Dispose(cmd);
            CkJsonObjectW_Dispose(json);
            CkCsvW_Dispose(ledger);
            CkStringBuilderW_Dispose(pageSuffix);
            return;
        }

        success = CkHttpCurlW_GetResponseJson(curl,json);
        if ((CkHttpCurlW_getStatusCode(curl) != 200) || (success != TRUE)) {
            wprintf(L"Stripe HTTP %d  Request-Id: %s\n",CkHttpCurlW_getStatusCode(curl),CkHttpCurlW_getResponseHeaderField(curl,L"Request-Id"));
            if (success == TRUE) {
                wprintf(L"%s\n",CkJsonObjectW_stringOf(json,L"error.message"));
            }

            CkHttpCurlW_Dispose(curl);
            CkStringBuilderW_Dispose(cmd);
            CkJsonObjectW_Dispose(json);
            CkCsvW_Dispose(ledger);
            CkStringBuilderW_Dispose(pageSuffix);
            return;
        }

        i = 0;
        count = CkJsonObjectW_SizeOfArray(json,L"data");
        while ((i < count)) {
            CkJsonObjectW_putI(json,i);
            CkCsvW_SetCell(ledger,outputRow,0,CkJsonObjectW_stringOf(json,L"data[i].id"));
            CkCsvW_SetCell(ledger,outputRow,1,CkJsonObjectW_stringOf(json,L"data[i].created"));
            CkCsvW_SetCell(ledger,outputRow,2,CkJsonObjectW_stringOf(json,L"data[i].source"));
            CkCsvW_SetCell(ledger,outputRow,3,CkJsonObjectW_stringOf(json,L"data[i].reporting_category"));
            CkCsvW_SetCell(ledger,outputRow,4,CkJsonObjectW_stringOf(json,L"data[i].amount"));
            CkCsvW_SetCell(ledger,outputRow,5,CkJsonObjectW_stringOf(json,L"data[i].fee"));
            CkCsvW_SetCell(ledger,outputRow,6,CkJsonObjectW_stringOf(json,L"data[i].net"));
            CkCsvW_SetCell(ledger,outputRow,7,CkJsonObjectW_stringOf(json,L"data[i].currency"));
            outputRow = outputRow + 1;
            i = i + 1;
        }

        more = CkJsonObjectW_BoolOf(json,L"has_more");
        if (more == TRUE) {
            next = CkJsonObjectW_stringOf(json,L"data[i].id");
            if ((count < 1) || (next == L"") || (next == cursor)) {
                wprintf(L"Invalid pagination cursor.\n");
                CkHttpCurlW_Dispose(curl);
                CkStringBuilderW_Dispose(cmd);
                CkJsonObjectW_Dispose(json);
                CkCsvW_Dispose(ledger);
                CkStringBuilderW_Dispose(pageSuffix);
                return;
            }

            cursor = next;
            CkStringBuilderW_SetString(pageSuffix,L"&starting_after=");
            CkStringBuilderW_Append(pageSuffix,cursor);
        }

    }

    success = CkCsvW_SaveFile(ledger,L"stripe-balance-transactions.csv");
    if (success == FALSE) {
        wprintf(L"%s\n",CkCsvW_lastErrorText(ledger));
        CkHttpCurlW_Dispose(curl);
        CkStringBuilderW_Dispose(cmd);
        CkJsonObjectW_Dispose(json);
        CkCsvW_Dispose(ledger);
        CkStringBuilderW_Dispose(pageSuffix);
        return;
    }

    wprintf(L"Exported rows: %d\n",outputRow);


    CkHttpCurlW_Dispose(curl);
    CkStringBuilderW_Dispose(cmd);
    CkJsonObjectW_Dispose(json);
    CkCsvW_Dispose(ledger);
    CkStringBuilderW_Dispose(pageSuffix);

    }