Xojo Plugin
Xojo Plugin
Aruba Fatturazione Elettronica Find Invoice by Username
See more Aruba Fatturazione Examples
Finds a list of invoices. Returns invoices without content in base64 (lazy loading)Chilkat Xojo Plugin Downloads
Dim success As Boolean
success = False
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Dim http As New Chilkat.Http
// 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
System.DebugLog(http.LastErrorText)
Return
End If
Dim jResp As New Chilkat.JsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False
System.DebugLog("Response Body:")
System.DebugLog(jResp.Emit())
Dim respStatusCode As Int32
respStatusCode = http.LastStatus
System.DebugLog("Response Status Code = " + Str(respStatusCode))
If (respStatusCode >= 400) Then
System.DebugLog("Response Header:")
System.DebugLog(http.LastHeader)
System.DebugLog("Failed.")
Return
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 Int32
Dim count_j As Int32
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 Boolean
last = jResp.BoolOf("last")
Dim totalElements As Int32
totalElements = jResp.IntOf("totalElements")
Dim totalPages As Int32
totalPages = jResp.IntOf("totalPages")
Dim size As Int32
size = jResp.IntOf("size")
Dim number As Int32
number = jResp.IntOf("number")
Dim first As Boolean
first = jResp.BoolOf("first")
Dim numberOfElements As Int32
numberOfElements = jResp.IntOf("numberOfElements")
Dim i As Int32
i = 0
Dim count_i As Int32
count_i = 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
Wend
i = i + 1
Wend