AutoIt

JSON Paths

See more JSON Examples

Demonstrates using "Chilkat JSON Paths" to access parts of a JSON document, or to iterate over parts.

This example uses the following JSON document:

{
    "nestedArray" : [
			[
				[1,2,3],
				[4,5,6],
				[7,8,9,10]
			],
			[
				[11,12,13],
				[14,15,16],
				[17,18,19,20]
			],
			[
				[21,22,23],
				[24,25,26],
				[27,28,29,30],
				[31,32,33,34,35,36]
			]
		],

	"nestedObject" : {
		"aaa" : {
			"bb1" : {
				"cc1" : "c1Value",
				"cc2" : "c2Value",
				"cc3" : "c3Value"
			},
			"bb2" : {
				"dd1" : "d1Value",
				"dd2" : "d2Value",
				"dd3" : "d3Value"
			}
		}
	},

	"mixture" : {
		"arrayA" : [  
			{ "fruit": "apple", "animal": "horse", "job": "fireman", "colors": ["red","blue","green"] },
			{ "fruit": "pear", "animal": "plankton", "job": "waiter", "colors": ["yellow","orange","purple"] },
			{ "fruit": "kiwi", "animal": "echidna", "job": "astronaut", "colors": ["magenta","tan","pink"] }
			]
	},


        "name.with.dots" : { "grain" : "oats" }

	
}

AutoIt

Local $bSuccess = False

$oJson = ObjCreate("Chilkat.JsonObject")
$oJson.EmitCompact = False

; Assume the file contains the data as shown above..
$bSuccess = $oJson.LoadFile("qa_data/json/pathSample.json")
If ($bSuccess = False) Then
    ConsoleWrite($oJson.LastErrorText & @CRLF)
    Exit
EndIf

; First, let's get the value of "cc1"
; The path to this value is: nestedObject.aaa.bb1.cc1
ConsoleWrite($oJson.StringOf("nestedObject.aaa.bb1.cc1") & @CRLF)

; Now let's get number 18 from the nestedArray.
; It is located at nestedArray[1][2][1]
; (remember: Indexing is 0-based)
ConsoleWrite("This should be 18: " & $oJson.IntOf("nestedArray[1][2][1]") & @CRLF)

; We can do the same thing in a more roundabout way using the 
; I, J, and K properties.  (The I,J,K properties will be convenient
; for iterating over arrays, as we'll see later.)
$oJson.I = 1
$oJson.J = 2
$oJson.K = 1
ConsoleWrite("This should be 18: " & $oJson.IntOf("nestedArray[i][j][k]") & @CRLF)

; Let's iterate over the array containing the numbers 17, 18, 19, 20.
; First, use the SizeOfArray method to get the array size:
Local $iSz = $oJson.SizeOfArray("nestedArray[1][2]")
; The size should be 4.
ConsoleWrite("size of array = " & $iSz & " (should equal 4)" & @CRLF)

; Now iterate...
Local $i
For $i = 0 To $iSz - 1
    $oJson.I = $i
    ConsoleWrite($oJson.IntOf("nestedArray[1][2][i]") & @CRLF)
Next

; Let's use a triple-nested loop to iterate over the nestedArray:
Local $iJ
Local $iK

; szI should equal 1.
Local $iSzI = $oJson.SizeOfArray("nestedArray")
For $i = 0 To $iSzI - 1
    $oJson.I = $i

Local $iSzJ = $oJson.SizeOfArray("nestedArray[i]")
    For $iJ = 0 To $iSzJ - 1
        $oJson.J = $iJ

Local $iSzK = $oJson.SizeOfArray("nestedArray[i][j]")
        For $iK = 0 To $iSzK - 1
            $oJson.K = $iK

            ConsoleWrite($oJson.IntOf("nestedArray[i][j][k]") & @CRLF)
        Next
    Next
Next

; Now let's examine how to navigate to JSON objects contained within JSON arrays.
; This line of code gets the value "kiwi" contained within "mixture"
ConsoleWrite($oJson.StringOf("mixture.arrayA[2].fruit") & @CRLF)

; This line of code gets the color "yellow"
ConsoleWrite($oJson.StringOf("mixture.arrayA[1].colors[0]") & @CRLF)

; Getting an object at a path:
; This gets the 2nd object in "arrayA"

$oObj2 = ObjCreate("Chilkat.JsonObject")
$oJson.ObjectOf2("mixture.arrayA[1]",$oObj2)

; This object's "animal" should be "plankton"
ConsoleWrite($oObj2.StringOf("animal") & @CRLF)

; Note that paths are relative to the object, not the absolute root of the JSON document.
; Starting from obj2, "purple" is at "colors[2]"
ConsoleWrite($oObj2.StringOf("colors[2]") & @CRLF)

; Getting an array at a path:
; This gets the array containing the colors red, green, blue:

$oArr1 = ObjCreate("Chilkat.JsonArray")
$oJson.ArrayOf2("mixture.arrayA[0].colors",$oArr1)

Local $iSzArr1 = $oArr1.Size
For $i = 0 To $iSzArr1 - 1
    ConsoleWrite($i & ": " & $oArr1.StringAt($i) & @CRLF)
Next

; The Chilkat JSON path uses ".", "[", and "]" chars for separators.  When a name
; contains one of these chars, use double-quotes in the path:
ConsoleWrite($oJson.StringOf("""name.with.dots"".grain") & @CRLF)