Delphi ActiveX Requires Chilkat v11.7.0+
Delphi ActiveX
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
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));