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