PureBasic

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. PureBasic

IncludeFile "CkJsonObject.pb"

Procedure ChilkatExample()

    ; 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:

    json.i = CkJsonObject::ckCreate()
    If json.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadFile(json,"qa_data/json/rsi.json")

    Debug "RSI: " + CkJsonObject::ckStringOf(json,Chr(34) + "Technical Analysis: RSI" + Chr(34) + "." + Chr(34) + "2017-07-28 09:30" + Chr(34) + ".RSI")

    ; output is 38.6964


    CkJsonObject::ckDispose(json)


    ProcedureReturn
EndProcedure