Python Requires Chilkat v11.0.0+

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.

PayPal documentation

Python

import sys
import chilkat2

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 = chilkat2.Http()
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
resp = chilkat2.HttpResponse()
# Use the UTC window containing the transaction (at most 31 days per request).
dt = chilkat2.CkDateTime()
dt.SetFromCurrentSystemTime()
query = chilkat2.JsonObject()
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.StatusCode < 200) or (resp.StatusCode >= 300)):
        errorInfo = chilkat2.JsonObject()
        errorInfo.Load(resp.BodyStr)
        print("HTTP " + str(resp.StatusCode) + " " + errorInfo.StringOf("name") + " " + errorInfo.StringOf("details[0].issue"))
        print("PayPal debug ID: " + errorInfo.StringOf("debug_id"))
        sys.exit()

    result = chilkat2.JsonObject()
    parsed = result.Load(resp.BodyStr)
    if (parsed != True):
        print("Expected a JSON response; HTTP " + str(resp.StatusCode))
        sys.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"))
        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