Generating JSON

[stewart-anderson]

hi,

I've loaded up the project and I can see editing of JSON is fine. I can edit items in an array too and that seems fine.

Is the module supposed to allow extending JSON arrays? There's nothing in the MD and the you tube example only seems to demonstrate working with parsed data.

I want to be able to add elements to an array of items. Starting position is an empty array for example and then reading rows in my sheet to construct the remainder of the data into a JSOn file, ultimately to write it out as .json

I seem to have achieved this with the collection method .add where I added a parsed object to the array of existing items. debug print and when I coped the data out it parsed as JSON. I'm concerned that this isn't a documented feature as its kinda big!

I just wanted to check before I attempt to use it that way that this would not run into issues at some stage.

Am I missing something truly obvious

Ta

Stu

[houghtonap]

No you are not missing anything. VBA-JSON maps a JSON Array to a VBA.Collection object and maps a JSON Object to a Scripting.Dictionary object. So you need to use the appropriate methods for those objects to make conceptual changes to the JSON being represented by VBA-JSON. You can view the documentation on Microsoft's website.

VBA.Collection
Scripting.Dictionary

See also, issue 195

[stewart-anderson]

Thanks for confirming. Just wanted to check :) Sorry I took so long to respond, I just found this in my spam folder. regards Stewart

…

------ Original Message ------ From "Andrew Houghton" ***@***.***> To "VBA-tools/VBA-JSON" ***@***.***> Cc "stewart anderson" ***@***.***>; "Author" ***@***.***> Date 09/03/2023 23:35:44 Subject Re: [VBA-tools/VBA-JSON] Generating JSON (Issue #248)

No you are not missing anything. VBA-JSON maps a JSON Array to a VBA.Collection object and maps a JSON Object to a Scripting.Dictionary object. So you need to use the appropriate methods for those objects to make conceptual changes to the JSON being represented by VBA-JSON. You can view the documentation on Microsoft's website. VBA.Collection <https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/collection-object> Scripting.Dictionary <https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/dictionary-object> See also, issue 195 <#195 (comment)> — Reply to this email directly, view it on GitHub <#248 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFSA6WDZN5JKNY6GJEQ2OY3W3JSNBANCNFSM6AAAAAAVRBJMNY>. You are receiving this because you authored the thread.Message ID: ***@***.***>