469,352 Members | 1,782 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,352 developers. It's quick & easy.

JSON From Excel/Word/Access

Oralloy
983 Expert 512MB
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
Apr 14 '11 #1
5 11353
Mariostg
332 100+
Did you look at the json package of python. python JSON encoder and decoder
Apr 14 '11 #2
NeoPa
32,184 Expert Mod 16PB
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.
Apr 14 '11 #3
Oralloy
983 Expert 512MB
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.
Apr 14 '11 #4
Mariostg
332 100+
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.
Apr 14 '11 #5
Oralloy
983 Expert 512MB
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.
Apr 14 '11 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Pranav | last post: by
2 posts views Thread by Danielle | last post: by
16 posts views Thread by Phil Stanton | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.