PowerBuilder

JSON: Renaming and Deleting Members

See more JSON Examples

Demonstrates renaming and deleting members. This example uses the following JSON document:

{
   "apple": "red",
   "lime": "green",
   "banana": "yellow",
   "broccoli": "green",
   "strawberry": "red"
}

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Json

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

li_Success = loo_Json.Load("{~"apple~": ~"red~",~"lime~": ~"green~",~"banana~": ~"yellow~",~"broccoli~": ~"green~",~"strawberry~": ~"red~"}")
if li_Success <> 1 then
    Write-Debug loo_Json.LastErrorText
    destroy loo_Json
    return
end if

// Rename "lime" to "lemon".
li_Success = loo_Json.Rename("lime","lemon")
// Change the color to yellow:
li_Success = loo_Json.SetStringOf("lemon","yellow")

// Rename by index.  Banana is at index 2 (apple is at index 0)
li_Success = loo_Json.RenameAt(2,"bartlett_pear")

// Delete broccoli by name
li_Success = loo_Json.Delete("broccoli")

// Delete apple by index.  Apple is at index 0.
li_Success = loo_Json.DeleteAt(0)

loo_Json.EmitCompact = 0
Write-Debug loo_Json.Emit()


destroy loo_Json