(Excel) JSON: Nested Objects

Here we have a JSON object that contains nested JSON objects. This example demonstrates how to access the contents of the nested objects.

{
  "name": "donut",
  "image":
    {
    "fname": "donut.jpg",
    "w": 200,
    "h": 200
    },
  "thumbnail":
    {
    "fname": "donutThumb.jpg",
    "w": 32,
    "h": 32
    }
}

Download Excel Class Modules Chilkat Excel Class Modules

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

' This is the above JSON with whitespace chars removed (SPACE, TAB, CR, and LF chars).
' The presence of whitespace chars for pretty-printing makes no difference to the Load
' method. 

jsonStr = "{""name"": ""donut"",""image"":{""fname"": ""donut.jpg"",""w"": 200,""h"": 200},""thumbnail"":{""fname"": ""donutThumb.jpg"",""w"": 32,""h"": 32}}"


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

' Get the "image" object.

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

Debug.Print "image: fname="; imageObj.StringOf("fname"); ", width="; imageObj.IntOf("w"); ", height="; imageObj.IntOf("h")

' Get the "thumbnail" object.

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

Debug.Print "thumbnail: fname="; thumbObj.StringOf("fname"); ", width="; thumbObj.IntOf("w"); ", height="; thumbObj.IntOf("h")