(Node.js) Isabel Connect List Transactions

See more Ibanity Examples

Get a list of transactions for an account.

For more information, see https://documentation.ibanity.com/isabel-connect/api#list-accounts

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

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

    var http = new chilkat.Http();

    // 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.)
    var success = http.SetSslClientCertPfx("qa_data/pfx/my_ibanity_certificate.pfx","my_pfx_password");
    if (success == false) {
        console.log(http.LastErrorText);
        return;
    }

    // Load the previously obtained access token.
    var jsonToken = new chilkat.JsonObject();
    success = jsonToken.LoadFile("qa_data/tokens/isabel_access_token.json");
    if (success == false) {
        console.log("No existing access token.");
        return;
    }

    // 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");
    var jsonStr = http.QuickGetStr("https://api.ibanity.com/isabel-connect/accounts/{$id}/transactions");
    if (http.LastMethodSuccess == false) {
        console.log(http.LastErrorText);
        return;
    }

    var jResp = new chilkat.JsonObject();
    jResp.Load(jsonStr);
    jResp.EmitCompact = false;

    console.log("Response Body:");
    console.log(jResp.Emit());

    var respStatusCode = http.LastStatus;
    console.log("Response Status Code = " + respStatusCode);
    if (respStatusCode >= 400) {
        console.log("Response Header:");
        console.log(http.LastResponseHeader);
        console.log("Failed.");
        return;
    }

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

    var attributesAmount;
    var attributesCounterpartAccountReference;
    var attributesCounterpartFinancialInstitutionBic;
    var attributesCounterpartName;
    var attributesEndToEndId;
    var attributesExecutionDate;
    var attributesInternalId;
    var attributesRemittanceInformation;
    var attributesRemittanceInformationType;
    var attributesStatus;
    var attributesValueDate;
    var id;
    var v_type;

    var metaPagingOffset = jResp.IntOf("meta.paging.offset");
    var metaPagingTotal = jResp.IntOf("meta.paging.total");
    var i = 0;
    var count_i = jResp.SizeOfArray("data");
    while (i < count_i) {
        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;
    }


}

chilkatExample();