topic Pulling Data from REST APIs (XML/JSON) in QlikView

Pulling Data from REST APIs (XML/JSON)

Fri, 01 Jul 2011 10:50:11 GMT

Hi.

I am evalutating using QlikView for a requiremet I have to build a desktop reporting widget.

My Data sources are all external REST APIs that return XML. eg webtrends, disqus and a couple of others.

Can QlikView pull data from these APIs and turn them into tables that can be joined to create reports?

Is there a tutorial or recommended way to do this? We would also want QlikView to poll these APIs on a schedule to refresh the data.

Thanks for your input.

Pulling Data from REST APIs (XML/JSON)

chrisbrain — Fri, 01 Jul 2011 13:52:20 GMT

You could check out:

http://www.qvsource.com

We have an SDK for building connectors, ideal for connecting to web APIs. We could also consider working with you directly to build the connectors if they could be added to the QVSource platform.

Re: Pulling Data from REST APIs (XML/JSON)

chrisbrain — Sun, 24 Jun 2012 07:19:08 GMT

We now have a solution in QVSource 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.