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

Visual Basic 6.0
Dim success As Long
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.
Dim http As New ChilkatHttp
http.AuthToken = "SANDBOX_ACCESS_TOKEN"
Dim resp As New ChilkatHttpResponse

'  Use a JSON search body on every page; the recipient email does not belong in the
'  URL.
Dim body As New ChilkatJsonObject
success = body.UpdateString("recipient_email","buyer@example.com")
Dim page As Long
page = 1
Dim lastPage As Long
lastPage = 1
Do While (page <= lastPage)
    Dim url As New ChilkatStringBuilder
    success = url.Append("https://api-m.sandbox.paypal.com/v2/invoicing/search-invoices?total_required=true&page_size=20&page=")
    success = url.AppendInt(page)
    success = http.HttpJson("POST",url.GetAsString(),body,"application/json",resp)
    If (success <> 1) Then
        Debug.Print "No HTTP response: " & http.LastErrorText
        Exit Sub
    End If

    If ((resp.StatusCode < 200) Or (resp.StatusCode >= 300)) Then
        Dim errorInfo As New ChilkatJsonObject
        success = errorInfo.Load(resp.BodyStr)
        Debug.Print "HTTP " & resp.StatusCode & " " & errorInfo.StringOf("name") & " " & errorInfo.StringOf("details[0].issue")
        Debug.Print "PayPal debug ID: " & errorInfo.StringOf("debug_id")
        Exit Sub
    End If

    Dim result As New ChilkatJsonObject
    Dim parsed As Long
    parsed = result.Load(resp.BodyStr)
    If (parsed <> 1) Then
        Debug.Print "Expected a JSON response; HTTP " & resp.StatusCode
        Exit Sub
    End If

    Dim i As Long
    i = 0
    Dim count As Long
    count = result.SizeOfArray("items")
    Do While (i < count)
        result.I = i
        Debug.Print 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