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

VBScript
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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.
set http = CreateObject("Chilkat.Http")
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
set resp = CreateObject("Chilkat.HttpResponse")

'  Request total_pages so a merchant with more than one page sees every invoice.
page = 1
lastPage = 1
Do While (page <= lastPage)
    set url = CreateObject("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 <> 1) Then
        outFile.WriteLine("No HTTP response: " & http.LastErrorText)
        WScript.Quit
    End If

    If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
        set errorInfo = CreateObject("Chilkat.JsonObject")
        success = errorInfo.Load(resp.BodyStr)
        outFile.WriteLine("HTTP " & resp.StatusCode & " " & errorInfo.StringOf("name") & " " & errorInfo.StringOf("details[0].issue"))
        outFile.WriteLine("PayPal debug ID: " & errorInfo.StringOf("debug_id"))
        WScript.Quit
    End If

    set result = CreateObject("Chilkat.JsonObject")
    parsed = result.Load(resp.BodyStr)
    If (parsed <> 1) Then
        outFile.WriteLine("Expected a JSON response; HTTP " & resp.StatusCode)
        WScript.Quit
    End If

    i = 0
    count = result.SizeOfArray("items")
    Do While (i < count)
        result.I = i
        outFile.WriteLine(result.StringOf("items[i].id") & "  " & result.StringOf("items[i].detail.invoice_number") & "  " & result.StringOf("items[i].status"))
        i = i + 1
    Loop
    lastPage = result.IntOf("total_pages")
    page = page + 1
Loop

outFile.Close