PowerBuilder

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

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Json
string ls_JsonStr
oleobject loo_Employees
integer li_NumEmployees
integer i
oleobject loo_EmpObj

li_Success = 0

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")
if li_rc < 0 then
    destroy loo_Json
    MessageBox("Error","Connecting to COM object failed")
    return
end if

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

li_Success = loo_Json.Load(ls_JsonStr)
if li_Success <> 1 then
    Write-Debug loo_Json.LastErrorText
    destroy loo_Json
    return
end if

// Get the "employees" array.
loo_Employees = loo_Json.ArrayOf("employees")
if loo_Json.LastMethodSuccess = 0 then
    Write-Debug "employees member not found."
    destroy loo_Json
    return
end if

// Iterate over each employee, getting the JSON object at each index.
li_NumEmployees = loo_Employees.Size
i = 0
do while i < li_NumEmployees

    loo_EmpObj = loo_Employees.ObjectAt(i)

    Write-Debug "employee[" + string(i) + "] = " + loo_EmpObj.StringOf("firstName") + " " + loo_EmpObj.StringOf("lastName")
    destroy loo_EmpObj

    i = i + 1
loop

destroy loo_Employees


destroy loo_Json