JSON connector

[#1]

Has anyone try to build a JSON connector or know how to use JSON as a datasource?

[rbecher]

Hi,

I did some work on this topic:

QlikView JSON Prototype

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

QlikView MongoDB Prototype

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

The first one is "under moderation" for 3 weeks now I don't know why! So I attache this here again.

It is reading JSON from an URL (REST) and converts it to XML which can easily loaded into QlikView:

You can use it with CouchDB for instance:

We are using this for some projects. I can adjust this if you want. Contact me on: ralf.becher@tiq-solutions.de

- Ralf

[#3]

Ralf,

Looks great! Is there a way to use this outside of this file?

[rbecher]

Hi Matt,

you can use this for a lot of use cases. It just needs a few adjustment in the script.

I can give you some advice. Just drop me a line: ralf.becher@tiq-solutions.de

We also provide consulting in this area of data integration...

- Ralf

[rbecher]

A JSON connector is on the way. This will work as a proxy to read JSON data from URL or file and stream back as XML where QlikView can read it as web file. I will post it soon here.

- Ralf

[tseebach]

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

[etl_tools]

We will add support fro JSON in the next release of ETL tools QLikView connector

We are already using JSON internally

http://www.etl-tools.com/etl-tools/qlikview-connector/overview.html

Mike

[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.

[rbecher]

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

[bill_mtc]

Hi Ralf,

Is there aint no way to have a glance in hidden script?

Regards,

Bill