PowerBuilder Requires Chilkat v11.0.0+
PowerBuilder
PayPal: List merchant invoices across pages
See more PayPal Examples
List invoices for the authenticated merchant. Request totals, iterate every page, and keep the PayPal ID alongside the human-readable number and current status.
Chilkat PowerBuilder Downloads
integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_Resp
long li_Page
long li_LastPage
oleobject loo_Url
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")
// Request total_pages so a merchant with more than one page sees every invoice.
li_Page = 1
li_LastPage = 1
do while (li_Page <= li_LastPage)
loo_Url = create oleobject
li_rc = loo_Url.ConnectToNewObject("Chilkat.StringBuilder")
loo_Url.Append("https://api-m.sandbox.paypal.com/v2/invoicing/invoices?total_required=true&page_size=20&page=")
loo_Url.AppendInt(li_Page)
li_Success = loo_Http.HttpNoBody("GET",loo_Url.GetAsString(),loo_Resp)
if li_Success <> 1 then
Write-Debug "No HTTP response: " + loo_Http.LastErrorText
destroy loo_Http
destroy loo_Resp
destroy loo_Url
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_Url
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_Url
destroy loo_ErrorInfo
destroy loo_Result
return
end if
i = 0
li_Count = loo_Result.SizeOfArray("items")
do while (i < li_Count)
loo_Result.I = i
Write-Debug loo_Result.StringOf("items[i].id") + " " + loo_Result.StringOf("items[i].detail.invoice_number") + " " + loo_Result.StringOf("items[i].status")
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_Url
destroy loo_ErrorInfo
destroy loo_Result