(Visual FoxPro) 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

LOCAL loJson
LOCAL lcJsonStr
LOCAL lnSuccess
LOCAL loEmployees
LOCAL lnNumEmployees
LOCAL i
LOCAL loEmpObj

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = 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. 
lcJsonStr = '{"employees":[{"firstName":"John", "lastName":"Doe"},{"firstName":"Anna", "lastName":"Smith"},{"firstName":"Peter","lastName":"Jones"}]}'

lnSuccess = loJson.Load(lcJsonStr)
IF (lnSuccess <> 1) THEN
    ? loJson.LastErrorText
    RELEASE loJson
    CANCEL
ENDIF

* Get the "employees" array.
loEmployees = loJson.ArrayOf("employees")
IF (loJson.LastMethodSuccess = 0) THEN
    ? "employees member not found."
    RELEASE loJson
    CANCEL
ENDIF

* Iterate over each employee, getting the JSON object at each index.
lnNumEmployees = loEmployees.Size
i = 0
DO WHILE i < lnNumEmployees

    loEmpObj = loEmployees.ObjectAt(i)

    ? "employee[" + STR(i) + "] = " + loEmpObj.StringOf("firstName") + " " + loEmpObj.StringOf("lastName")
    RELEASE loEmpObj

    i = i + 1
ENDDO

RELEASE loEmployees

RELEASE loJson