(Excel) Refinitiv World-Check One - Synchronous Screening (POST)

See more Refinitiv Examples

Sends a signed POST request to do simple synchronous screening.

Note: This example requires Chilkat v9.5.0.89 or later.

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 json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

' Create the following JSON:
' 
' {
'   "keyId": "aaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee",
'   "hmacKey": "xxxxzI3vi58xxxCBxxx1+P/d8tGxx7KuLqN/KMPNxxxxekhj8/bx83+1YQSUxxxxYyv939ceY06GvhYRKmxxxx==",
'   "algorithm": "hmac-sha256",
'   "headers": [
'     "(request-target)",
'     "host",
'     "date",
'     "content-type",
'     "content-length"
'   ]
' }

' Substitute your actual API key and API secret in place of "api-key" and "api-secret"
Dim success As Boolean
success = json.UpdateString("keyId","api-key")
success = json.UpdateString("hmacKey","api-secret")
success = json.UpdateString("algorithm","hmac-sha256")
success = json.UpdateString("headers[0]","(request-target)")
success = json.UpdateString("headers[1]","host")
success = json.UpdateString("headers[2]","date")
success = json.UpdateString("headers[3]","content-type")
success = json.UpdateString("headers[4]","content-length")

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

' Setting the AuthSignature property causes the following header to be computed and added:
' Authorization: Signature keyId="...", algorithm="hmac-sha256", headers="(request-target) host date content-type content-length", signature="..."
http.AuthSignature = json.Emit()

' Build the following JSON to be sent in the POST request body.

' {
'     "groupId": "{{group-id}}",
'     "entityType": "ORGANISATION",
'     "caseId": "",
'     "providerTypes": [
'         "WATCHLIST"
'     ],
'     "name": "COMPANY NAME",
'     "nameTransposition": false,
'     "secondaryFields": [],
'     "customFields": []
' }

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

Dim jsonBody As Chilkat.JsonObject
Set jsonBody = Chilkat.NewJsonObject
success = jsonBody.UpdateString("groupId","{{group-id}}")
success = jsonBody.UpdateString("entityType","ORGANISATION")
success = jsonBody.UpdateString("caseId","")
success = jsonBody.UpdateString("providerTypes[0]","WATCHLIST")
success = jsonBody.UpdateString("name","COMPANY NAME")
success = jsonBody.UpdateBool("nameTransposition",False)
success = jsonBody.UpdateNewArray("secondaryFields")
success = jsonBody.UpdateNewArray("customFields")


Set resp = http.PostJson3("https://api-worldcheck.refinitiv.com/v2/cases/screeningRequest","application/json",jsonBody)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; resp.StatusCode

Dim jsonResp As Chilkat.JsonObject
Set jsonResp = Chilkat.NewJsonObject
success = jsonResp.Load(resp.BodyStr)

jsonResp.EmitCompact = False
Debug.Print jsonResp.Emit()

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