PowerShell

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

Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"

# 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 = New-Object Chilkat.JsonObject
$json.LoadFile("qa_data/json/rsi.json")

$("RSI: " + $json.StringOf("`"Technical Analysis: RSI`".`"2017-07-28 09:30`".RSI"))

# output is 38.6964