Visual FoxPro

Isabel Connect Get Account

See more Ibanity Examples

Get the details for a specific account. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loCert
LOCAL loPrivKey
LOCAL loJsonToken
LOCAL lcJsonStr
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcDataAttributesCountry
LOCAL lcDataAttributesCurrency
LOCAL lcDataAttributesDescription
LOCAL lcDataAttributesFinancialInstitutionBic
LOCAL lcDataAttributesHolderAddress
LOCAL lcDataAttributesHolderAddressCountry
LOCAL lcDataAttributesHolderName
LOCAL lcDataAttributesReference
LOCAL lcDataAttributesReferenceType
LOCAL lcDataId
LOCAL lcDataType

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 \
* --cert certificate.pem:qwertyuiop1 \
* --key private_key.pem  \
* -H "Authorization: Bearer access_token_1603365407" \
* -H "Accept: application/vnd.api+json"  

* Other Chilkat examples for Ibanity show how to set the SSL client certificate using the .pfx.
* This example will demonstrate using the PEM files.
loCert = CreateObject('Chilkat.Cert')
lnSuccess = loCert.LoadFromFile("qa_data/pem/my_ibanity_certificate.pem")
IF (lnSuccess = 0) THEN
    ? loCert.LastErrorText
    RELEASE loHttp
    RELEASE loCert
    CANCEL
ENDIF

loPrivKey = CreateObject('Chilkat.PrivateKey')
lnSuccess = loPrivKey.LoadEncryptedPemFile("qa_data/pem/my_ibanity_private_key.pem","my_pem_password")
IF (lnSuccess = 0) THEN
    ? loPrivKey.LastErrorText
    RELEASE loHttp
    RELEASE loCert
    RELEASE loPrivKey
    CANCEL
ENDIF

lnSuccess = loCert.SetPrivateKey(loPrivKey)
IF (lnSuccess = 0) THEN
    ? loCert.LastErrorText
    RELEASE loHttp
    RELEASE loCert
    RELEASE loPrivKey
    CANCEL
ENDIF

lnSuccess = loHttp.SetSslClientCert(loCert)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loCert
    RELEASE loPrivKey
    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 loCert
    RELEASE loPrivKey
    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}")
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loCert
    RELEASE loPrivKey
    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 loCert
    RELEASE loPrivKey
    RELEASE loJsonToken
    RELEASE loJResp
    CANCEL
ENDIF

* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)

* {
*   "data": {
*     "attributes": {
*       "country": "BE",
*       "currency": "EUR",
*       "description": "current account",
*       "financialInstitutionBic": "KREDBEBB",
*       "holderAddress": "STREET NUMBER, ZIPCODE CITY",
*       "holderAddressCountry": "BE",
*       "holderName": "COMPANY",
*       "reference": "BE96153112434405",
*       "referenceType": "IBAN"
*     },
*     "id": "93ecb1fdbfb7848e7b7896c0f2d207aed3d8b4c1",
*     "type": "account"
*   }
* }

* Sample code for parsing the JSON response...
* Use the following online tool to generate parsing code from sample JSON:
* Generate Parsing Code from JSON

lcDataAttributesCountry = loJResp.StringOf("data.attributes.country")
lcDataAttributesCurrency = loJResp.StringOf("data.attributes.currency")
lcDataAttributesDescription = loJResp.StringOf("data.attributes.description")
lcDataAttributesFinancialInstitutionBic = loJResp.StringOf("data.attributes.financialInstitutionBic")
lcDataAttributesHolderAddress = loJResp.StringOf("data.attributes.holderAddress")
lcDataAttributesHolderAddressCountry = loJResp.StringOf("data.attributes.holderAddressCountry")
lcDataAttributesHolderName = loJResp.StringOf("data.attributes.holderName")
lcDataAttributesReference = loJResp.StringOf("data.attributes.reference")
lcDataAttributesReferenceType = loJResp.StringOf("data.attributes.referenceType")
lcDataId = loJResp.StringOf("data.id")
lcDataType = loJResp.StringOf("data.type")

RELEASE loHttp
RELEASE loCert
RELEASE loPrivKey
RELEASE loJsonToken
RELEASE loJResp