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

Note
This example is intended for running within a Chilkat.Js embedded JavaScript engine. All Chilkat JavaScript examples require Chilkat v11.4.0 or greater.
JavaScript
var success = false;

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

var curl = new CkHttpCurl();
var cmd = new CkStringBuilder();
var json = new CkJsonObject();

var replaced;

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

var ledger = new CkCsv();
ledger.HasColumnNames = true;
var outputRow = 0;
ledger.SetColumnName(0,"id");
ledger.SetColumnName(1,"created");
ledger.SetColumnName(2,"source");
ledger.SetColumnName(3,"reporting_category");
ledger.SetColumnName(4,"amount");
ledger.SetColumnName(5,"fee");
ledger.SetColumnName(6,"net");
ledger.SetColumnName(7,"currency");

var pageSuffix = new CkStringBuilder();
var more = true;
var 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"
    cmd.SetString("curl -X GET \"https://api.stripe.com/v1/balance_transactions?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\"");
    cmd.Append(" -u \"@KEY@:\"");
    cmd.Append(" -H \"Stripe-Version: 2026-10-28.endive\"");
    replaced = cmd.Replace("@CURSOR@",pageSuffix.GetAsString());
    replaced = cmd.Replace("@FROM@",fromTime);
    replaced = cmd.Replace("@UNTIL@",untilTime);
    replaced = cmd.Replace("@KEY@",apiKey);
    success = curl.DoYourThing(cmd.GetAsString());
    if (success !== true) {
        console.log("No HTTP response. Chilkat failure code: " + curl.FailReason);
        return;
    }

    success = curl.GetResponseJson(json);
    if ((curl.StatusCode !== 200) || (success !== true)) {
        console.log("Stripe HTTP " + curl.StatusCode + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"));
        if (success == true) {
            console.log(json.StringOf("error.message"));
        }

        return;
    }

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

    more = json.BoolOf("has_more");
    if (more == true) {
        var next = json.StringOf("data[i].id");
        if ((count < 1) || (next == "") || (next == cursor)) {
            console.log("Invalid pagination cursor.");
            return;
        }

        cursor = next;
        pageSuffix.SetString("&starting_after=");
        pageSuffix.Append(cursor);
    }

}

success = ledger.SaveFile("stripe-balance-transactions.csv");
if (success == false) {
    console.log(ledger.LastErrorText);
    return;
}

console.log("Exported rows: " + outputRow);