(MFC) 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

Chilkat C/C++ Library Downloads MS Visual C/C++ Libs

See Also: Using MFC CString in Chilkat

#include <CkHttp.h>
#include <CkJsonObject.h>

void ChilkatSample(void)
    {
    CkString strOut;

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

    CkHttp 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.)
    bool success = http.SetSslClientCertPfx("qa_data/pfx/my_ibanity_certificate.pfx","my_pfx_password");
    if (success == false) {
        strOut.append(http.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    // Load the previously obtained access token.
    CkJsonObject jsonToken;
    success = jsonToken.LoadFile("qa_data/tokens/isabel_access_token.json");
    if (success == false) {
        strOut.append("No existing access token.");
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    // This causes the "Authorization: Bearer ***" header to be added to the HTTP request.
    http.put_AuthToken(jsonToken.stringOf("access_token"));

    http.put_Accept("application/vnd.api+json");

    http.SetUrlVar("id","93ecb1fdbfb7848e7b7896c0f2d207aed3d8b4c1");
    const char *jsonStr = http.quickGetStr("https://api.ibanity.com/isabel-connect/accounts/{$id}/transactions");
    if (http.get_LastMethodSuccess() == false) {
        strOut.append(http.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    CkJsonObject jResp;
    jResp.Load(jsonStr);
    jResp.put_EmitCompact(false);

    strOut.append("Response Body:");
    strOut.append("\r\n");
    strOut.append(jResp.emit());
    strOut.append("\r\n");

    int respStatusCode = http.get_LastStatus();
    strOut.append("Response Status Code = ");
    strOut.appendInt(respStatusCode);
    strOut.append("\r\n");
    if (respStatusCode >= 400) {
        strOut.append("Response Header:");
        strOut.append("\r\n");
        strOut.append(http.lastResponseHeader());
        strOut.append("\r\n");
        strOut.append("Failed.");
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        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

    // Chilkat functions returning "const char *" return a pointer to temporary internal memory owned and managed by Chilkat.
    // See this example explaining how this memory should be used: const char * functions.

    int attributesAmount;
    const char *attributesCounterpartAccountReference = 0;
    const char *attributesCounterpartFinancialInstitutionBic = 0;
    const char *attributesCounterpartName = 0;
    const char *attributesEndToEndId = 0;
    const char *attributesExecutionDate = 0;
    const char *attributesInternalId = 0;
    const char *attributesRemittanceInformation = 0;
    const char *attributesRemittanceInformationType = 0;
    const char *attributesStatus = 0;
    const char *attributesValueDate = 0;
    const char *id = 0;
    const char *v_type = 0;

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



    SetDlgItemText(IDC_EDIT1,strOut.getUnicode());

    }