(Excel) Adyen Verify Payment Result

Once a payment has completed, this verifies the result from your server with a /payments/result request.

For more information, see https://docs.adyen.com/checkout/web-sdk/#step-3-verify-payment-result

Download Excel Class Modules Chilkat Excel Class Modules

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

' Use this online tool to generate the code from sample JSON:
' Generate Code to Create JSON

' The following JSON is sent in the request body.

' {
'   "payload": "2he28Ddhwj242he28Ddhwj..."
' }
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("payload","2he28Ddhwj242he28Ddhwj...")

http.SetRequestHeader "X-API-Key","Your_API_key"


Set resp = http.PostJson3("https://checkout-test.adyen.com/v41/payments/result","application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False


respStatusCode = resp.StatusCode
Debug.Print "Status Code = "; respStatusCode
Debug.Print "Response Body:"
Debug.Print jResp.Emit()

If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:

' {
'   "pspReference": "851559480052382F",
'   "resultCode": "Authorised",
'   "merchantReference": "123",
'   "paymentMethod": "ideal",
'   "shopperLocale": "nl_NL"
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON

pspReference = jResp.StringOf("pspReference")
resultCode = jResp.StringOf("resultCode")
merchantReference = jResp.StringOf("merchantReference")
paymentMethod = jResp.StringOf("paymentMethod")
shopperLocale = jResp.StringOf("shopperLocale")