Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

JSON connector

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

14 Replies
rbecher
MVP
MVP

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:

freebase.png

QlikView_JSON_prototype.png

You can use it with CouchDB for instance:

CouchDB.png

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

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Ralf,

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D
rbecher
MVP
MVP

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

Astrato.io Head of R&D
tseebach
Partner - Creator III
Partner - Creator III

etl_tools
Creator
Creator

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
Partner - Specialist II
Partner - Specialist II

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.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
bill_mtc
Partner - Creator
Partner - Creator

Hi Ralf,

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

Regards,

Bill