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

C
#include <C_CkHttpCurl.h>
#include <C_CkStringBuilder.h>
#include <C_CkJsonObject.h>
#include <C_CkCsv.h>

void ChilkatSample(void)
    {
    BOOL success;
    const char *apiKey;
    HCkHttpCurl curl;
    HCkStringBuilder cmd;
    HCkJsonObject json;
    int replaced;
    const char *fromTime;
    const char *untilTime;
    HCkCsv ledger;
    int outputRow;
    HCkStringBuilder pageSuffix;
    BOOL more;
    const char *cursor;
    int i;
    int count;
    const char *next;

    success = FALSE;

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

    curl = CkHttpCurl_Create();
    cmd = CkStringBuilder_Create();
    json = CkJsonObject_Create();

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

    ledger = CkCsv_Create();
    CkCsv_putHasColumnNames(ledger,TRUE);
    outputRow = 0;
    CkCsv_SetColumnName(ledger,0,"id");
    CkCsv_SetColumnName(ledger,1,"created");
    CkCsv_SetColumnName(ledger,2,"source");
    CkCsv_SetColumnName(ledger,3,"reporting_category");
    CkCsv_SetColumnName(ledger,4,"amount");
    CkCsv_SetColumnName(ledger,5,"fee");
    CkCsv_SetColumnName(ledger,6,"net");
    CkCsv_SetColumnName(ledger,7,"currency");

    pageSuffix = CkStringBuilder_Create();
    more = TRUE;
    cursor = "";
    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"
        CkStringBuilder_SetString(cmd,"curl -X GET \"https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\"");
        CkStringBuilder_Append(cmd," -u \"@KEY@:\"");
        CkStringBuilder_Append(cmd," -H \"Stripe-Version: 2026-10-28.endive\"");
        replaced = CkStringBuilder_Replace(cmd,"@CURSOR@",CkStringBuilder_getAsString(pageSuffix));
        replaced = CkStringBuilder_Replace(cmd,"@FROM@",fromTime);
        replaced = CkStringBuilder_Replace(cmd,"@UNTIL@",untilTime);
        replaced = CkStringBuilder_Replace(cmd,"@KEY@",apiKey);
        success = CkHttpCurl_DoYourThing(curl,CkStringBuilder_getAsString(cmd));
        if (success != TRUE) {
            printf("No HTTP response. Chilkat failure code: %d\n",CkHttpCurl_getFailReason(curl));
            CkHttpCurl_Dispose(curl);
            CkStringBuilder_Dispose(cmd);
            CkJsonObject_Dispose(json);
            CkCsv_Dispose(ledger);
            CkStringBuilder_Dispose(pageSuffix);
            return;
        }

        success = CkHttpCurl_GetResponseJson(curl,json);
        if ((CkHttpCurl_getStatusCode(curl) != 200) || (success != TRUE)) {
            printf("Stripe HTTP %d  Request-Id: %s\n",CkHttpCurl_getStatusCode(curl),CkHttpCurl_getResponseHeaderField(curl,"Request-Id"));
            if (success == TRUE) {
                printf("%s\n",CkJsonObject_stringOf(json,"error.message"));
            }

            CkHttpCurl_Dispose(curl);
            CkStringBuilder_Dispose(cmd);
            CkJsonObject_Dispose(json);
            CkCsv_Dispose(ledger);
            CkStringBuilder_Dispose(pageSuffix);
            return;
        }

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

        more = CkJsonObject_BoolOf(json,"has_more");
        if (more == TRUE) {
            next = CkJsonObject_stringOf(json,"data[i].id");
            if ((count < 1) || (next == "") || (next == cursor)) {
                printf("Invalid pagination cursor.\n");
                CkHttpCurl_Dispose(curl);
                CkStringBuilder_Dispose(cmd);
                CkJsonObject_Dispose(json);
                CkCsv_Dispose(ledger);
                CkStringBuilder_Dispose(pageSuffix);
                return;
            }

            cursor = next;
            CkStringBuilder_SetString(pageSuffix,"&starting_after=");
            CkStringBuilder_Append(pageSuffix,cursor);
        }

    }

    success = CkCsv_SaveFile(ledger,"stripe-balance-transactions.csv");
    if (success == FALSE) {
        printf("%s\n",CkCsv_lastErrorText(ledger));
        CkHttpCurl_Dispose(curl);
        CkStringBuilder_Dispose(cmd);
        CkJsonObject_Dispose(json);
        CkCsv_Dispose(ledger);
        CkStringBuilder_Dispose(pageSuffix);
        return;
    }

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


    CkHttpCurl_Dispose(curl);
    CkStringBuilder_Dispose(cmd);
    CkJsonObject_Dispose(json);
    CkCsv_Dispose(ledger);
    CkStringBuilder_Dispose(pageSuffix);

    }