(VBScript) Understanding JSON Array vs JSON Object

This example explains the difference between a JSON Array and a JSON Object. A JSON Array begins with "[" and ends with "]", whereas a JSON Object begins with "{" and ends with "}".

Elements contained in a JSON array are accessed by index, whereas elements in a JSON object are typically accessed by name (but can also be accessed by index).

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

'  A JSON array should be loaded into a Chilkat JSON array,
'  whereas a JSON object should be loaded into a Chilkat JSON object.

'  A JSON array may contain objects, and a JSON object may contains arrays, but
'  it is the top-level (outermost) element that defines whether the JSON
'  document is an array or an object.
'  An array begins and ends with "[" ... "]"
'  An object begins and ends with "{" ... "}"

'  For example, an array containing 2 objects:
strJsonArray = "[ { ""name"": ""Bill"" }, { ""name"": ""Ted"" } ]"

'  Load it into a JSON array.
set jsonA = CreateObject("Chilkat_9_5_0.JsonArray")
success = jsonA.Load(strJsonArray)
outFile.WriteLine("number of array elements: " & jsonA.Size)

'  This is an object containing an array:
strJsonObj = "{ ""characters"": [ ""Bill"", ""Ted"" ] }"

'  Load it into a JSON object.
set jsonO = CreateObject("Chilkat_9_5_0.JsonObject")
success = jsonO.Load(strJsonObj)
outFile.WriteLine("number of object members: " & jsonO.Size)

outFile.Close