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

Chilkat PowerBuilder Downloads

PowerBuilder
integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_Resp
oleobject loo_Dt
oleobject loo_Query
long li_Page
long li_LastPage
oleobject loo_ErrorInfo
oleobject loo_Result
long li_Parsed
long i
long li_Count

li_Success = 0

//  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.
loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Http.AuthToken = "SANDBOX_ACCESS_TOKEN"
loo_Resp = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

//  Use the UTC window containing the transaction (at most 31 days per request).
loo_Dt = create oleobject
li_rc = loo_Dt.ConnectToNewObject("Chilkat.CkDateTime")

loo_Dt.SetFromCurrentSystemTime()
loo_Query = create oleobject
li_rc = loo_Query.ConnectToNewObject("Chilkat.JsonObject")

loo_Query.UpdateString("end_date",loo_Dt.GetAsTimestamp(0))
loo_Dt.AddDays(-1)
loo_Query.UpdateString("start_date",loo_Dt.GetAsTimestamp(0))
loo_Query.UpdateString("fields","transaction_info")
loo_Query.UpdateInt("page_size",100)
loo_Query.UpdateString("transaction_type","T0006")
loo_Query.UpdateString("transaction_status","S")
li_Page = 1
li_LastPage = 1
do while (li_Page <= li_LastPage)
    loo_Query.UpdateInt("page",li_Page)
    li_Success = loo_Http.HttpParams("GET","https://api-m.sandbox.paypal.com/v1/reporting/transactions",loo_Query,loo_Resp)
    if li_Success <> 1 then
        Write-Debug "No HTTP response: " + loo_Http.LastErrorText
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Dt
        destroy loo_Query
        return
    end if

    if (loo_Resp.StatusCode < 200) OR (loo_Resp.StatusCode >= 300) then
        loo_ErrorInfo = create oleobject
        li_rc = loo_ErrorInfo.ConnectToNewObject("Chilkat.JsonObject")

        loo_ErrorInfo.Load(loo_Resp.BodyStr)
        Write-Debug "HTTP " + string(loo_Resp.StatusCode) + " " + loo_ErrorInfo.StringOf("name") + " " + loo_ErrorInfo.StringOf("details[0].issue")
        Write-Debug "PayPal debug ID: " + loo_ErrorInfo.StringOf("debug_id")
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Dt
        destroy loo_Query
        destroy loo_ErrorInfo
        return
    end if

    loo_Result = create oleobject
    li_rc = loo_Result.ConnectToNewObject("Chilkat.JsonObject")

    li_Parsed = loo_Result.Load(loo_Resp.BodyStr)
    if li_Parsed <> 1 then
        Write-Debug "Expected a JSON response; HTTP " + string(loo_Resp.StatusCode)
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Dt
        destroy loo_Query
        destroy loo_ErrorInfo
        destroy loo_Result
        return
    end if

    i = 0
    li_Count = loo_Result.SizeOfArray("transaction_details")
    do while (i < li_Count)
        loo_Result.I = i
        Write-Debug loo_Result.StringOf("transaction_details[i].transaction_info.transaction_id") + "  " + loo_Result.StringOf("transaction_details[i].transaction_info.transaction_event_code") + "  " + loo_Result.StringOf("transaction_details[i].transaction_info.transaction_status")
        Write-Debug "  " + loo_Result.StringOf("transaction_details[i].transaction_info.transaction_amount.value") + " " + loo_Result.StringOf("transaction_details[i].transaction_info.transaction_amount.currency_code")
        i = i + 1
    loop
    li_LastPage = loo_Result.IntOf("total_pages")
    li_Page = li_Page + 1
loop


destroy loo_Http
destroy loo_Resp
destroy loo_Dt
destroy loo_Query
destroy loo_ErrorInfo
destroy loo_Result