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

Delphi ActiveX
var
success: Integer;
apiKey: WideString;
curl: TChilkatHttpCurl;
cmd: TChilkatStringBuilder;
json: TChilkatJsonObject;
replaced: Integer;
fromTime: WideString;
untilTime: WideString;
ledger: TChilkatCsv;
outputRow: Integer;
pageSuffix: TChilkatStringBuilder;
more: Integer;
cursor: WideString;
i: Integer;
count: Integer;
next: WideString;

begin
success := 0;

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

curl := TChilkatHttpCurl.Create(Self);
cmd := TChilkatStringBuilder.Create(Self);
json := TChilkatJsonObject.Create(Self);

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

ledger := TChilkatCsv.Create(Self);
ledger.HasColumnNames := 1;
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');

pageSuffix := TChilkatStringBuilder.Create(Self);
more := 1;
cursor := '';
while (more = 1) do
  begin
    //  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 <> 1) then
      begin
        Memo1.Lines.Add('No HTTP response. Chilkat failure code: ' + IntToStr(curl.FailReason));
        Exit;
      end;
    success := curl.GetResponseJson(json.ControlInterface);
    if ((curl.StatusCode <> 200) or (success <> 1)) then
      begin
        Memo1.Lines.Add('Stripe HTTP ' + IntToStr(curl.StatusCode) + '  Request-Id: ' + curl.GetResponseHeaderField('Request-Id'));
        if (success = 1) then
          begin
            Memo1.Lines.Add(json.StringOf('error.message'));
          end;
        Exit;
      end;

    i := 0;
    count := json.SizeOfArray('data');
    while (i < count) do
      begin
        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;
      end;

    more := json.BoolOf('has_more');
    if (more = 1) then
      begin
        next := json.StringOf('data[i].id');
        if ((count < 1) or (next = '') or (next = cursor)) then
          begin
            Memo1.Lines.Add('Invalid pagination cursor.');
            Exit;
          end;
        cursor := next;
        pageSuffix.SetString('&starting_after=');
        pageSuffix.Append(cursor);
      end;
  end;

success := ledger.SaveFile('stripe-balance-transactions.csv');
if (success = 0) then
  begin
    Memo1.Lines.Add(ledger.LastErrorText);
    Exit;
  end;

Memo1.Lines.Add('Exported rows: ' + IntToStr(outputRow));