(PowerBuilder) Load a JSON Array

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.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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



// 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
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
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
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
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