Questo metodo restituisce l’elenco delle fatture elettroniche inviate dall’utente e prese in carico dal sistema. La lista di Fatture ritorna senza il contenuto in base64 (lazy loading)
curl -X GET https://demows.fatturazioneelettronica.aruba.it/services/invoice/out/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/out/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/out/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.IntOf("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": "1",
"sender": {
"description": "Aruba SPA",
"countryCode": "ITA",
"vatCode": "6372762541",
"fiscalCode": "N5Hnt9vvMZ"
},
"receiver": {
"description": "Rossi SRL",
"countryCode": "ITA",
"vatCode": "8767263441",
"fiscalCode": "LVZTeOJ8BN"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT07026037883_jtlkl.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:20.835+01:00",
"number": "1",
"status": "Inviata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:20.835+01:00",
"idSdi": 7895
},
{
"id": "2",
"sender": {
"description": "Aruba SPA",
"countryCode": "fKo",
"vatCode": "0845927294",
"fiscalCode": "1dzZUPwfhO"
},
"receiver": {
"description": "Rossi SRL",
"countryCode": "WGf",
"vatCode": "7188186772",
"fiscalCode": "p46bxpoQgx"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT00499202641_kwefc.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:20.835+01:00",
"number": "1",
"status": "Inviata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:20.835+01:00",
"idSdi": 7895
},
{
"id": "3",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "56215678997",
"fiscalCode": "94170917594"
},
"receiver": {
"description": "Rossi SRL",
"countryCode": "IT",
"vatCode": "27446044667",
"fiscalCode": "13591589640"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT01787589930_bkemy.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:20.835+01:00",
"number": "1",
"status": "Inviata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:20.835+01:00",
"idSdi": 7895
},
{
"id": "4",
"sender": {
"description": "Aruba SPA",
"countryCode": "IT",
"vatCode": "51878525587",
"fiscalCode": "37556497667"
},
"receiver": {
"description": "Rossi SRL",
"countryCode": "IT",
"vatCode": "95708696901",
"fiscalCode": "69989572913"
},
"invoiceType": "FPA12",
"docType": "in",
"file": null,
"filename": "IT06620176401_pdrjw.xml.p7m",
"invoices": [
{
"invoiceDate": "2019-01-21T17:36:20.835+01:00",
"number": "1",
"status": "Inviata"
}
],
"username": "Utente",
"lastUpdate": "2019-01-21T17:36:20.835+01:00",
"idSdi": 7895
}
],
"last": true,
"totalElements": 4,
"totalPages": 1,
"size": 10,
"number": 0,
"first": true,
"numberOfElements": 4
}