Sample code for 30+ languages & platforms
CkPython Requires Chilkat v11.0.0+

PayPal: Reconcile a transaction ID in a reporting window

See more PayPal Examples

Supply the reporting transaction ID and a window containing the activity. Return all matches: transaction IDs are not necessarily unique in the report. Include non-balance-affecting records when reconciling an event.

PayPal documentation

Chilkat CkPython Downloads

CkPython
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_id","REPORT_TRANSACTION_ID")
query.UpdateString("balance_affecting_records_only","N")
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