Visual FoxPro
Visual FoxPro
Isabel Connect List Transactions
See more Ibanity Examples
Get a list of transactions for an account.Chilkat Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loHttp
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
lnSuccess = 0
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
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.
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
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