(Visual FoxPro) 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 ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJsonToken
LOCAL lcJsonStr
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lnAttributesAmount
LOCAL lcAttributesCounterpartAccountReference
LOCAL lcAttributesCounterpartFinancialInstitutionBic
LOCAL lcAttributesCounterpartName
LOCAL lcAttributesEndToEndId
LOCAL lcAttributesExecutionDate
LOCAL lcAttributesInternalId
LOCAL lcAttributesRemittanceInformation
LOCAL lcAttributesRemittanceInformationType
LOCAL lcAttributesStatus
LOCAL lcAttributesValueDate
LOCAL lcId
LOCAL lcV_type
LOCAL lnMetaPagingOffset
LOCAL lnMetaPagingTotal
LOCAL i
LOCAL lnCount_i

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('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.)
lnSuccess = loHttp.SetSslClientCertPfx("qa_data/pfx/my_ibanity_certificate.pfx","my_pfx_password")
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    CANCEL
ENDIF

* Load the previously obtained access token.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonToken = CreateObject('Chilkat.JsonObject')
lnSuccess = loJsonToken.LoadFile("qa_data/tokens/isabel_access_token.json")
IF (lnSuccess = 0) THEN
    ? "No existing access token."
    RELEASE loHttp
    RELEASE loJsonToken
    CANCEL
ENDIF

* This causes the "Authorization: Bearer ***" header to be added to the HTTP request.
loHttp.AuthToken = loJsonToken.StringOf("access_token")

loHttp.Accept = "application/vnd.api+json"

loHttp.SetUrlVar("id","93ecb1fdbfb7848e7b7896c0f2d207aed3d8b4c1")
lcJsonStr = loHttp.QuickGetStr("https://api.ibanity.com/isabel-connect/accounts/{$id}/transactions")
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJsonToken
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJResp = CreateObject('Chilkat.JsonObject')
loJResp.Load(lcJsonStr)
loJResp.EmitCompact = 0

? "Response Body:"
? loJResp.Emit()

lnRespStatusCode = loHttp.LastStatus
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loHttp.LastResponseHeader
    ? "Failed."
    RELEASE loHttp
    RELEASE loJsonToken
    RELEASE loJResp
    CANCEL
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

lnMetaPagingOffset = loJResp.IntOf("meta.paging.offset")
lnMetaPagingTotal = loJResp.IntOf("meta.paging.total")
i = 0
lnCount_i = loJResp.SizeOfArray("data")
DO WHILE i < lnCount_i
    loJResp.I = i
    lnAttributesAmount = loJResp.IntOf("data[i].attributes.amount")
    lcAttributesCounterpartAccountReference = loJResp.StringOf("data[i].attributes.counterpartAccountReference")
    lcAttributesCounterpartFinancialInstitutionBic = loJResp.StringOf("data[i].attributes.counterpartFinancialInstitutionBic")
    lcAttributesCounterpartName = loJResp.StringOf("data[i].attributes.counterpartName")
    lcAttributesEndToEndId = loJResp.StringOf("data[i].attributes.endToEndId")
    lcAttributesExecutionDate = loJResp.StringOf("data[i].attributes.executionDate")
    lcAttributesInternalId = loJResp.StringOf("data[i].attributes.internalId")
    lcAttributesRemittanceInformation = loJResp.StringOf("data[i].attributes.remittanceInformation")
    lcAttributesRemittanceInformationType = loJResp.StringOf("data[i].attributes.remittanceInformationType")
    lcAttributesStatus = loJResp.StringOf("data[i].attributes.status")
    lcAttributesValueDate = loJResp.StringOf("data[i].attributes.valueDate")
    lcId = loJResp.StringOf("data[i].id")
    lcV_type = loJResp.StringOf("data[i].type")
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loJsonToken
RELEASE loJResp