Working with the Qlik REST Connector, Pagination and Multiple JSON Schemas

[Michael_Tarallo]

Recently, I worked with a Qlik Community member to help them understand the Qlik REST Connector with Qlik Sense and QlikView. At first it appeared simple, but then he soon realized he needed to understand a bit more about how the data came back (the response), what the pagination settings were (pages of data used to retrieve more rows) and finally how to link (join, associate) other attributes that came back from the results of multiple REST API endpoints / resources. We got it all working and the results were pleasing. Needless to say were able to perform text analytics from a barrage of Facebook comments.  However, as I finalized all this in my head, I wanted to share what I've learned but in the simplest way possible. So I decided to find a very simple, publicly available RESTful service API in which I can demonstrate my findings easily. The below video presents those findings in a educational and entertaining way using the Star Wars API. Yes, that is correct, I said the Star Wars API. As a bonus, stick to the end of the video to see the Media Box Extension in action.

See this video on YouTube as well. Using the Qlik REST Connector - Pagination and Multiple JSON Schemas - YouTube

Video Link : 5008

Do you know of other simple and fun, publicly available RESTful services? Share them with the Qlik Community in the comments below.

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

Special shout out to: Paul Hallett    (@phalt_) | Twitter - for creating an awesome resource http://swapi.co/about that allowed me to easily demonstrate the Qlik Sense REST Connector.

Resources used in this video:

• Qlik Sense Desktop: Free Data Visualization Tool | Qlik Sense Desktop
• https://www.swapi.co/ - Star Wars Rest API
• Endpoint People: http://swapi.co/api/people/
• Endpoint Species: http://swapi.co/api/species/
• Qlik Branch - Media Box Extension
• Star Wars REST API - Qlik Sense App (attached below)
• Qlik Sense - Introduction to Extensions (video)

Other Resources:

• REST Connector 1.1 ‒ Qlik Connectors

If using Qlik Sense Desktop please copy .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh Qlik Sense Desktop with F5. If using Qlik Sense Enterprise Server please import .qvf into your apps using the QMC - Qlik Management Console.

Disclaimer: Star Wars, the Star Wars logo, all names and pictures of Star Wars characters, vehicles and any other Star Wars related items are registered trademarks and/or copyrights of Lucasfilm Ltd., or their respective trademark and copyright holders.

Star Wars REST API.qvf

[pbk]

Mike:

This is awesome!  Thanks for taking the time to put this video together!

[juc]

Great video, Mike! Really helpful.

[mgranillo]

I used the game of thrones api to make an app awhile ago: GoT app.qvf‌

It was fun and a good way to learn about the Rest connector

[Michael_Tarallo]

Thanks for sharing the Got App Mike G.  - this great!

[Caique_Zaniolo]

Great stuff Mike.. Thanks for sharing this!

[wwi]

Nice one Mike!

[mstoler]

Very nice Michael.

I am currently using the Rest Connector with pagination. I had a problem with the json format (the next field is dropped) on the last page.

My solution is to keep track of where I am and then create a new call for the last page. This works fine.

Thanks again!

Michael

[aldo-tgh]

Hi Mike,

Great post.

Is the ability to use "POST" (instead of "GET") available on Qlik Sense?

It will be great to have a real life example.

Thanks in advance,

Aldo.

[#10]

Hello Mike,

Can you tell us how to configure Rest Connector to pull data from Twitter using pagination?

Thanks!

Rima

[Michael_Tarallo]

Hello Rima - since this post there has been a webinar that combines many examples - and there is a help document too:

ICYMI - Qlik Sense Tips and Tricks Webinar - Tapping into all your data

Setting up selected REST sources for data loading ‒ Qlik Connectors