Classic ASP Requires Chilkat v11.0.0+
Classic ASP
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 Classic ASP Downloads
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
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.
set http = Server.CreateObject("Chilkat.Http")
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
set resp = Server.CreateObject("Chilkat.HttpResponse")
' Use the UTC window containing the transaction (at most 31 days per request).
set dt = Server.CreateObject("Chilkat.CkDateTime")
success = dt.SetFromCurrentSystemTime()
set query = Server.CreateObject("Chilkat.JsonObject")
success = query.UpdateString("end_date",dt.GetAsTimestamp(0))
success = dt.AddDays(-1)
success = query.UpdateString("start_date",dt.GetAsTimestamp(0))
success = query.UpdateString("fields","transaction_info")
success = query.UpdateInt("page_size",100)
page = 1
lastPage = 1
Do While (page <= lastPage)
success = query.UpdateInt("page",page)
success = http.HttpParams("GET","https://api-m.sandbox.paypal.com/v1/reporting/transactions",query,resp)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "No HTTP response: " & http.LastErrorText) & "</pre>"
Response.End
End If
If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
set errorInfo = Server.CreateObject("Chilkat.JsonObject")
success = errorInfo.Load(resp.BodyStr)
Response.Write "<pre>" & Server.HTMLEncode( "HTTP " & resp.StatusCode & " " & errorInfo.StringOf("name") & " " & errorInfo.StringOf("details[0].issue")) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( "PayPal debug ID: " & errorInfo.StringOf("debug_id")) & "</pre>"
Response.End
End If
set result = Server.CreateObject("Chilkat.JsonObject")
parsed = result.Load(resp.BodyStr)
If (parsed <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "Expected a JSON response; HTTP " & resp.StatusCode) & "</pre>"
Response.End
End If
i = 0
count = result.SizeOfArray("transaction_details")
Do While (i < count)
result.I = i
Response.Write "<pre>" & Server.HTMLEncode( 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")) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( " " & result.StringOf("transaction_details[i].transaction_info.transaction_amount.value") & " " & result.StringOf("transaction_details[i].transaction_info.transaction_amount.currency_code")) & "</pre>"
i = i + 1
Loop
lastPage = result.IntOf("total_pages")
page = page + 1
Loop
%>
</body>
</html>