(VB.NET) 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 .NET Downloads Chilkat .NET Framework Chilkat for .NET Core

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

Dim http As New Chilkat.Http
Dim success As Boolean

' 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 Chilkat.StringBuilder
success = http.QuickGetSb("https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Username",sbResponseBody)
If (success = False) Then
    Debug.WriteLine(http.LastErrorText)
    Exit Sub
End If


Dim jResp As New Chilkat.JsonObject
jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

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

Dim respStatusCode As Integer = http.LastStatus
Debug.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
    Debug.WriteLine("Response Header:")
    Debug.WriteLine(http.LastHeader)
    Debug.WriteLine("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 Boolean
Dim j As Integer
Dim count_j As Integer
Dim invoiceDate As String
Dim number_str As String
Dim status As String
Dim statusDescription As String

Dim errorCode As String = jResp.StringOf("errorCode")
Dim errorDescription As String = jResp.StringOf("errorDescription")
Dim last As Boolean = jResp.BoolOf("last")
Dim totalElements As Integer = jResp.IntOf("totalElements")
Dim totalPages As Integer = jResp.IntOf("totalPages")
Dim size As Integer = jResp.IntOf("size")
Dim number As Integer = jResp.IntOf("number")
Dim first As Boolean = jResp.BoolOf("first")
Dim numberOfElements As Integer = jResp.IntOf("numberOfElements")
Dim i As Integer = 0
Dim count_i As Integer = jResp.SizeOfArray("content")
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")
    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
    End While
    i = i + 1
End While