VB.NET

JSON: Array of Objects

See more JSON Examples

Here we have a JSON object that contains an array, where each element in the array is a JSON object. This example demonstrates how to access the objects contained within an array.

{ 
  "employees":[
    {"firstName":"John", "lastName":"Doe"},
    {"firstName":"Anna", "lastName":"Smith"},
    {"firstName":"Peter","lastName":"Jones"}
  ]
}

VB.NET

Dim success As Boolean = False

Dim json As New Chilkat.JsonObject

' 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 = "{""employees"":[{""firstName"":""John"", ""lastName"":""Doe""},{""firstName"":""Anna"", ""lastName"":""Smith""},{""firstName"":""Peter"",""lastName"":""Jones""}]}"

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


' Get the "employees" array.
Dim employees As Chilkat.JsonArray = json.ArrayOf("employees")
If (json.LastMethodSuccess = False) Then
    Debug.WriteLine("employees member not found.")
    Exit Sub
End If


' Iterate over each employee, getting the JSON object at each index.
Dim numEmployees As Integer = employees.Size
Dim i As Integer = 0
While i < numEmployees

    Dim empObj As Chilkat.JsonObject = employees.ObjectAt(i)

    Debug.WriteLine("employee[" & i & "] = " & empObj.StringOf("firstName") & " " & empObj.StringOf("lastName"))


    i = i + 1
End While