(Excel) Refinitiv World-Check One - Unarchive Case (DEL)

See more Refinitiv Examples

Sends a signed DELETE request to unarchive a case.

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

' Substitute your actual API key and API secret in place of "api-key" and "api-secret"
' Note: This particular API call is a DELETE with an empty request body.
' Because the request body is empty, we don't include the content-type and content-length headers.
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")

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", signature="..."
http.AuthSignature = json.Emit()


Set resp = http.PText("DELETE","https://api-worldcheck.refinitiv.com/v2/cases/{{case-system-id}}/archive","","","",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

' If successful, the response status code will equal 204, and the response body will be completely empty.