(Visual Basic 6.0) Aruba Fatturazione Elettronica Find Invoice by Username

Finds a list of invoices. Returns invoices without content in base64 (lazy loading)

For more information, see https://fatturazioneelettronica.aruba.it/apidoc/docs_EN.html#_findbyusername_2

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp
Dim success As Long

' Implements the following CURL command:

' curl -X GET https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Username \
'   -H "Accept: application/json" \
'   -H "Authorization: Bearer NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE="

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

' Adds the "Authorization: Bearer NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE=" header.
http.AuthToken = "NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE="
http.SetRequestHeader "Accept","application/json"

Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Username",sbResponseBody)
If (success = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastHeader
    Debug.Print "Failed."
    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "errorCode": "0000",
'   "errorDescription": null,
'   "content": [
'     {
'       "errorCode": null,
'       "errorDescription": null,
'       "id": "1",
'       "sender": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "22222222",
'         "fiscalCode": "11111111111"
'       },
'       "receiver": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "4444444",
'         "fiscalCode": "333333333"
'       },
'       "invoiceType": "FPR12",
'       "docType": "in",
'       "file": null,
'       "filename": "IT01879020517_jtlk0.xml.p7m",
'       "invoices": [
'         {
'           "invoiceDate": "2020-07-10T09:19:56.948+02:00",
'           "number": "2020/0001",
'           "status": "Inviata",
'           "statusDescription": ""
'         }
'       ],
'       "username": "Utente",
'       "lastUpdate": "2020-07-10T07:19:56.948+0000",
'       "creationDate": "2020-07-10T07:19:56.948+0000",
'       "idSdi": "11110",
'       "pddAvailable": true
'     },
'     {
'       "errorCode": null,
'       "errorDescription": null,
'       "id": "2",
'       "sender": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "22222222",
'         "fiscalCode": "11111111111"
'       },
'       "receiver": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "4444444",
'         "fiscalCode": "333333333"
'       },
'       "invoiceType": "FPR12",
'       "docType": "in",
'       "file": null,
'       "filename": "IT01879020517_jtlk1.xml.p7m",
'       "invoices": [
'         {
'           "invoiceDate": "2020-07-10T09:19:56.948+02:00",
'           "number": "2020/0002",
'           "status": "Inviata",
'           "statusDescription": ""
'         }
'       ],
'       "username": "Utente",
'       "lastUpdate": "2020-07-10T07:19:56.948+0000",
'       "creationDate": "2020-07-10T07:19:56.948+0000",
'       "idSdi": "11111",
'       "pddAvailable": true
'     },
'     {
'       "errorCode": null,
'       "errorDescription": null,
'       "id": "3",
'       "sender": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "22222222",
'         "fiscalCode": "11111111111"
'       },
'       "receiver": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "4444444",
'         "fiscalCode": "333333333"
'       },
'       "invoiceType": "FPR12",
'       "docType": "in",
'       "file": null,
'       "filename": "IT01879020517_jtlk2.xml.p7m",
'       "invoices": [
'         {
'           "invoiceDate": "2020-07-10T09:19:56.948+02:00",
'           "number": "2020/0003",
'           "status": "Inviata",
'           "statusDescription": ""
'         }
'       ],
'       "username": "Utente",
'       "lastUpdate": "2020-07-10T07:19:56.948+0000",
'       "creationDate": "2020-07-10T07:19:56.948+0000",
'       "idSdi": "11112",
'       "pddAvailable": true
'     },
'     {
'       "errorCode": null,
'       "errorDescription": null,
'       "id": "4",
'       "sender": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "22222222",
'         "fiscalCode": "11111111111"
'       },
'       "receiver": {
'         "description": "Aruba SPA",
'         "countryCode": "IT",
'         "vatCode": "4444444",
'         "fiscalCode": "333333333"
'       },
'       "invoiceType": "FPR12",
'       "docType": "in",
'       "file": null,
'       "filename": "IT01879020517_jtlk3.xml.p7m",
'       "invoices": [
'         {
'           "invoiceDate": "2020-07-10T09:19:56.948+02:00",
'           "number": "2020/0004",
'           "status": "Inviata",
'           "statusDescription": ""
'         }
'       ],
'       "username": "Utente",
'       "lastUpdate": "2020-07-10T07:19:56.948+0000",
'       "creationDate": "2020-07-10T07:19:56.948+0000",
'       "idSdi": "11113",
'       "pddAvailable": true
'     }
'   ],
'   "last": true,
'   "totalElements": 4,
'   "totalPages": 1,
'   "size": 10,
'   "number": 1,
'   "first": true,
'   "numberOfElements": 4
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON

Dim id As String
Dim senderDescription As String
Dim senderCountryCode As String
Dim senderVatCode As String
Dim senderFiscalCode As String
Dim receiverDescription As String
Dim receiverCountryCode As String
Dim receiverVatCode As String
Dim receiverFiscalCode As String
Dim invoiceType As String
Dim docType As String
Dim file As String
Dim filename As String
Dim username As String
Dim lastUpdate As String
Dim creationDate As String
Dim idSdi As String
Dim pddAvailable As Long
Dim j As Long
Dim count_j As Long
Dim invoiceDate As String
Dim number_str As String
Dim status As String
Dim statusDescription As String

Dim errorCode As String
errorCode = jResp.StringOf("errorCode")
Dim errorDescription As String
errorDescription = jResp.StringOf("errorDescription")
Dim last As Long
last = jResp.BoolOf("last")
Dim totalElements As Long
totalElements = jResp.IntOf("totalElements")
Dim totalPages As Long
totalPages = jResp.IntOf("totalPages")
Dim size As Long
size = jResp.IntOf("size")
Dim number As Long
number = jResp.IntOf("number")
Dim first As Long
first = jResp.BoolOf("first")
Dim numberOfElements As Long
numberOfElements = jResp.IntOf("numberOfElements")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("content")
Do While i < count_i
    jResp.I = i
    errorCode = jResp.StringOf("content[i].errorCode")
    errorDescription = jResp.StringOf("content[i].errorDescription")
    id = jResp.StringOf("content[i].id")
    senderDescription = jResp.StringOf("content[i].sender.description")
    senderCountryCode = jResp.StringOf("content[i].sender.countryCode")
    senderVatCode = jResp.StringOf("content[i].sender.vatCode")
    senderFiscalCode = jResp.StringOf("content[i].sender.fiscalCode")
    receiverDescription = jResp.StringOf("content[i].receiver.description")
    receiverCountryCode = jResp.StringOf("content[i].receiver.countryCode")
    receiverVatCode = jResp.StringOf("content[i].receiver.vatCode")
    receiverFiscalCode = jResp.StringOf("content[i].receiver.fiscalCode")
    invoiceType = jResp.StringOf("content[i].invoiceType")
    docType = jResp.StringOf("content[i].docType")
    file = jResp.StringOf("content[i].file")
    filename = jResp.StringOf("content[i].filename")
    username = jResp.StringOf("content[i].username")
    lastUpdate = jResp.StringOf("content[i].lastUpdate")
    creationDate = jResp.StringOf("content[i].creationDate")
    idSdi = jResp.StringOf("content[i].idSdi")
    pddAvailable = jResp.BoolOf("content[i].pddAvailable")
    j = 0
    count_j = jResp.SizeOfArray("content[i].invoices")
    Do While j < count_j
        jResp.J = j
        invoiceDate = jResp.StringOf("content[i].invoices[j].invoiceDate")
        number_str = jResp.StringOf("content[i].invoices[j].number")
        status = jResp.StringOf("content[i].invoices[j].status")
        statusDescription = jResp.StringOf("content[i].invoices[j].statusDescription")
        j = j + 1
    Loop
    i = i + 1
Loop