VBScript

Get the Root of a JSON Document

See more JSON Examples

Demonstrates how to get back to the JSON root object from anywhere in the JSON document. This example uses the following JSON document:

{
  "flower": "tulip",
  "abc":
    {
    "x": [
       { "a" : 1 },
       { "b1" : 100, "b2" : 200 },
       { "c" : 3 }
    ],
    "y": 200,
    "z": 200
    }
}

VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

set json = CreateObject("Chilkat.JsonObject")

jsonStr = "{""flower"": ""tulip"",""abc"":{""x"": [{ ""a"" : 1 },{ ""b1"" : 100, ""b2"" : 200 },{ ""c"" : 3 }],""y"": 200,""z"": 200}}"

success = json.Load(jsonStr)
If (success = 0) Then
    outFile.WriteLine(json.LastErrorText)
    WScript.Quit
End If

' Get the "abc" object.
set abcObj = CreateObject("Chilkat.JsonObject")
success = json.ObjectOf2("abc",abcObj)
If (success = 0) Then
    outFile.WriteLine(json.LastErrorText)
    WScript.Quit
End If

' Side note: The JSON of a sub-part of the document can be emitted from any JSON object:
abcObj.EmitCompact = 0
outFile.WriteLine(abcObj.Emit())

' Navigate to the "x" array
set xArray = CreateObject("Chilkat.JsonArray")
success = abcObj.ArrayOf2("x",xArray)

' Navigate to the 2nd object contained within the array.  This contains members b1 and b2
set bObj = CreateObject("Chilkat.JsonObject")
success = xArray.ObjectAt2(1,bObj)

' Show that we're at "b1/b2".
' The value of "b1" should be "200"
outFile.WriteLine("b2 = " & bObj.IntOf("b2"))

' Now go back to the JSON doc root:
set docRoot = CreateObject("Chilkat.JsonObject")
success = bObj.GetDocRoot2(docRoot)

' We'll skip the null check and assume it's non-null...

' Pretty-print the JSON doc from the root to show that this is indeed the root.
docRoot.EmitCompact = 0
outFile.WriteLine(docRoot.Emit())

outFile.Close