PowerBuilder

JSON Paths that need Double Quotes

See more JSON Examples

This example explains and demonstrates the situations where parts within a JSON path need to be enclosed in double-quotes. PowerBuilder

integer li_rc
oleobject loo_Json

//  Imagine we have the following JSON:

//  	{ 
//  	  "Meta Data": { 
//  	    "1: Symbol": "MSFT",
//  	    "2: Indicator": "Relative Strength Index (RSI)",
//  	    "3: Last Refreshed": "2017-07-28 09:30:00",
//  	    "4: Interval": "15min",
//  	    "5: Time Period": 10,
//  	    "6: Series Type": "close",
//  	    "7: Time Zone": "US/Eastern Time"
//  	  },
//  	  "Technical Analysis: RSI": { 
//  	    "2017-07-28 09:30": { 
//  	      "RSI": "38.6964"
//  	    },
//  	    "2017-07-27 16:00": { 
//  	      "RSI": "50.0088"
//  	    } 
//  	} 

//  The path to the RSI valud 38.6964 is Technical Analysis: RSI.2017-07-28 09:30.RSI

//  Whenever a path part contains a SPACE or "." char, that part must be enclosed
//  in double quotes.  For example:

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
loo_Json.LoadFile("qa_data/json/rsi.json")

Write-Debug "RSI: " + loo_Json.StringOf("~"Technical Analysis: RSI~".~"2017-07-28 09:30~".RSI")

//  output is 38.6964


destroy loo_Json