(Excel) CardConnect Create Profile

Demonstrates how to create a profile.

A PUT call to the profile endpoint creates a new profile or adds a new account to an existing profile. ...

See https://developer.cardconnect.com/cardconnect-api?lang=json#create-update-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"

' Build and send the following JSON:

' {
'   "region": "AK",
'   "phone": "7778789999",
'   "accttype": "VISA",
'   "postal": "19090",
'   "ssnl4": "3655",
'   "expiry": "0214",
'   "city": "ANYTOWN",
'   "country": "US",
'   "address": "123 MAIN STREET",
'   "merchid": "496400000840",
'   "name": "TOM JONES",
'   "account": "4444333322221111",
'   "license": "123451254",
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("region","AK")
success = json.UpdateString("phone","7778789999")
success = json.UpdateString("accttype","VISA")
success = json.UpdateString("postal","19090")
success = json.UpdateString("ssnl4","3655")
success = json.UpdateString("expiry","0214")
success = json.UpdateString("city","ANYTOWN")
success = json.UpdateString("country","US")
success = json.UpdateString("address","123 MAIN STREET")
success = json.UpdateString("merchid","MERCHANT_ID")
success = json.UpdateString("name","TOM JONES")
success = json.UpdateString("account","4444333322221111")
success = json.UpdateString("license","123451254")


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

responseStr = http.PutText(url,json.Emit(),"utf-8","application/json",False,False)
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",
'   "address": "123 MAIN STREET",
'   "resptext": "Profile Saved",
'   "city": "ANYTOWN",
'   "acctid": "1",
'   "respcode": "09",
'   "defaultacct": "Y",
'   "accttype": "VISA",
'   "token": "9441149619831111",
'   "license": "123451254",
'   "respproc": "PPS",
'   "phone": "7778789999",
'   "profileid": "16392957457306633141",
'   "name": "TOM JONES",
'   "auoptout": "N",
'   "postal": "19090",
'   "expiry": "0214",
'   "region": "AK",
'   "ssnl4": "3655",
'   "respstat": "A"
' }

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


country = jsonResp.StringOf("country")

address = jsonResp.StringOf("address")

resptext = jsonResp.StringOf("resptext")

city = jsonResp.StringOf("city")

acctid = jsonResp.StringOf("acctid")

respcode = jsonResp.StringOf("respcode")

defaultacct = jsonResp.StringOf("defaultacct")

accttype = jsonResp.StringOf("accttype")

token = jsonResp.StringOf("token")

license = jsonResp.StringOf("license")

respproc = jsonResp.StringOf("respproc")

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")

respstat = jsonResp.StringOf("respstat")