Sample code for 30+ languages & platforms
Ruby 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 Ruby Downloads

Ruby
require '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.new()
http.put_AuthToken("SANDBOX_ACCESS_TOKEN")
resp = Chilkat::CkHttpResponse.new()
#  Use the UTC window containing the transaction (at most 31 days per request).
dt = Chilkat::CkDateTime.new()
dt.SetFromCurrentSystemTime()
query = Chilkat::CkJsonObject.new()
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() + "\n";
        exit
    end

    if ((resp.get_StatusCode() < 200) or (resp.get_StatusCode() >= 300))
        errorInfo = Chilkat::CkJsonObject.new()
        errorInfo.Load(resp.bodyStr())
        print "HTTP " + resp.get_StatusCode().to_s() + " " + errorInfo.stringOf("name") + " " + errorInfo.stringOf("details[0].issue") + "\n";
        print "PayPal debug ID: " + errorInfo.stringOf("debug_id") + "\n";
        exit
    end

    result = Chilkat::CkJsonObject.new()
    parsed = result.Load(resp.bodyStr())
    if (parsed != true)
        print "Expected a JSON response; HTTP " + resp.get_StatusCode().to_s() + "\n";
        exit
    end

    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") + "\n";
        print "  " + result.stringOf("transaction_details[i].transaction_info.transaction_amount.value") + " " + result.stringOf("transaction_details[i].transaction_info.transaction_amount.currency_code") + "\n";
        i = i + 1
    end
    lastPage = result.IntOf("total_pages")
    page = page + 1
end