(Excel) Get the Root of a JSON Document

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
    }
}

Download Excel Class Modules Chilkat Excel Class Modules

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject


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


success = json.Load(jsonStr)
If (success <> True) Then
    Debug.Print json.LastErrorText
    Exit Sub
End If

' Get the "abc" object.

Set abcObj = json.ObjectOf("abc")
If (json.LastMethodSuccess = False) Then
    Debug.Print "abc object not found."
    Exit Sub
End If

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

' Navigate to the "x" array

Set xArray = abcObj.ArrayOf("x")
' We'll skip the null check and assume it's non-null...

' Navigate to the 2nd object contained within the array.  This contains members b1 and b2

Set bObj = xArray.ObjectAt(1)
' We'll skip the null check and assume it's non-null...

' Show that we're at "b1/b2".
' The value of "b1" should be "200"
Debug.Print "b2 = "; bObj.IntOf("b2")

' Now go back to the JSON doc root:

Set docRoot = bObj.GetDocRoot()
' 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 = False
Debug.Print docRoot.Emit()