Ricerca una lista di fatture. Ritorna le fatture senza il contenuto in base64 (lazy loading)
curl -X GET https://demows.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Utente \
-H 'Accept: application/json' \
-H 'Authorization: Bearer NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE='
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest
' URL: https://demows.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Utente
bTls = True
port = 443
bAutoReconnect = True
success = rest.Connect("demows.fatturazioneelettronica.aruba.it",port,bTls,bAutoReconnect)
If (success <> True) Then
Debug.Print "ConnectFailReason: "; rest.ConnectFailReason
Debug.Print rest.LastErrorText
Exit Sub
End If
success = rest.AddHeader("Authorization","Bearer NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE=")
success = rest.AddHeader("Accept","application/json")
Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/services/invoice/in/findByUsername?username=Utente",sbResponseBody)
If (success <> True) Then
Debug.Print rest.LastErrorText
Exit Sub
End If
respStatusCode = rest.ResponseStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Status Code = "; respStatusCode
Debug.Print "Response Header:"
Debug.Print rest.ResponseHeader
Debug.Print "Response Body:"
Debug.Print sbResponseBody.GetAsString()
Exit Sub
End If
Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
success = jsonResponse.LoadSb(sbResponseBody)
' See the Online Tool for Generating JSON Parse Code
last = jsonResponse.BoolOf("last")
totalElements = jsonResponse.IntOf("totalElements")
totalPages = jsonResponse.IntOf("totalPages")
size = jsonResponse.IntOf("size")
number = jsonResponse.IntOf("number")
first = jsonResponse.BoolOf("first")
numberOfElements = jsonResponse.IntOf("numberOfElements")
i = 0
count_i = jsonResponse.SizeOfArray("content")
Do While i < count_i
jsonResponse.I = i
id = jsonResponse.StringOf("content[i].id")
senderDescription = jsonResponse.StringOf("content[i].sender.description")
senderCountryCode = jsonResponse.StringOf("content[i].sender.countryCode")
senderVatCode = jsonResponse.StringOf("content[i].sender.vatCode")
senderFiscalCode = jsonResponse.StringOf("content[i].sender.fiscalCode")
receiverDescription = jsonResponse.StringOf("content[i].receiver.description")
receiverCountryCode = jsonResponse.StringOf("content[i].receiver.countryCode")
receiverVatCode = jsonResponse.StringOf("content[i].receiver.vatCode")
receiverFiscalCode = jsonResponse.StringOf("content[i].receiver.fiscalCode")
invoiceType = jsonResponse.StringOf("content[i].invoiceType")
docType = jsonResponse.StringOf("content[i].docType")
file = jsonResponse.StringOf("content[i].file")
filename = jsonResponse.StringOf("content[i].filename")
username = jsonResponse.StringOf("content[i].username")
lastUpdate = jsonResponse.StringOf("content[i].lastUpdate")
idSdi = jsonResponse.StringOf("content[i].idSdi")
j = 0
count_j = jsonResponse.SizeOfArray("content[i].invoices")
Do While j < count_j
jsonResponse.J = j
invoiceDate = jsonResponse.StringOf("content[i].invoices[j].invoiceDate")
number_str = jsonResponse.StringOf("content[i].invoices[j].number")
status = jsonResponse.StringOf("content[i].invoices[j].status")
j = j + 1
Loop
i = i + 1
Loop
{
"content": [
{
"id": "0",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037880_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.818+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.819+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "1",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037881_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "2",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037882_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "3",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037883_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "4",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037884_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "5",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037885_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "6",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037886_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.824+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.824+01:00",
"idSdi": null
},
{
"id": "7",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037887_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.825+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.825+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.825+01:00",
"idSdi": null
},
{
"id": "8",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037888_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.825+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.825+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.825+01:00",
"idSdi": null
},
{
"id": "9",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "22222222",
"fiscalCode": "11111111111"
},
"receiver": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "4444444",
"fiscalCode": "333333333"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037889_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:10.825+01:00",
"number": "1",
"status": "Inviata"
},
{
"invoiceDate": "2019-01-21T17:36:10.825+01:00",
"number": "2",
"status": "Consegnata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:10.825+01:00",
"idSdi": null
}
],
"last": true,
"totalElements": 10,
"totalPages": 1,
"size": 10,
"number": 0,
"first": true,
"numberOfElements": 10
}