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

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

...

procedure TForm1.Button1Click(Sender: TObject);
var
http: HCkHttp;
success: Boolean;
sbResponseBody: HCkStringBuilder;
jResp: HCkJsonObject;
respStatusCode: Integer;
id: PWideChar;
senderDescription: PWideChar;
senderCountryCode: PWideChar;
senderVatCode: PWideChar;
senderFiscalCode: PWideChar;
receiverDescription: PWideChar;
receiverCountryCode: PWideChar;
receiverVatCode: PWideChar;
receiverFiscalCode: PWideChar;
invoiceType: PWideChar;
docType: PWideChar;
file: PWideChar;
filename: PWideChar;
username: PWideChar;
lastUpdate: PWideChar;
creationDate: PWideChar;
idSdi: PWideChar;
pddAvailable: Boolean;
j: Integer;
count_j: Integer;
invoiceDate: PWideChar;
number_str: PWideChar;
status: PWideChar;
statusDescription: PWideChar;
errorCode: PWideChar;
errorDescription: PWideChar;
last: Boolean;
totalElements: Integer;
totalPages: Integer;
size: Integer;
number: Integer;
first: Boolean;
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 := CkHttp_Create();

// 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.
CkHttp_putAuthToken(http,'NLOGDVXLVaF3tzmnVPkTwpkuh7dG0i09uSCcog3u+rE=');
CkHttp_SetRequestHeader(http,'Accept','application/json');

sbResponseBody := CkStringBuilder_Create();
success := CkHttp_QuickGetSb(http,'https://ws.fatturazioneelettronica.aruba.it/services/invoice/in/findByUsername?username=Username',sbResponseBody);
if (success = False) then
  begin
    Memo1.Lines.Add(CkHttp__lastErrorText(http));
    Exit;
  end;

jResp := CkJsonObject_Create();
CkJsonObject_LoadSb(jResp,sbResponseBody);
CkJsonObject_putEmitCompact(jResp,False);

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

respStatusCode := CkHttp_getLastStatus(http);
Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
if (respStatusCode >= 400) then
  begin
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(CkHttp__lastHeader(http));
    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 := CkJsonObject__stringOf(jResp,'errorCode');
errorDescription := CkJsonObject__stringOf(jResp,'errorDescription');
last := CkJsonObject_BoolOf(jResp,'last');
totalElements := CkJsonObject_IntOf(jResp,'totalElements');
totalPages := CkJsonObject_IntOf(jResp,'totalPages');
size := CkJsonObject_IntOf(jResp,'size');
number := CkJsonObject_IntOf(jResp,'number');
first := CkJsonObject_BoolOf(jResp,'first');
numberOfElements := CkJsonObject_IntOf(jResp,'numberOfElements');
i := 0;
count_i := CkJsonObject_SizeOfArray(jResp,'content');
while i < count_i do
  begin
    CkJsonObject_putI(jResp,i);
    errorCode := CkJsonObject__stringOf(jResp,'content[i].errorCode');
    errorDescription := CkJsonObject__stringOf(jResp,'content[i].errorDescription');
    id := CkJsonObject__stringOf(jResp,'content[i].id');
    senderDescription := CkJsonObject__stringOf(jResp,'content[i].sender.description');
    senderCountryCode := CkJsonObject__stringOf(jResp,'content[i].sender.countryCode');
    senderVatCode := CkJsonObject__stringOf(jResp,'content[i].sender.vatCode');
    senderFiscalCode := CkJsonObject__stringOf(jResp,'content[i].sender.fiscalCode');
    receiverDescription := CkJsonObject__stringOf(jResp,'content[i].receiver.description');
    receiverCountryCode := CkJsonObject__stringOf(jResp,'content[i].receiver.countryCode');
    receiverVatCode := CkJsonObject__stringOf(jResp,'content[i].receiver.vatCode');
    receiverFiscalCode := CkJsonObject__stringOf(jResp,'content[i].receiver.fiscalCode');
    invoiceType := CkJsonObject__stringOf(jResp,'content[i].invoiceType');
    docType := CkJsonObject__stringOf(jResp,'content[i].docType');
    file := CkJsonObject__stringOf(jResp,'content[i].file');
    filename := CkJsonObject__stringOf(jResp,'content[i].filename');
    username := CkJsonObject__stringOf(jResp,'content[i].username');
    lastUpdate := CkJsonObject__stringOf(jResp,'content[i].lastUpdate');
    creationDate := CkJsonObject__stringOf(jResp,'content[i].creationDate');
    idSdi := CkJsonObject__stringOf(jResp,'content[i].idSdi');
    pddAvailable := CkJsonObject_BoolOf(jResp,'content[i].pddAvailable');
    j := 0;
    count_j := CkJsonObject_SizeOfArray(jResp,'content[i].invoices');
    while j < count_j do
      begin
        CkJsonObject_putJ(jResp,j);
        invoiceDate := CkJsonObject__stringOf(jResp,'content[i].invoices[j].invoiceDate');
        number_str := CkJsonObject__stringOf(jResp,'content[i].invoices[j].number');
        status := CkJsonObject__stringOf(jResp,'content[i].invoices[j].status');
        statusDescription := CkJsonObject__stringOf(jResp,'content[i].invoices[j].statusDescription');
        j := j + 1;
      end;

    i := i + 1;
  end;

CkHttp_Dispose(http);
CkStringBuilder_Dispose(sbResponseBody);
CkJsonObject_Dispose(jResp);

end;