How to create json object in vbscript file?

Question

How to create JSON object in .vbs file?

I have tried this:

set json = CreateObject("Scripting.Dictionary")

But this object is not supporting json.AddStringAt property. How to create JSON object that supports the json.AddStringAt?

My sample file is

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.json", True)

set json = CreateObject("Scripting.Dictionary")

index = -1

success = json.AddStringAt(-1,"Title","Pan's Labyrinth")
success = json.AddStringAt(-1,"Director","Guillermo del Toro")
success = json.AddStringAt(-1,"Original_Title","El laberinto del fauno")
success = json.AddIntAt(-1,"Year_Released",2006)

json.EmitCompact = 0
outFile.WriteLine(json.Emit())

outFile.Close

If you take a code sample that uses a particular COM object you can't just replace that object with an arbitrary other COM object. — Ansgar Wiechers
– Ansgar Wiechers, Commented Jan 4, 2017 at 10:36

Jeff Block · Accepted Answer · 2017-01-04 05:32:34Z

2

It looks like there is a library that has the method that you are looking for.

set json = CreateObject("Chilkat_9_5_0.JsonObject")

https://www.chilkatsoft.com/refdoc/xChilkatJsonObjectRef.html

answered Jan 4, 2017 at 5:32

Jeff Block

4242 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sindhu Over a year ago

I have tried this but got this error. ActiveX component can't create object: 'Chilkat_9_5_0.JsonObject'

Jeff Block Over a year ago

Did you download and install their ActiveX library?

Jeff Block Over a year ago

example-code.com/vbscript/create_json.asp Right above nearly the same example that you posted is the download link.

Sindhu Over a year ago

Installed ActiveX library and now it is working fine.

naveen veenu · Accepted Answer · 2018-07-23 10:35:56Z

0

For 32 bit

set json = CreateObject("Chilkat_9_5_0.JsonObject")

For 64bit

set json = CreateObject64("Chilkat_9_5_0.JsonObject")

answered Jul 23, 2018 at 10:35

naveen veenu

11 bronze badge

Collectives™ on Stack Overflow

How to create json object in vbscript file?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related