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

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.

PayPal documentation

Chilkat Xojo Plugin Downloads

Xojo Plugin
Dim success As Boolean
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.
Dim http As New Chilkat.Http
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
Dim resp As New Chilkat.HttpResponse

//  Request total_pages so a merchant with more than one page sees every invoice.
Dim page As Int32
page = 1
Dim lastPage As Int32
lastPage = 1
While (page <= lastPage)
    Dim url As New Chilkat.StringBuilder
    success = url.Append("https://api-m.sandbox.paypal.com/v2/invoicing/invoices?total_required=true&page_size=20&page=")
    success = url.AppendInt(page)
    success = http.HttpNoBody("GET",url.GetAsString(),resp)
    If (success <> True) Then
        System.DebugLog("No HTTP response: " + http.LastErrorText)
        Return
    End If

    If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
        Dim errorInfo As New Chilkat.JsonObject
        success = errorInfo.Load(resp.BodyStr)
        System.DebugLog("HTTP " + Str(resp.StatusCode) + " " + errorInfo.StringOf("name") + " " + errorInfo.StringOf("details[0].issue"))
        System.DebugLog("PayPal debug ID: " + errorInfo.StringOf("debug_id"))
        Return
    End If

    Dim result As New Chilkat.JsonObject
    Dim parsed As Boolean
    parsed = result.Load(resp.BodyStr)
    If (parsed <> True) Then
        System.DebugLog("Expected a JSON response; HTTP " + Str(resp.StatusCode))
        Return
    End If

    Dim i As Int32
    i = 0
    Dim count As Int32
    count = result.SizeOfArray("items")
    While (i < count)
        result.I = i
        System.DebugLog(result.StringOf("items[i].id") + "  " + result.StringOf("items[i].detail.invoice_number") + "  " + result.StringOf("items[i].status"))
        i = i + 1
    Wend
    lastPage = result.IntOf("total_pages")
    page = page + 1
Wend