(Excel) VoiceBase -- Hello World (Get the Media Collection Listing)

This example serves to both verify that your Bearer Token is valid by retrieving JSON that contains information about your media collection.

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

' 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)
http.SetRequestHeader "Authorization",sbAuth.GetAsString()


strJson = http.QuickGetStr("https://apis.voicebase.com/v2-beta/media")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

Debug.Print "Response status code = "; http.LastStatus

If (http.LastStatus <> 200) Then
    Debug.Print json.Emit()
    Debug.Print "Failed"
    Exit Sub
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"
'     }
'   ]
' }