Visual Basic 6.0

Get the Index of a JSON Member

See more JSON Examples

This example demonstrates how to get the index of a given member by name.

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

Visual Basic 6.0

Dim success As Long
success = 0

Dim json As New ChilkatJsonObject

' 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. 
Dim jsonStr As String
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 = 0) Then
    Debug.Print json.LastErrorText
    Exit Sub
End If

' The top-level JSON object has three members: name, image, and thumbnail.
Dim nameIndex As Long
nameIndex = json.IndexOf("name")
' The index of the "name" member is 0.
Debug.Print "nameIndex = " & nameIndex

Dim thumbIndex As Long
thumbIndex = json.IndexOf("thumbnail")
' The index of the "thumbnail" member is 2.
Debug.Print "thumbIndex = " & thumbIndex

' The "fname" member is NOT a direct member of the top-level JSON object.
' It is a member of a nested object.  If we try to get the index of this
' member using the top-level JSON object, it is not found (and returns -1).
Dim fnameIndex As Long
fnameIndex = json.IndexOf("fname")
' The fnameIndex is -1 (not found).  This is correct.
Debug.Print "fnameIndex = " & fnameIndex

' Get the "image" object.
Dim imageObj As New ChilkatJsonObject
success = json.ObjectOf2("image",imageObj)

' Now we can get the index of the "fname" object, because it is a direct
' member of the "image" object:
fnameIndex = imageObj.IndexOf("fname")
Debug.Print "fnameIndex = " & fnameIndex