PHP ActiveX Requires Chilkat v11.0.0+
PHP ActiveX
PayPal: Page through merchant transactions
See more PayPal Examples
Read yesterday-to-now account activity one page at a time. Enable Transaction Search for the REST app and obtain a token with reporting access. Data can lag by up to three hours; use order or capture lookup for a checkout in progress.
Chilkat PHP ActiveX Downloads
<?php
$success = 0;
// See Unlock Chilkat before making requests.
// For the merchant's internal backoffice application. Load the sandbox token
// from the merchant's credential store. Keep it out of publicly distributed apps.
// See Get a PayPal access token.
$http = new COM("Chilkat.Http");
$http->AuthToken = 'SANDBOX_ACCESS_TOKEN';
$resp = new COM("Chilkat.HttpResponse");
// Use the UTC window containing the transaction (at most 31 days per request).
$dt = new COM("Chilkat.CkDateTime");
$dt->SetFromCurrentSystemTime();
$query = new COM("Chilkat.JsonObject");
$query->UpdateString('end_date',$dt->getAsTimestamp(0));
$dt->AddDays(-1);
$query->UpdateString('start_date',$dt->getAsTimestamp(0));
$query->UpdateString('fields','transaction_info');
$query->UpdateInt('page_size',100);
$page = 1;
$lastPage = 1;
while (($page <= $lastPage)) {
$query->UpdateInt('page',$page);
$success = $http->HttpParams('GET','https://api-m.sandbox.paypal.com/v1/reporting/transactions',$query,$resp);
if ($success != 1) {
print 'No HTTP response: ' . $http->LastErrorText . "\n";
exit;
}
if (($resp->StatusCode < 200) or ($resp->StatusCode >= 300)) {
$errorInfo = new COM("Chilkat.JsonObject");
$errorInfo->Load($resp->BodyStr);
print 'HTTP ' . $resp->StatusCode . ' ' . $errorInfo->stringOf('name') . ' ' . $errorInfo->stringOf('details[0].issue') . "\n";
print 'PayPal debug ID: ' . $errorInfo->stringOf('debug_id') . "\n";
exit;
}
$result = new COM("Chilkat.JsonObject");
$parsed = $result->Load($resp->BodyStr);
if ($parsed != 1) {
print 'Expected a JSON response; HTTP ' . $resp->StatusCode . "\n";
exit;
}
$i = 0;
$count = $result->SizeOfArray('transaction_details');
while (($i < $count)) {
$result->I = $i;
print $result->stringOf('transaction_details[i].transaction_info.transaction_id') . ' ' . $result->stringOf('transaction_details[i].transaction_info.transaction_event_code')
. ' ' . $result->stringOf('transaction_details[i].transaction_info.transaction_status') . "\n";
print ' ' . $result->stringOf('transaction_details[i].transaction_info.transaction_amount.value') . ' ' . $result->stringOf('transaction_details[i].transaction_info.transaction_amount.currency_code') . "\n";
$i = $i + 1;
}
$lastPage = $result->IntOf('total_pages');
$page = $page + 1;
}
?>