DataFlex

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

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoJson
    Boolean iSuccess
    String sTemp1

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

    Get Create (RefClass(cComChilkatJsonObject)) To hoJson
    If (Not(IsComObjectCreated(hoJson))) Begin
        Send CreateComObject of hoJson
    End
    Get ComLoadFile Of hoJson "qa_data/json/rsi.json" To iSuccess

    Get ComStringOf Of hoJson '"Technical Analysis: RSI"."2017-07-28 09:30".RSI' To sTemp1
    Showln "RSI: " sTemp1

    // output is 38.6964


End_Procedure