Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Starting with version 12 of QlikView we released a new connector that allowed developers to extend the target data sources available. The Qlik REST Connector provides a means for the Qlik Analytics Platform to efficiently load data into a Qlik Sense or QlikView application from a REST service that returns data in XML, CSV or JSON format.
What is REST?
REST stands for Representational State Transfer. It relies on a stateless, client-server, cacheable communications protocol. RESTful applications use HTTP requests to post, read, and delete data. REST is a lightweight alternative to RPC (Remote Procedure Calls) and Web Services (SOAP, WSDL, et al.).
More info on REST (Representational state transfer - Wikipedia, the free encyclopedia)
The Qlik REST Connector
The Qlik REST Connector is a generic connector, it is not tailored to a specific REST data source. The requirements for creating connections must be acquired from the specific data sources. Examples for connecting to popular social network platforms are provided in the help documentation.
How to get the connector?
Get the connectors here: Qlik Connector Packages
How it works. Getting Star Wars data
If you read the Qlik documentation you will find examples on how to get data from Facebook, Twitter, LinkedIn and even Google Analytics.
For this post example we are going to get data from this website http://swapi.co/ It contains data from the universe of Star Wars. It uses JSON format to give us access to data about the seven films so we can plot some SW demographics.
Because Qlik REST is a generic connector first step to connect to a new data source will always be to carefully read the documentation from the source where the data will be acquired from.
I’m interested in getting data from the Characters, in the API documentation web page we can read how to query the requested data.
http://swapi.co/documentation#people
I'm attaching the app so you all can check how it's done.
Enjoy Qliking
AMZ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.