PowerBuilder Requires Chilkat v11.0.0+
PowerBuilder
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 PowerBuilder Downloads
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