(Classic ASP) JSON: Array of Objects

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

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = Server.CreateObject("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. 
jsonStr = "{""employees"":[{""firstName"":""John"", ""lastName"":""Doe""},{""firstName"":""Anna"", ""lastName"":""Smith""},{""firstName"":""Peter"",""lastName"":""Jones""}]}"

success = json.Load(jsonStr)
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( json.LastErrorText) & "</pre>"
    Response.End
End If

' Get the "employees" array.
' employees is a Chilkat.JsonArray
Set employees = json.ArrayOf("employees")
If (json.LastMethodSuccess = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( "employees member not found.") & "</pre>"
    Response.End
End If

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

    ' empObj is a Chilkat.JsonObject
    Set empObj = employees.ObjectAt(i)

    Response.Write "<pre>" & Server.HTMLEncode( "employee[" & i & "] = " & empObj.StringOf("firstName") & " " & empObj.StringOf("lastName")) & "</pre>"

    i = i + 1
Loop


%>
</body>
</html>