(PowerShell) 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 .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

$json = New-Object 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 -ne $true) {
    $($json.LastErrorText)
    exit
}

# Get the "employees" array.
$employees = $json.ArrayOf("employees")
if ($json.LastMethodSuccess -eq $false) {
    $("employees member not found.")
    exit
}

# Iterate over each employee, getting the JSON object at each index.
$numEmployees = $employees.Size
$i = 0
while ($i -lt $numEmployees) {

    $empObj = $employees.ObjectAt($i)

    $("employee[" + $i + "] = " + $empObj.StringOf("firstName") + " " + $empObj.StringOf("lastName"))

    $i = $i + 1
}