Xojo Plugin

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.

Xojo Plugin

Dim success As Boolean
success = False

// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

Dim json As New 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")

Dim http As New 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.

Dim responseJson As String
responseJson = http.QuickGetStr("https://api-worldcheck.refinitiv.com/v2/groups")
If (http.LastMethodSuccess = False) Then
    System.DebugLog(http.LastErrorText)
    Return
End If

System.DebugLog(responseJson)
System.DebugLog("----")
// A 200 status code indicates success.
System.DebugLog("Status code = " + Str(http.LastStatus))

// 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

Dim jarr As New Chilkat.JsonArray

success = jarr.Load(responseJson)

Dim jsonObj As Chilkat.JsonObject
Dim id As String
Dim name As String
Dim parentId As String
Dim hasChildren As Boolean
Dim status As String
Dim j As Int32
Dim count_j As Int32

Dim i As Int32
i = 0
Dim count_i As Int32
count_i = jarr.Size
While i < count_i
    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")
    While j < count_j
        jsonObj.J = j
        j = j + 1
    Wend

    i = i + 1
Wend