(Delphi ActiveX) 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 for Delphi Downloads Chilkat ActiveX DLL for Delphi Chilkat non-ActiveX DLL for Delphi * The examples here use the ActiveX DLL.

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

procedure TForm1.Button1Click(Sender: TObject);
var
http: TChilkatHttp;
success: Integer;
sbResponseBody: TChilkatStringBuilder;
jResp: TChilkatJsonObject;
respStatusCode: Integer;
id: WideString;
senderDescription: WideString;
senderCountryCode: WideString;
senderVatCode: WideString;
senderFiscalCode: WideString;
receiverDescription: WideString;
receiverCountryCode: WideString;
receiverVatCode: WideString;
receiverFiscalCode: WideString;
invoiceType: WideString;
docType: WideString;
file: WideString;
filename: WideString;
username: WideString;
lastUpdate: WideString;
creationDate: WideString;
idSdi: WideString;
pddAvailable: Integer;
j: Integer;
count_j: Integer;
invoiceDate: WideString;
number_str: WideString;
status: WideString;
statusDescription: WideString;
errorCode: WideString;
errorDescription: WideString;
last: Integer;
totalElements: Integer;
totalPages: Integer;
size: Integer;
number: Integer;
first: Integer;
numberOfElements: Integer;
i: Integer;
count_i: Integer;

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

http := TChilkatHttp.Create(Self);

// 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');

sbResponseBody := TChilkatStringBuilder.Create(Self);
success := http.QuickGetSb('https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Username',sbResponseBody.ControlInterface);
if (success = 0) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

jResp := TChilkatJsonObject.Create(Self);
jResp.LoadSb(sbResponseBody.ControlInterface);
jResp.EmitCompact := 0;

Memo1.Lines.Add('Response Body:');
Memo1.Lines.Add(jResp.Emit());

respStatusCode := http.LastStatus;
Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
if (respStatusCode >= 400) then
  begin
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(http.LastHeader);
    Memo1.Lines.Add('Failed.');
    Exit;
  end;

// 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

errorCode := jResp.StringOf('errorCode');
errorDescription := jResp.StringOf('errorDescription');
last := jResp.BoolOf('last');
totalElements := jResp.IntOf('totalElements');
totalPages := jResp.IntOf('totalPages');
size := jResp.IntOf('size');
number := jResp.IntOf('number');
first := jResp.BoolOf('first');
numberOfElements := jResp.IntOf('numberOfElements');
i := 0;
count_i := jResp.SizeOfArray('content');
while i < count_i do
  begin
    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 do
      begin
        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;

    i := i + 1;
  end;
end;