PowerBuilder

Load a JSON Array

See more JSON Examples

The Chilkat JSON API requires the top-level JSON to be an object. Therefore, to load an array requires that it first be wrapped as an object. PowerBuilder

integer li_rc
integer li_Success
string ls_JsonArrayStr
oleobject loo_SbJson
oleobject loo_Json
oleobject loo_JArray
oleobject loo_JObjId

li_Success = 0

// Imagine we want to load this JSON array for parsing:
ls_JsonArrayStr = "[{~"id~":200},{~"id~":196}]"

// First wrap it in a JSON object by prepending "{ "array":" and appending "}"
loo_SbJson = create oleobject
li_rc = loo_SbJson.ConnectToNewObject("Chilkat.StringBuilder")
if li_rc < 0 then
    destroy loo_SbJson
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_SbJson.Append("{~"array~":")
loo_SbJson.Append(ls_JsonArrayStr)
loo_SbJson.Append("}")

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.Load(loo_SbJson.GetAsString())

// Now we can get the JSON array
loo_JArray = loo_Json.ArrayAt(0)

// Do what you want with the JSON array...
// For example:
loo_JObjId = loo_JArray.ObjectAt(0)
Write-Debug string(loo_JObjId.IntOf("id"))
destroy loo_JObjId

destroy loo_JArray


destroy loo_SbJson
destroy loo_Json