26th
Loading JSON data into QlikView via JSON Proxy
TIQ Solutions has developed a JSON Proxy server program which can handle any JSON data from any URL like RESTful web APIs, NoSQL databases or files. It converts the data into a XML format which then can be loaded into QlikView (or where else..) using a web file source.
All proxy queries got cached as long as the proxy server runs or if the parameter /clearCache is used. This is very useful to load multiple tables out of one XML result consistently and it also saves API calls to prevent hitting vendor’s API limits.
The JSON Proxy package includes some QlikView sample applications to demonstrate how to use the proxy server.
This one queries Foursquare Places (of course bars and pubs to save the night) using the Infochimps API around a geocoded address where I use OpenStreetMap for:
This solution is quite a big step into the world of web APIs for QlikView enthusiast and opens up a lot of new use cases for web data integration in a business discovery world.
I’m curious what kind of solutions can be made out of this. The next implementation steps will be authentification, streaming of big data sets, more functionality and more supported data formats.
Download JSON Proxy demo with QlikView the examples here:
JSONproxyDemo.zip (8.2 MB)
Update:
The licensed version (not this demo) supports all major 1.0a and 2.0 OAuth APIs out-of-the-box (Google, Facebook, Yahoo, LinkedIn, Twitter, Foursquare, Evernote, Vimeo, Yammer, Windows Live, …).
