Flurry / JSON

[Teppo_Ojala]

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

[chrisbrain]

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.

[#3]

Really?  No QlikView solution to process JSON data?!

[#4]

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.

[chrisbrain]

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!

[#6]

That would be a great start!

[Teppo_Ojala]

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.

[rbecher]

BTW there is a QlikView based solution to start with:

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

- Ralf

[tseebach]

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

[chrisbrain]

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.