Sample code for 30+ languages & platforms
CkPerl 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 CkPerl Downloads

CkPerl
use chilkat();

$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 = chilkat::CkHttp->new();
$http->put_AuthToken("SANDBOX_ACCESS_TOKEN");
$resp = chilkat::CkHttpResponse->new();
#  Use the UTC window containing the transaction (at most 31 days per request).
$dt = chilkat::CkDateTime->new();
$dt->SetFromCurrentSystemTime();
$query = chilkat::CkJsonObject->new();
$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() . "\r\n";
        exit;
    }

    if (($resp->get_StatusCode() < 200) or ($resp->get_StatusCode() >= 300)) {
        $errorInfo = chilkat::CkJsonObject->new();
        $errorInfo->Load($resp->bodyStr());
        print "HTTP " . $resp->get_StatusCode() . " " . $errorInfo->stringOf("name") . " " . $errorInfo->stringOf("details[0].issue") . "\r\n";
        print "PayPal debug ID: " . $errorInfo->stringOf("debug_id") . "\r\n";
        exit;
    }

    $result = chilkat::CkJsonObject->new();
    $parsed = $result->Load($resp->bodyStr());
    if ($parsed != 1) {
        print "Expected a JSON response; HTTP " . $resp->get_StatusCode() . "\r\n";
        exit;
    }

    $i = 0;
    $count = $result->SizeOfArray("transaction_details");
    while (($i < $count)) {
        $result->put_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") . "\r\n";
        print "  " . $result->stringOf("transaction_details[i].transaction_info.transaction_amount.value") . " " . $result->stringOf("transaction_details[i].transaction_info.transaction_amount.currency_code") . "\r\n";
        $i = $i + 1;
    }

    $lastPage = $result->IntOf("total_pages");
    $page = $page + 1;
}