topic Parsing JSON in QlikView Desktop? in QlikView

Parsing JSON in QlikView Desktop?

Wed, 18 Jan 2012 19:55:09 GMT

Hi,

I searched the docs but can't seem to find a straightforward solution for this. I have some JSON string data stored in a database. My SQL query will return this JSON data in a column and I can access this string data; but is there something in the desktop version equivalent to jQuery's parseJSON(<string to parse>), or do I have to parse this manually?

Thanks in advance for your help.

Parsing JSON in QlikView Desktop?

Thu, 02 Feb 2012 05:20:45 GMT

A lot of us want JSON to be read natively by Qlikview, and it simply doesn't support it out of the box. So, you can try the following:

If the data you need retrieved is short and simple, you can try standard string parsing of the JSON
You can try a cobbled-together JSON-to-XML solution like this one: http://blog.qvapps.com/2010/09/20/using-qlikview-with-web-services/

Two FYIs:

I've let my Qlikview account rep know that this is the biggest need in an otherwise great product
Chris Brain (who developed QVSource, a great 3rd-party API connector) indicated he may take a stab at integrating a JSON reader into a future version of QVSource

Good luck, futebol70

Re: Parsing JSON in QlikView Desktop?

tseebach — Wed, 20 Jun 2012 20:08:15 GMT

Hey, I've just written up a solution: http://community.qlik.com/docs/DOC-3129

Re: Parsing JSON in QlikView Desktop?

chrisbrain — Sat, 23 Jun 2012 08:36:41 GMT

We have also added a solution for this now for our QVSource users: http://www.qvsource.com/wiki/General-Web-Connector-For-QlikView.ashx Would be interested in any feedback as it's just the first version.

Re: Parsing JSON in QlikView Desktop?

rbecher — Tue, 26 Jun 2012 15:29:42 GMT

And here is another one: http://tiqview.tumblr.com/post/25925985849/loading-json-data-into-qlikview-via-json-proxy