VBScript Requires Chilkat v11.0.0+

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