Xojo Plugin Requires Chilkat v11.0.0+
Xojo Plugin
PayPal: Find successful Express Checkout transactions
See more PayPal Examples
Filter a reporting window by T0006 (Express Checkout) and S (success). The signed amount distinguishes money received from money sent. This is one transaction class, not all merchant sales; reporting access is required.
Chilkat Xojo Plugin Downloads
Dim success As Boolean
success = False
// 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.
Dim http As New Chilkat.Http
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
Dim resp As New Chilkat.HttpResponse
// Use the UTC window containing the transaction (at most 31 days per request).
Dim dt As New Chilkat.CkDateTime
success = dt.SetFromCurrentSystemTime()
Dim query As New Chilkat.JsonObject
success = query.UpdateString("end_date",dt.GetAsTimestamp(False))
success = dt.AddDays(-1)
success = query.UpdateString("start_date",dt.GetAsTimestamp(False))
success = query.UpdateString("fields","transaction_info")
success = query.UpdateInt("page_size",100)
success = query.UpdateString("transaction_type","T0006")
success = query.UpdateString("transaction_status","S")
Dim page As Int32
page = 1
Dim lastPage As Int32
lastPage = 1
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 <> True) Then
System.DebugLog("No HTTP response: " + http.LastErrorText)
Return
End If
If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
Dim errorInfo As New Chilkat.JsonObject
success = errorInfo.Load(resp.BodyStr)
System.DebugLog("HTTP " + Str(resp.StatusCode) + " " + errorInfo.StringOf("name") + " " + errorInfo.StringOf("details[0].issue"))
System.DebugLog("PayPal debug ID: " + errorInfo.StringOf("debug_id"))
Return
End If
Dim result As New Chilkat.JsonObject
Dim parsed As Boolean
parsed = result.Load(resp.BodyStr)
If (parsed <> True) Then
System.DebugLog("Expected a JSON response; HTTP " + Str(resp.StatusCode))
Return
End If
Dim i As Int32
i = 0
Dim count As Int32
count = result.SizeOfArray("transaction_details")
While (i < count)
result.I = i
System.DebugLog(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"))
System.DebugLog(" " + result.StringOf("transaction_details[i].transaction_info.transaction_amount.value") + " " + result.StringOf("transaction_details[i].transaction_info.transaction_amount.currency_code"))
i = i + 1
Wend
lastPage = result.IntOf("total_pages")
page = page + 1
Wend