PureBasic

Isabel Connect List Transactions

See more Ibanity Examples

Get a list of transactions for an account. PureBasic

IncludeFile "CkJsonObject.pb"
IncludeFile "CkHttp.pb"

Procedure ChilkatExample()

    success.i = 0

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

    http.i = CkHttp::ckCreate()
    If http.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    ; 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 = CkHttp::ckSetSslClientCertPfx(http,"qa_data/pfx/my_ibanity_certificate.pfx","my_pfx_password")
    If success = 0
        Debug CkHttp::ckLastErrorText(http)
        CkHttp::ckDispose(http)
        ProcedureReturn
    EndIf

    ; Load the previously obtained access token.
    jsonToken.i = CkJsonObject::ckCreate()
    If jsonToken.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success = CkJsonObject::ckLoadFile(jsonToken,"qa_data/tokens/isabel_access_token.json")
    If success = 0
        Debug "No existing access token."
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(jsonToken)
        ProcedureReturn
    EndIf

    ; This causes the "Authorization: Bearer ***" header to be added to the HTTP request.
    CkHttp::setCkAuthToken(http, CkJsonObject::ckStringOf(jsonToken,"access_token"))

    CkHttp::setCkAccept(http, "application/vnd.api+json")

    CkHttp::ckSetUrlVar(http,"id","93ecb1fdbfb7848e7b7896c0f2d207aed3d8b4c1")
    jsonStr.s = CkHttp::ckQuickGetStr(http,"https://api.ibanity.com/isabel-connect/accounts/{$id}/transactions")
    If CkHttp::ckLastMethodSuccess(http) = 0
        Debug CkHttp::ckLastErrorText(http)
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(jsonToken)
        ProcedureReturn
    EndIf

    jResp.i = CkJsonObject::ckCreate()
    If jResp.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoad(jResp,jsonStr)
    CkJsonObject::setCkEmitCompact(jResp, 0)

    Debug "Response Body:"
    Debug CkJsonObject::ckEmit(jResp)

    respStatusCode.i = CkHttp::ckLastStatus(http)
    Debug "Response Status Code = " + Str(respStatusCode)
    If respStatusCode >= 400
        Debug "Response Header:"
        Debug CkHttp::ckLastResponseHeader(http)
        Debug "Failed."
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(jsonToken)
        CkJsonObject::ckDispose(jResp)
        ProcedureReturn
    EndIf

    ; 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

    attributesAmount.i
    attributesCounterpartAccountReference.s
    attributesCounterpartFinancialInstitutionBic.s
    attributesCounterpartName.s
    attributesEndToEndId.s
    attributesExecutionDate.s
    attributesInternalId.s
    attributesRemittanceInformation.s
    attributesRemittanceInformationType.s
    attributesStatus.s
    attributesValueDate.s
    id.s
    v_type.s

    metaPagingOffset.i = CkJsonObject::ckIntOf(jResp,"meta.paging.offset")
    metaPagingTotal.i = CkJsonObject::ckIntOf(jResp,"meta.paging.total")
    i.i = 0
    count_i.i = CkJsonObject::ckSizeOfArray(jResp,"data")
    While i < count_i
        CkJsonObject::setCkI(jResp, i)
        attributesAmount = CkJsonObject::ckIntOf(jResp,"data[i].attributes.amount")
        attributesCounterpartAccountReference = CkJsonObject::ckStringOf(jResp,"data[i].attributes.counterpartAccountReference")
        attributesCounterpartFinancialInstitutionBic = CkJsonObject::ckStringOf(jResp,"data[i].attributes.counterpartFinancialInstitutionBic")
        attributesCounterpartName = CkJsonObject::ckStringOf(jResp,"data[i].attributes.counterpartName")
        attributesEndToEndId = CkJsonObject::ckStringOf(jResp,"data[i].attributes.endToEndId")
        attributesExecutionDate = CkJsonObject::ckStringOf(jResp,"data[i].attributes.executionDate")
        attributesInternalId = CkJsonObject::ckStringOf(jResp,"data[i].attributes.internalId")
        attributesRemittanceInformation = CkJsonObject::ckStringOf(jResp,"data[i].attributes.remittanceInformation")
        attributesRemittanceInformationType = CkJsonObject::ckStringOf(jResp,"data[i].attributes.remittanceInformationType")
        attributesStatus = CkJsonObject::ckStringOf(jResp,"data[i].attributes.status")
        attributesValueDate = CkJsonObject::ckStringOf(jResp,"data[i].attributes.valueDate")
        id = CkJsonObject::ckStringOf(jResp,"data[i].id")
        v_type = CkJsonObject::ckStringOf(jResp,"data[i].type")
        i = i + 1
    Wend


    CkHttp::ckDispose(http)
    CkJsonObject::ckDispose(jsonToken)
    CkJsonObject::ckDispose(jResp)


    ProcedureReturn
EndProcedure