Pascal (Lazarus/Delphi)

Isabel Connect List Transactions

See more Ibanity Examples

Get a list of transactions for an account. Pascal (Lazarus/Delphi)

program ChilkatDemo;

// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.

{$IFDEF FPC}
  {$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}

uses
  {$IFDEF UNIX}
  cthreads,
  {$ENDIF}
  SysUtils,
  CkDllLoader,
  Chilkat.JsonObject,
  Chilkat.Http;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  http: THttp;
  jsonToken: TJsonObject;
  jsonStr: string;
  jResp: TJsonObject;
  respStatusCode: Integer;
  attributesAmount: Integer;
  attributesCounterpartAccountReference: string;
  attributesCounterpartFinancialInstitutionBic: string;
  attributesCounterpartName: string;
  attributesEndToEndId: string;
  attributesExecutionDate: string;
  attributesInternalId: string;
  attributesRemittanceInformation: string;
  attributesRemittanceInformationType: string;
  attributesStatus: string;
  attributesValueDate: string;
  id: string;
  v_type: string;
  metaPagingOffset: Integer;
  metaPagingTotal: Integer;
  i: Integer;
  count_i: Integer;

begin
  success := False;

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

  http := THttp.Create;

  //  Implements the following CURL command:

  //  curl -X GET https://api.ibanity.com/isabel-connect/accounts/93ecb1fdbfb7848e7b7896c0f2d207aed3d8b4c1/transactions \
  //  --cert certificate.pem:qwertyuiop1 \
  //  --key private_key.pem  \
  //  -H "Authorization: Bearer access_token_1603365408" \
  //  -H "Accept: application/vnd.api+json"  

  //  Ibanity provides the certificate + private key in PFX format.  This example will use the .pfx instead of the pair of PEM files.
  //  (It is also possible to implement using Chilkat with the PEM files, but PFX is easier.)
  success := http.SetSslClientCertPfx('qa_data/pfx/my_ibanity_certificate.pfx','my_pfx_password');
  if (success = False) then
    begin
      WriteLn(http.LastErrorText);
      Exit;
    end;

  //  Load the previously obtained access token.
  jsonToken := TJsonObject.Create;
  success := jsonToken.LoadFile('qa_data/tokens/isabel_access_token.json');
  if (success = False) then
    begin
      WriteLn('No existing access token.');
      Exit;
    end;

  //  This causes the "Authorization: Bearer ***" header to be added to the HTTP request.
  http.AuthToken := jsonToken.StringOf('access_token');

  http.Accept := 'application/vnd.api+json';

  http.SetUrlVar('id','93ecb1fdbfb7848e7b7896c0f2d207aed3d8b4c1');
  jsonStr := http.QuickGetStr('https://api.ibanity.com/isabel-connect/accounts/{$id}/transactions');
  if (http.LastMethodSuccess = False) then
    begin
      WriteLn(http.LastErrorText);
      Exit;
    end;

  jResp := TJsonObject.Create;
  jResp.Load(jsonStr);
  jResp.EmitCompact := False;

  WriteLn('Response Body:');
  WriteLn(jResp.Emit());

  respStatusCode := http.LastStatus;
  WriteLn('Response Status Code = ' + respStatusCode);
  if (respStatusCode >= 400) then
    begin
      WriteLn('Response Header:');
      WriteLn(http.LastResponseHeader);
      WriteLn('Failed.');
      Exit;
    end;

  //  Sample JSON response:
  //  (Sample code for parsing the JSON response is shown below)

  //  {
  //    "data": [
  //      {
  //        "attributes": {
  //          "amount": 80000,
  //          "counterpartAccountReference": "BE21210123456703",
  //          "counterpartFinancialInstitutionBic": "GEBABEBB",
  //          "counterpartName": "MYBESTCLIENT",
  //          "endToEndId": "UNIQUE CODE CUSTOMER",
  //          "executionDate": "2018-10-15T08:34:17.417Z",
  //          "internalId": "UNIQUE CODE BANK",
  //          "remittanceInformation": "123456789002",
  //          "remittanceInformationType": "structured-be",
  //          "status": "Booked",
  //          "valueDate": "2018-10-15T08:52:43.962Z"
  //        },
  //        "id": "14e2bff5-e365-4bc7-bf48-76b7bcd464e9",
  //        "type": "transaction"
  //      },
  //      {
  //        "attributes": {
  //          "amount": 40000,
  //          "counterpartAccountReference": "BE58400101010179",
  //          "counterpartFinancialInstitutionBic": "KREDBEBB",
  //          "counterpartName": "MYGOODCLIENT",
  //          "endToEndId": null,
  //          "executionDate": "2018-10-15T08:34:17.417Z",
  //          "internalId": null,
  //          "remittanceInformation": "FREE COMMUNICATION",
  //          "remittanceInformationType": "unstructured",
  //          "status": "Booked",
  //          "valueDate": "2018-10-15T08:52:43.962Z"
  //        },
  //        "id": "29b0f52e-a389-4ff8-88e1-cc30c12b789f",
  //        "type": "transaction"
  //      },
  //      {
  //        "attributes": {
  //          "amount": -20000,
  //          "counterpartAccountReference": "BE56300694353788",
  //          "counterpartFinancialInstitutionBic": null,
  //          "counterpartName": "MY SUPPLIER",
  //          "endToEndId": null,
  //          "executionDate": "2018-10-15T08:34:17.417Z",
  //          "internalId": null,
  //          "remittanceInformation": "999000000171",
  //          "remittanceInformationType": "structured-be",
  //          "status": "Booked",
  //          "valueDate": "2018-10-15T08:52:43.962Z"
  //        },
  //        "id": "7d79a28e-b45d-4595-b98e-7c18871ee208",
  //        "type": "transaction"
  //      }
  //    ],
  //    "meta": {
  //      "paging": {
  //        "offset": 0,
  //        "total": 3
  //      }
  //    }
  //  }

  //  Sample code for parsing the JSON response...
  //  Use the following online tool to generate parsing code from sample JSON:
  //  Generate Parsing Code from JSON

  metaPagingOffset := jResp.IntOf('meta.paging.offset');
  metaPagingTotal := jResp.IntOf('meta.paging.total');
  i := 0;
  count_i := jResp.SizeOfArray('data');
  while i < count_i do
    begin
      jResp.I := i;
      attributesAmount := jResp.IntOf('data[i].attributes.amount');
      attributesCounterpartAccountReference := jResp.StringOf('data[i].attributes.counterpartAccountReference');
      attributesCounterpartFinancialInstitutionBic := jResp.StringOf('data[i].attributes.counterpartFinancialInstitutionBic');
      attributesCounterpartName := jResp.StringOf('data[i].attributes.counterpartName');
      attributesEndToEndId := jResp.StringOf('data[i].attributes.endToEndId');
      attributesExecutionDate := jResp.StringOf('data[i].attributes.executionDate');
      attributesInternalId := jResp.StringOf('data[i].attributes.internalId');
      attributesRemittanceInformation := jResp.StringOf('data[i].attributes.remittanceInformation');
      attributesRemittanceInformationType := jResp.StringOf('data[i].attributes.remittanceInformationType');
      attributesStatus := jResp.StringOf('data[i].attributes.status');
      attributesValueDate := jResp.StringOf('data[i].attributes.valueDate');
      id := jResp.StringOf('data[i].id');
      v_type := jResp.StringOf('data[i].type');
      i := i + 1;
    end;



  http.Free;
  jsonToken.Free;
  jResp.Free;

end;

// ---------------------------------------------------------------------------

begin

  try
    RunDemo;
  except
    on E: Exception do
      WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
  end;

  WriteLn;
  {$IFDEF MSWINDOWS}
  WriteLn('Press Enter to exit...');
  ReadLn;
  {$ENDIF}
end.