PHP ActiveX Requires Chilkat v11.7.0+
PHP 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 PHP ActiveX Downloads
<?php
$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 = new COM("Chilkat.HttpCurl");
$cmd = new COM("Chilkat.StringBuilder");
$json = new COM("Chilkat.JsonObject");
// Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
$fromTime = '1790812800';
$untilTime = '1793491200';
$ledger = new COM("Chilkat.Csv");
$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 = new COM("Chilkat.StringBuilder");
$more = 1;
$cursor = '';
while (($more == 1)) {
// 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) {
print 'No HTTP response. Chilkat failure code: ' . $curl->FailReason . "\n";
exit;
}
$success = $curl->GetResponseJson($json);
if (($curl->StatusCode != 200) or ($success != 1)) {
print 'Stripe HTTP ' . $curl->StatusCode . ' Request-Id: ' . $curl->getResponseHeaderField('Request-Id') . "\n";
if ($success == 1) {
print $json->stringOf('error.message') . "\n";
}
exit;
}
$i = 0;
$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 == 1) {
$next = $json->stringOf('data[i].id');
if (($count < 1) or ($next == '') or ($next == $cursor)) {
print 'Invalid pagination cursor.' . "\n";
exit;
}
$cursor = $next;
$pageSuffix->SetString('&starting_after=');
$pageSuffix->Append($cursor);
}
}
$success = $ledger->SaveFile('stripe-balance-transactions.csv');
if ($success == 0) {
print $ledger->LastErrorText . "\n";
exit;
}
print 'Exported rows: ' . $outputRow . "\n";
?>