(Excel) VoiceBase -- Compound Expression Search

Demonstrates how to do a VoiceBase compound expression search. See VoiceBase Search for more details about Search.

Download Excel Class Modules Chilkat Excel Class Modules

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

' Insert your Bearer token here:

accessToken = "VOICEBASE_TOKEN"

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

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "GET"
req.Path = "/v2-beta/media"

' Add the access (bearer) token to the request, which is a header
' having the following format:
' Authorization: Bearer <userAccessToken>
Dim sbAuth As Chilkat.StringBuilder
Set sbAuth = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbAuth.Append("Bearer ")
success = sbAuth.Append(accessToken)
req.AddHeader "Authorization",sbAuth.GetAsString()

' Search for media containing the terms any of the terms "test", "number", or "three"
req.AddParam "query","""test"" OR ""number"" OR ""three"""


Set resp = http.SynchronousRequest("apis.voicebase.com",443,True,req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Examine the response status code and body.
Debug.Print "Response status code = "; resp.StatusCode

' The response should be JSON, even if an error.
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(resp.BodyStr)
json.EmitCompact = False

' A successful response will have a status code = 200
If (resp.StatusCode <> 200) Then
    Debug.Print "Failed."
Else
    Debug.Print "mediaId: "; json.StringOf("mediaId")
    Debug.Print "href: "; json.StringOf("_links.self.href")
    Debug.Print "status: "; json.StringOf("status")
    Debug.Print "Success."
End If

' See the sample JSON response below..

' Iterate over the JSON like this:
Dim dt As Chilkat.CkDateTime
Set dt = Chilkat.NewCkDateTime

mediaCount = json.SizeOfArray("media")

i = 0
Do While i < mediaCount
    json.I = i

    Debug.Print "-- "; i; " --"
    Debug.Print "  mediaId: "; json.StringOf("media[i].mediaId")
    Debug.Print "  status: "; json.StringOf("media[i].status")
    Debug.Print "  contentType: "; json.StringOf("media[i].metadata.contentType")
    Debug.Print "  milliseconds: "; json.StringOf("media[i].metadata.length.milliseconds")
    Debug.Print "  descriptive: "; json.StringOf("media[i].metadata.length.descriptive")

    dateCreated = json.StringOf("media[i].dateCreated")
    success = dt.SetFromTimestamp(dateCreated)


    localTime = True

    Set dtObj = dt.GetDtObj(localTime)
    Debug.Print "  "; dtObj.Month; "/"; dtObj.Day; "  "; dtObj.Hour; ":"; dtObj.Minute

    i = i + 1
Loop
Debug.Print "Finished."

' A sample JSON response:

' { 
'   "_links": { 
'     "self": { 
'       "href": "/v2-beta/media"
'     }
'   },
'   "media": [
'     { 
'       "mediaId": "26063536-FFFF-4020-93ba-0878112d834b",
'       "status": "finished",
'       "metadata": { 
'         "contentType": "audio/x-wav",
'         "length": { 
'           "milliseconds": 85141,
'           "descriptive": "85.0 sec"
'         }
'       },
'       "dateCreated": "2017-01-19T16:49:32.000Z"
'     },
'     { 
'       "mediaId": "8163fbbc-FFFF-4794-aa95-045420bb321d",
'       "status": "finished",
'       "metadata": { 
'         "contentType": "audio/x-wav",
'         "length": { 
'           "milliseconds": 65342,
'           "descriptive": "65.0 sec"
'         }
'       },
'       "dateCreated": "2017-01-19T20:08:49.000Z"
'     },
' ...
' ...
'     { 
'       "mediaId": "b01e27be-FFFF-4b62-8802-6dc66a75c4d3",
'       "status": "finished",
'       "metadata": { 
'         "contentType": "audio/x-wav",
'         "length": { 
'           "milliseconds": 11581,
'           "descriptive": "11.0 sec"
'         }
'       },
'       "dateCreated": "2017-02-06T20:55:43.000Z"
'     }
'   ]
' }