(Excel) CardConnect Authorization

Demonstrates how to send an Authorization request.

Authorization is the initial step in accepting payment from a cardholder. This action "authorizes" or requests permission from the bank to transfer money from the cardholder to the merchant.

See https://developer.cardconnect.com/cardconnect-api#authorization

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:

' Note: The CardConnect online documentation might use an expiry that is in the past, such as "1218".
' This causes the request to fail.  Use a month/year that is in the future..
' (Likewise, this example will have an invalid month/year after Dec 2021)

' {
'   "merchid": "MERCHANT_ID",
'   "accttype": "VISA",
'   "orderid": "AB-11-9876",
'   "account": "4111111111111111",
'   "expiry": "1221",
'   "amount": "0",
'   "currency": "USD",
'   "name": "TOM JONES",
'   "address": "123 MAIN STREET",
'   "city": "anytown",
'   "region": "NY",
'   "country": "US",
'   "postal": "55555",
'   "profile": "Y",
'   "ecomind": "E",
'   "cvv2": "123",
'   "track": null,
'   "capture": "Y"
' }

' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("merchid","MERCHANT_ID")
success = json.UpdateString("accttype","VISA")
success = json.UpdateString("orderid","AB-11-9876")
success = json.UpdateString("account","4111111111111111")
success = json.UpdateString("expiry","1221")
success = json.UpdateString("amount","20")
success = json.UpdateString("currency","USD")
success = json.UpdateString("name","TOM JONES")
success = json.UpdateString("address","123 MAIN STREET")
success = json.UpdateString("city","anytown")
success = json.UpdateString("region","NY")
success = json.UpdateString("country","US")
success = json.UpdateString("postal","55555")
success = json.UpdateString("profile","Y")
success = json.UpdateString("ecomind","E")
success = json.UpdateString("cvv2","123")
success = json.UpdateNull("track")
success = json.UpdateString("capture","Y")


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

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

' Sample error:

' {
'   "respproc": "PPS",
'   "amount": "0.00",
'   "resptext": "Invalid amount",
'   "cardproc": "FNOR",
'   "acctid": "1",
'   "retref": "112804260418",
'   "respstat": "C",
'   "respcode": "43",
'   "account": "41XXXXXXXXXX1111",
'   "defaultacct": "Y",
'   "merchid": "MERCHANT_ID",
'   "token": "9418594164541111"
' }

' A successful response looks like this:

' {
'   "amount": "0.20",
'   "resptext": "Approval",
'   "acctid": "1",
'   "commcard": " C ",
'   "cvvresp": "M",
'   "respcode": "00",
'   "batchid": "1900942291",
'   "avsresp": "Z",
'   "entrymode": "ECommerce",
'   "defaultacct": "Y",
'   "merchid": "MERCHANT_ID",
'   "token": "9418594164541111",
'   "authcode": "PPS158",
'   "respproc": "FNOR",
'   "bintype": "",
'   "profileid": "16618402968441604028",
'   "retref": "112989260941",
'   "respstat": "A",
'   "account": "41XXXXXXXXXX1111"
' }

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


amount = jsonResp.StringOf("amount")

resptext = jsonResp.StringOf("resptext")

acctid = jsonResp.StringOf("acctid")

commcard = jsonResp.StringOf("commcard")

cvvresp = jsonResp.StringOf("cvvresp")

respcode = jsonResp.StringOf("respcode")

batchid = jsonResp.StringOf("batchid")

avsresp = jsonResp.StringOf("avsresp")

entrymode = jsonResp.StringOf("entrymode")

defaultacct = jsonResp.StringOf("defaultacct")

merchid = jsonResp.StringOf("merchid")

token = jsonResp.StringOf("token")

authcode = jsonResp.StringOf("authcode")

respproc = jsonResp.StringOf("respproc")

bintype = jsonResp.StringOf("bintype")

profileid = jsonResp.StringOf("profileid")

retref = jsonResp.StringOf("retref")

respstat = jsonResp.StringOf("respstat")

account = jsonResp.StringOf("account")