(PowerBuilder) Get the Root of a JSON Document

Demonstrates how to get back to the JSON root object from anywhere in the JSON document. This example uses the following JSON document:

{
  "flower": "tulip",
  "abc":
    {
    "x": [
       { "a" : 1 },
       { "b1" : 100, "b2" : 200 },
       { "c" : 3 }
    ],
    "y": 200,
    "z": 200
    }
}

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

integer li_rc
oleobject loo_Json
string ls_JsonStr
integer li_Success
oleobject loo_AbcObj
oleobject loo_XArray
oleobject loo_BObj
oleobject loo_DocRoot

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
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

ls_JsonStr = "{~"flower~": ~"tulip~",~"abc~":{~"x~": [{ ~"a~" : 1 },{ ~"b1~" : 100, ~"b2~" : 200 },{ ~"c~" : 3 }],~"y~": 200,~"z~": 200}}"

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 "abc" object.
loo_AbcObj = loo_Json.ObjectOf("abc")
if loo_Json.LastMethodSuccess = 0 then
    Write-Debug "abc object not found."
    destroy loo_Json
    return
end if

// Side note: The JSON of a sub-part of the document can be emitted from any JSON object:
loo_AbcObj.EmitCompact = 0
Write-Debug loo_AbcObj.Emit()

// Navigate to the "x" array
loo_XArray = loo_AbcObj.ArrayOf("x")
// We'll skip the null check and assume it's non-null...

// Navigate to the 2nd object contained within the array.  This contains members b1 and b2
loo_BObj = loo_XArray.ObjectAt(1)
// We'll skip the null check and assume it's non-null...

// Show that we're at "b1/b2".
// The value of "b1" should be "200"
Write-Debug "b2 = " + string(loo_BObj.IntOf("b2"))

// Now go back to the JSON doc root:
loo_DocRoot = loo_BObj.GetDocRoot()
// We'll skip the null check and assume it's non-null...

// Pretty-print the JSON doc from the root to show that this is indeed the root.
loo_DocRoot.EmitCompact = 0
Write-Debug loo_DocRoot.Emit()

destroy loo_DocRoot
destroy loo_BObj
destroy loo_XArray
destroy loo_AbcObj


destroy loo_Json