(Classic ASP) Refinitiv World-Check One - Get Top Level Groups

See more Refinitiv Examples

Sends a signed GET request to get the top level groups.

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

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("Chilkat.JsonObject")

' 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"
'   ]
' }

' Substitute your actual API key and API secret in place of "api-key" and "api-secret"
success = json.UpdateString("keyId","api-key")
success = json.UpdateString("hmacKey","api-secret")
success = json.UpdateString("algorithm","hmac-sha256")
' Indicate the names of the headers to be included in the signature.
' "(request-target)" is not actually a header name, but is a special name for HTTP signatures.
' Copy the following three lines of code exactly as-is.  
' Do not replace "host", "date", or "(request-target)" with values.
success = json.UpdateString("headers[0]","(request-target)")
success = json.UpdateString("headers[1]","host")
success = json.UpdateString("headers[2]","date")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = Server.CreateObject("Chilkat.Http")

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

http.SetRequestHeader "Cache-Control","no-cache"

' Chilkat will auto-add the Date header because it's needed by the HTTP Signature.

responseJson = http.QuickGetStr("https://api-worldcheck.refinitiv.com/v2/groups")
If (http.LastMethodSuccess = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
    Response.End
End If

Response.Write "<pre>" & Server.HTMLEncode( responseJson) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( "----") & "</pre>"
' A 200 status code indicates success.
Response.Write "<pre>" & Server.HTMLEncode( "Status code = " & http.LastStatus) & "</pre>"

' Successful JSON looks like this:
' [ 
'   {
'   "id": "...",
'   "name": "Company Name",
'   "parentId": null,
'   "hasChildren": false,
'   "status": "ACTIVE",
'   "children": []
'   }
' ]

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonArray")
set jarr = Server.CreateObject("Chilkat.JsonArray")

success = jarr.Load(responseJson)

i = 0
count_i = jarr.Size
Do While i < count_i
    ' jsonObj is a Chilkat.JsonObject
    Set jsonObj = jarr.ObjectAt(i)
    id = jsonObj.StringOf("id")
    name = jsonObj.StringOf("name")
    parentId = jsonObj.StringOf("parentId")
    hasChildren = jsonObj.BoolOf("hasChildren")
    status = jsonObj.StringOf("status")
    j = 0
    count_j = jsonObj.SizeOfArray("children")
    Do While j < count_j
        jsonObj.J = j
        j = j + 1
    Loop

    i = i + 1
Loop

%>
</body>
</html>