Discussion Board for collaboration on QlikView Scripting.
I did some work on this topic:
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: firstname.lastname@example.org
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: email@example.com
We also provide consulting in this area of data integration...
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.
We will add support fro JSON in the next release of ETL tools QLikView connector
We are already using JSON internally
Here's the first release of the QVSource solution for dealing with general JSON (and indeed XML) APIs:
It's available now in the latest nightly build (126.96.36.199) and should be pushed into the next 'official' release assuming it's working out for everyone.