(Excel) CardConnect Inquire

Demonstrates how to get information for an individual transaction, including its settlement status (setlstat) and the response codes from the initial authorization.

See https://developer.cardconnect.com/cardconnect-api?lang=json#inquire

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/inquire/<retref>/<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:

' {
'   "amount": "0.00",
'   "resptext": "Approval",
'   "setlstat": "Voided",
'   "capturedate": "20190422180044",
'   "acctid": "1",
'   "respcode": "00",
'   "entrymode": "ECommerce",
'   "merchid": "MERCHANT_ID",
'   "token": "9418594164541111",
'   "authcode": "PPS158",
'   "respproc": "FNOR",
'   "authdate": "20190422",
'   "bintype": "",
'   "profileid": "16618402968441604028",
'   "lastfour": "1111",
'   "name": "TOM JONES",
'   "currency": "USD",
'   "retref": "112989260941",
'   "respstat": "A",
'   "account": "9418594164541111"
' }

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


amount = jsonResp.StringOf("amount")

resptext = jsonResp.StringOf("resptext")

setlstat = jsonResp.StringOf("setlstat")

capturedate = jsonResp.StringOf("capturedate")

acctid = jsonResp.StringOf("acctid")

respcode = jsonResp.StringOf("respcode")

entrymode = jsonResp.StringOf("entrymode")

merchid = jsonResp.StringOf("merchid")

token = jsonResp.StringOf("token")

authcode = jsonResp.StringOf("authcode")

respproc = jsonResp.StringOf("respproc")

authdate = jsonResp.StringOf("authdate")

bintype = jsonResp.StringOf("bintype")

profileid = jsonResp.StringOf("profileid")

lastfour = jsonResp.StringOf("lastfour")

name = jsonResp.StringOf("name")

currency = jsonResp.StringOf("currency")

retref = jsonResp.StringOf("retref")

respstat = jsonResp.StringOf("respstat")

account = jsonResp.StringOf("account")