(VBScript) Swap JSON Objects

Demonstrates how to swap two JSON objects within a JSON document.

Note: This example requires Chilkat v9.5.0.76 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
json.EmitCompact = 0

' Load the following JSON:

' {
'   "petter": {
'     "DOB": "26/02/1986",
'     "gender": "male",
'     "country": "US"
'   },
'   "Sara": {
'     "DOB": "13/05/1982",
'     "gender": "female",
'     "country": "FR"
'   },
'   "Jon": {
'     "DOB": "19/03/1984",
'     "gender": "male",
'     "country": "UK"
'   }
' }

success = json.LoadFile("qa_data/json/people.json")
' Assume success..

' Swap the positions of Jon and Sara.
index1 = json.IndexOf("Jon")
index2 = json.IndexOf("Sara")
success = json.Swap(index1,index2)

' We have this now:
outFile.WriteLine(json.Emit())

' {
'   "petter": {
'     "DOB": "26/02/1986",
'     "gender": "male",
'     "country": "US"
'   },
'   "Jon": {
'     "DOB": "19/03/1984",
'     "gender": "male",
'     "country": "UK"
'   },
'   "Sara": {
'     "DOB": "13/05/1982",
'     "gender": "female",
'     "country": "FR"
'   }
' }

' To swap an inner member:
' jsonSara is a Chilkat.JsonObject
Set jsonSara = json.ObjectOf("Sara")
index1 = jsonSara.IndexOf("DOB")
index2 = jsonSara.IndexOf("country")
success = jsonSara.Swap(index1,index2)

' We now have this:
outFile.WriteLine(json.Emit())

' {
'   "petter": {
'     "DOB": "26/02/1986",
'     "gender": "male",
'     "country": "US"
'   },
'   "Jon": {
'     "DOB": "19/03/1984",
'     "gender": "male",
'     "country": "UK"
'   },
'   "Sara": {
'     "country": "FR",
'     "gender": "female",
'     "DOB": "13/05/1982"
'   }
' }

outFile.Close