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

PayPal: Find invoices for a recipient

See more PayPal Examples

Filter by a sandbox recipient email address in the JSON body. Pagination belongs in the URL. Read every matching invoice ID; several invoices can share the same recipient.

PayPal documentation

Chilkat PowerBuilder Downloads

PowerBuilder
integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_Resp
oleobject loo_Body
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")

//  Use a JSON search body on every page; the recipient email does not belong in the
//  URL.
loo_Body = create oleobject
li_rc = loo_Body.ConnectToNewObject("Chilkat.JsonObject")

loo_Body.UpdateString("recipient_email","buyer@example.com")
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/search-invoices?total_required=true&page_size=20&page=")
    loo_Url.AppendInt(li_Page)
    li_Success = loo_Http.HttpJson("POST",loo_Url.GetAsString(),loo_Body,"application/json",loo_Resp)
    if li_Success <> 1 then
        Write-Debug "No HTTP response: " + loo_Http.LastErrorText
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Body
        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_Body
        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_Body
        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_Body
destroy loo_Url
destroy loo_ErrorInfo
destroy loo_Result