Visual Basic 6.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
          
	}
}

Visual Basic 6.0

Dim success As Long
success = 0

Dim json As New ChilkatJsonObject
json.EmitCompact = 0

' Assume the file contains the data as shown above..
success = json.LoadFile("qa_data/json/sample2.json")
If (success = 0) Then
    Debug.Print json.LastErrorText
    Exit Sub
End If

' Get the "sampleData" object:
Dim sampleData As New ChilkatJsonObject
success = json.ObjectOf2("sampleData",sampleData)

' Demonstrate BoolAt and BoolOf
Debug.Print "hungry: " & sampleData.BoolOf("hungry")
Debug.Print "hungry: " & sampleData.BoolAt(2)

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

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

' IntOf
Debug.Print "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:
Debug.Print json.Emit()

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

' Show the changes:
Debug.Print 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..
Debug.Print json.Emit()