(Excel) Load JSON Array from HTTP Response Body

Demonstrates how to load the HTTP response body directly into a JsonArray.

Note: This example requires Chilkat v9.5.0.89 or greater because it uses the GetBodyJarr method. Prior to v9.5.0.89, and application would need to first copy the HTTP response body to a Chilkat StringBuilder object by calling GetBodySb, and then load the JsonArray by calling JsonArray.LoadSb.

Download Excel Class Modules Chilkat Excel Class Modules

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


Set resp = http.PText("GET","https://www.chilkatsoft.com/exampledata/sampleArray.json","","","",False,False)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A JSON array is JSON that begins with "[" and ends with "]"
Dim jarr As Chilkat.JsonArray
Set jarr = Chilkat.NewJsonArray

' If we wish to transfer (instead of copy) the JSON from the HttpResponse to the JsonArray, then add the keyword "TakeResponseBody" to UncommonOptions
' This could save memory for extremely large JSON responses.
resp.UncommonOptions = "TakeResponseBody"

Dim success As Boolean
success = resp.GetBodyJarr(jarr)

Debug.Print jarr.Emit()

' Note: If UncommonOptions contained "TakeResponseBody", then the response BodyStr will now be empty:
Debug.Print "----"
Debug.Print resp.BodyStr