CkPython Requires Chilkat v11.0.0+
CkPython
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 CkPython Downloads
import sys
import chilkat
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.
http = chilkat.CkHttp()
http.put_AuthToken("SANDBOX_ACCESS_TOKEN")
resp = chilkat.CkHttpResponse()
# Use the UTC window containing the transaction (at most 31 days per request).
dt = chilkat.CkDateTime()
dt.SetFromCurrentSystemTime()
query = chilkat.CkJsonObject()
query.UpdateString("end_date",dt.getAsTimestamp(False))
dt.AddDays(-1)
query.UpdateString("start_date",dt.getAsTimestamp(False))
query.UpdateString("fields","transaction_info")
query.UpdateInt("page_size",100)
query.UpdateString("transaction_type","T0006")
query.UpdateString("transaction_status","S")
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 != True):
print("No HTTP response: " + http.lastErrorText())
sys.exit()
if ((resp.get_StatusCode() < 200) or (resp.get_StatusCode() >= 300)):
errorInfo = chilkat.CkJsonObject()
errorInfo.Load(resp.bodyStr())
print("HTTP " + str(resp.get_StatusCode()) + " " + errorInfo.stringOf("name") + " " + errorInfo.stringOf("details[0].issue"))
print("PayPal debug ID: " + errorInfo.stringOf("debug_id"))
sys.exit()
result = chilkat.CkJsonObject()
parsed = result.Load(resp.bodyStr())
if (parsed != True):
print("Expected a JSON response; HTTP " + str(resp.get_StatusCode()))
sys.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"))
print(" " + result.stringOf("transaction_details[i].transaction_info.transaction_amount.value") + " " + result.stringOf("transaction_details[i].transaction_info.transaction_amount.currency_code"))
i = i + 1
lastPage = result.IntOf("total_pages")
page = page + 1