VBScript

JSON: Miscellaneous Operations

See more JSON Examples

Demonstrates a variety of JSON API methods. This example uses the following JSON document:

{
   "alphabet": "abcdefghijklmnopqrstuvwxyz",
   "sampleData" : {
           "pi": 3.14,
	   "apple": "juicy",
	   "hungry": true,
	   "withoutValue": null,
           "answer": 42
          
	}
}

VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

set json = CreateObject("Chilkat.JsonObject")
json.EmitCompact = 0

' Assume the file contains the data as shown above..
success = json.LoadFile("qa_data/json/sample2.json")
If (success = 0) Then
    outFile.WriteLine(json.LastErrorText)
    WScript.Quit
End If

' Get the "sampleData" object:
set sampleData = CreateObject("Chilkat.JsonObject")
success = json.ObjectOf2("sampleData",sampleData)

' Demonstrate BoolAt and BoolOf
outFile.WriteLine("hungry: " & sampleData.BoolOf("hungry"))
outFile.WriteLine("hungry: " & sampleData.BoolAt(2))

' StringOf returns the value as a string regardless of it's actual type:
outFile.WriteLine("pi: " & sampleData.StringOf("pi"))
outFile.WriteLine("answer: " & sampleData.StringOf("answer"))
outFile.WriteLine("withoutValue: " & sampleData.StringOf("withoutValue"))
outFile.WriteLine("hungry: " & sampleData.StringOf("hungry"))

' Demonstrate IsNullOf / IsNullAt
outFile.WriteLine("withoutValue is null? " & sampleData.IsNullOf("withoutValue"))
outFile.WriteLine("withoutValue is null? " & sampleData.IsNullAt(3))
outFile.WriteLine("apple is null? " & sampleData.IsNullOf("apple"))
outFile.WriteLine("apple is null? " & sampleData.IsNullAt(1))

' IntOf
outFile.WriteLine("answer: " & sampleData.IntOf("answer"))

' SetNullAt, SetNullOf
' Set "pi" to null
success = sampleData.SetNullAt(0)
' Set "answer" to null
success = sampleData.SetNullOf("answer")

' Show the changes:
outFile.WriteLine(json.Emit())

' Restore pi and apple:
success = sampleData.SetNumberAt(0,"3.14")
success = sampleData.SetNumberOf("answer","42")

' Show the changes:
outFile.WriteLine(json.Emit())

' Add a null value named "afterApple" just after "apple"
success = sampleData.AddNullAt(2,"afterApple")

' Add a boolean value just after "pi"
success = sampleData.AddBoolAt(1,"afterPi",0)

' Examine the changes..
outFile.WriteLine(json.Emit())

outFile.Close