topic JSON connector in QlikView

JSON connector

Fri, 27 Jan 2012 06:19:38 GMT

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

Re: JSON connector

rbecher — Fri, 27 Jan 2012 07:20:31 GMT

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

JSON connector

Thu, 16 Feb 2012 22:31:32 GMT

Ralf,

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

Re: JSON connector

rbecher — Thu, 16 Feb 2012 23:23:42 GMT

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

Re: JSON connector

rbecher — Mon, 18 Jun 2012 13:31:42 GMT

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

Re: JSON connector

tseebach — Wed, 20 Jun 2012 20:06:26 GMT

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

Re: JSON connector

etl_tools — Wed, 20 Jun 2012 23:54:42 GMT

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

Re: JSON connector

chrisbrain — Thu, 21 Jun 2012 13:31:24 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: JSON connector

rbecher — Tue, 26 Jun 2012 14:15:10 GMT

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

Re: JSON connector

bill_mtc — Wed, 02 Oct 2013 09:51:01 GMT

Hi Ralf,

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

Regards,

Bill

Re: JSON connector

rbecher — Wed, 02 Oct 2013 10:12:48 GMT

I've uploaded a version in the post above without protection..

- Ralf

Re: JSON connector

Thu, 05 Jun 2014 06:59:53 GMT

Hey nice post i need help on rootnode.
How do i find rootnode in my .json file??? Pls help

Thanks

Re: JSON connector

rbecher — Thu, 05 Jun 2014 07:15:35 GMT

Just upload your json file, or an equivalent...

- Ralf

Re: JSON connector

simospa — Thu, 05 Jun 2014 07:16:39 GMT

Very cool.

What about exporting data to Json? It is possible? I was thinking about do it with a macro. But if you have any other ideas...

Re: JSON connector

rbecher — Thu, 05 Jun 2014 07:34:47 GMT

You could probably load and concat all fields into one row with json syntax and the store into a txt file..