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

Delphi DLL
var
success: Boolean;
apiKey: PWideChar;
curl: HCkHttpCurl;
cmd: HCkStringBuilder;
json: HCkJsonObject;
replaced: Integer;
fromTime: PWideChar;
untilTime: PWideChar;
ledger: HCkCsv;
outputRow: Integer;
pageSuffix: HCkStringBuilder;
more: Boolean;
cursor: PWideChar;
i: Integer;
count: Integer;
next: PWideChar;

begin
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) 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"
    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) then
      begin
        Memo1.Lines.Add('No HTTP response. Chilkat failure code: ' + IntToStr(CkHttpCurl_getFailReason(curl)));
        Exit;
      end;
    success := CkHttpCurl_GetResponseJson(curl,json);
    if ((CkHttpCurl_getStatusCode(curl) <> 200) or (success <> True)) then
      begin
        Memo1.Lines.Add('Stripe HTTP ' + IntToStr(CkHttpCurl_getStatusCode(curl)) + '  Request-Id: ' + CkHttpCurl__getResponseHeaderField(curl,'Request-Id'));
        if (success = True) then
          begin
            Memo1.Lines.Add(CkJsonObject__stringOf(json,'error.message'));
          end;
        Exit;
      end;

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

    more := CkJsonObject_BoolOf(json,'has_more');
    if (more = True) then
      begin
        next := CkJsonObject__stringOf(json,'data[i].id');
        if ((count < 1) or (next = '') or (next = cursor)) then
          begin
            Memo1.Lines.Add('Invalid pagination cursor.');
            Exit;
          end;
        cursor := next;
        CkStringBuilder_SetString(pageSuffix,'&starting_after=');
        CkStringBuilder_Append(pageSuffix,cursor);
      end;
  end;

success := CkCsv_SaveFile(ledger,'stripe-balance-transactions.csv');
if (success = False) then
  begin
    Memo1.Lines.Add(CkCsv__lastErrorText(ledger));
    Exit;
  end;

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

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