Hi all,
I've been stumped on this for a while now and don't really know any good solution.
I'm parsing JSON in VBA via Jscript (the simple Set JSON = Script.Eval("(" + http.responsetext + ")") method) - which puts the http json response into an object). This works fine - IF you're working with a relatively flat JSON reply.
When I encounter a very nested / leveled JSON reply, I don't really know how to go around it - see below for a screenshot of what my 'parsed' JSON would look like in the locals window.
json.jpg
Now I know some of you might suggest me to use VBA-JSON, but that would still require me to know the structure and key names - whereas I just want it to be parsed without knowing that information.
I wrote/tried the code below, and while it almost does what I want, it messes up the columns where it puts stuff.
This uses a global script control and 're' integer to determine whether to add a column or not.
While this -almost- works, I believe this is not the smartest way to do it, so would love any pointers.
Thanks,
Jasper
Bookmarks