(Visual FoxPro) Isabel Connect Get Account

See more Ibanity Examples

Get the details for a specific account.

For more information, see https://documentation.ibanity.com/isabel-connect/api#get-account

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loHttp
LOCAL loCert
LOCAL lnSuccess
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

* 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 \
* --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.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Cert')
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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.PrivateKey')
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.
* 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 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

* 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 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