(Excel) CardConnect Get Profile

Demonstrates how to get a profile.

A GET request to the profile endpoint returns the stored data for the specified profile ID. ...

See https://developer.cardconnect.com/cardconnect-api?lang=json#get-profile-request

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.BasicAuth = True
http.Login = "API_USERNAME"
http.Password = "API_PASSWORD"


url = "https://<site>.cardconnect.com:<port>/cardconnect/rest/profile/<profile ID>/<account ID>/<merchid>"

responseStr = http.QuickGetStr(url)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A response status of 200 indicates potential success.  The JSON response body
' must be examined to determine if it was truly successful or an error.
Debug.Print "response status code = "; http.LastStatus

Dim jsonResp As Chilkat.JsonObject
Set jsonResp = Chilkat.NewJsonObject
success = jsonResp.Load(responseStr)
jsonResp.EmitCompact = False

Debug.Print "response JSON:"
Debug.Print jsonResp.Emit()

' A successful response looks like this:

' {
'   "country": "US",
'   "gsacard": "N",
'   "address": "123 MAIN STREET",
'   "city": "ANYTOWN",
'   "acctid": "1",
'   "defaultacct": "Y",
'   "accttype": "VISA",
'   "token": "9441149619831111",
'   "license": "123451254",
'   "phone": "7778789999",
'   "profileid": "16392957457306633141",
'   "name": "TOM JONES",
'   "auoptout": "N",
'   "postal": "19090",
'   "expiry": "0214",
'   "region": "AK",
'   "ssnl4": "3655"
' }

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON


country = jsonResp.StringOf("country")

gsacard = jsonResp.StringOf("gsacard")

address = jsonResp.StringOf("address")

city = jsonResp.StringOf("city")

acctid = jsonResp.StringOf("acctid")

defaultacct = jsonResp.StringOf("defaultacct")

accttype = jsonResp.StringOf("accttype")

token = jsonResp.StringOf("token")

license = jsonResp.StringOf("license")

phone = jsonResp.StringOf("phone")

profileid = jsonResp.StringOf("profileid")

name = jsonResp.StringOf("name")

auoptout = jsonResp.StringOf("auoptout")

postal = jsonResp.StringOf("postal")

expiry = jsonResp.StringOf("expiry")

region = jsonResp.StringOf("region")

ssnl4 = jsonResp.StringOf("ssnl4")