JSON From Excel/Word/Access

[Oralloy]

Folks,

I have a need to access JIRA REST services from VBA under Excel, Word, and possibly Access. Unfortunately I'm stuck with JSON. I've got XML figured out; but I can't find any good packages for JSON.

Is there a convienent "Reference" that I can add, which gives me clean handling of JSON?

I found VB-JSON (See: this site); but it doesn't want to play easily. I'm stalled on the "Dictonary" object reference in the source.

Any help or guidance you guys can give me is appreciated.

Oralloy

[Mariostg]

Did you look at the json package of python. python JSON encoder and decoder

[NeoPa]

I wish I could Oralloy, but I have no such experience unfortunately :-(

What I will do though, is send out a general call to all the experts to draw attention to the question.

[Oralloy]

Mariostg, I'm being a little dense, in that I don't see the point of Python, unless I'm supposed to take the "json" module and rework it to run under VBA. Not sarcasm at all, I do know your offering is well meant - I just don't know what to do with it.

NeoPa, thanks. I did manage to get VB-JSON to work, but it's pretty obvious that it is missing some functionality relative to (what I consider as) Crockford's normative javascript implementation, json2. Still, this is the path I'm pursuing at this point.

[Mariostg]

Sorry Oralloy, I mis-interpreted your initial posting. I got carried away, because to me package+json ~= python :).

But would be interesting to engineer that json-python package into vba though.

[Oralloy]

Gotta love the RFCs.

Apparently the RFC for JSON (see RFC4627) only allows JSON encoding of objects or arrays. Which the VB-JSON library is in strict compliance with.

When I test on I.E. 8, I can certainly encode atomic values, like 3 and "my string", using the built-in JSON.stringify() method. The json2 implementation seems to behave similarly.

Of course, all of this is put together by Crocker, the RFC in 2006, and the latest json implementations in 2010 and 2011.

Considering that the (IMHO) proper implementation of a serializer should be capable of passing atomic values, I would say that the JavaScript implementations are the correct, and the RFC is fallacious.

Ok, enough of that research. I don't see that RFC4627 is obsoleted, so I have to laugh and cry. I really don't feel like spending a week writing and delousing a "correct" JSON parser in VBA.