Sample code for 30+ languages & platforms
PHP ActiveX Requires Chilkat v11.0.0+

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.

PayPal documentation

Chilkat PHP ActiveX Downloads

PHP ActiveX
<?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;
}


?>