topic Flurry / JSON in QlikView

Flurry / JSON

Teppo_Ojala — Mon, 12 Dec 2011 14:06:13 GMT

Hi,

I am doing a QV project where the datasource is Flurry Rawdata API (http://wiki.flurry.com/index.php?title=RawData_API)

This interface returns data in JSON format. What is the easiest way to read that in to QV? I have now converted the sample data with Altova to XML, but naturally this manually step is not possible in production environment?

Do we have any kind of standardized "component" to read JSON in?

Thanks in advance!!

Teppo

Flurry / JSON

chrisbrain — Tue, 20 Dec 2011 07:43:18 GMT

Hi Teppo,

One option is to consider using QVSource, which contains an SDK for connector development with helper methods for a number of common API connectivity tasks, including working with JSON.

Feel free to contact me directly if you would like more info.

Flurry / JSON

Wed, 18 Jan 2012 19:59:58 GMT

Really? No QlikView solution to process JSON data?!

Flurry / JSON

Wed, 25 Jan 2012 17:27:19 GMT

I, too, really really want a way to read JSON natively in Qlikview. (Though, Chris, if you can create a basic JSON converter in QVSource in the meantime, it would make that already great QVSource that much more valuable to us.)

Teppo, what I've needed to do to work around the lack of native JSON support is to import the JSON feed as standard HTML or text and use standard string parsing stuff - TextBetween, SubStringCount, etc. - and pull values from that. Hacky, but it might work for you.

Flurry / JSON

chrisbrain — Wed, 25 Jan 2012 17:48:14 GMT

I'll start looking into this for QVSource.

In the first instance would just turning a json document into an XML document give you something you could work with?

If there are any other ideas/requirements just list them here!

Flurry / JSON

Wed, 25 Jan 2012 17:51:17 GMT

That would be a great start!

Flurry / JSON

Teppo_Ojala — Mon, 30 Jan 2012 10:40:00 GMT

Hi,

I have actually done the JSON conversion the same way. In my case the file is really big and that's why reading into QV takes some time.

I am really looking forward if some "standardized component" could do this easier and faster way.

Flurry / JSON

rbecher — Fri, 03 Feb 2012 13:00:09 GMT

BTW there is a QlikView based solution to start with:

http://community.qlik.com/qlikviews/1160

- Ralf

Re: Flurry / JSON

tseebach — Wed, 20 Jun 2012 20:07:21 GMT

Try my JSON loader http://community.qlik.com/docs/DOC-3129

Re: Flurry / JSON

chrisbrain — Thu, 21 Jun 2012 13:24:51 GMT

Here's the first release of the QVSource solution for dealing with general JSON (and indeed XML) APIs:

http://www.qvsource.com/wiki/General-Web-Connector-For-QlikView.ashx

It's available now in the latest nightly build (1.2.4.16) and should be pushed into the next 'official' release assuming it's working out for everyone.

Re: Flurry / JSON

Thu, 21 Jun 2012 16:37:19 GMT

Nice, Chris! I can't wait to try it out!

On Thu, Jun 21, 2012 at 6:24 AM, Chris Brain <