Connecting Qlik Sense QRS data via REST connector

Sonja_Bauernfeind — Thu, 20 May 2021 12:21:00 GMT

A common user scenario is to pull data out of Qlik Sense database into an App and do analysis. In order to do so, a good practice is to get data via QRS API using REST connector, which is shipped together with Qlik Sense.
This article shows how you can set up the connection.

Environment:

, all versions

Resolution:

1. Create the REST connection:

Add a REST connection from Hub
Create an App
Go to Data Load Editor
Create New Connection
Choose “Qlik REST Connector”
Fill in the settings according to the example below.
Note that you need to use the server name/FQDN instead of ‘localhost’ in the URL.
In the Virtual Proxy settings, you need to keep Authentication Method as ‘Ticket’ and for Windows authentication pattern set ‘Windows’.
The value for the xrfkey can be any 16digit-long string

Test the data load

After Test the connection and save the settings, now go back to the Data load editor.
Find the connection you just created, click the “Select Data” icon.

Make sure the right Response (JSON) type is selected. And also select the ‘root’ so that you can preview the data from the table you are connecting to.

Insert the script to the right place.

You can repeat this and create more REST connections against different QRS API endpoints. One connection to one endpoint.

You can find all supported QRS API endpoints using the API endpoint “/qrs/about/api/description”. For more information about how to use QRS API, refer to the Qlik help site Getting Started - Qlik Sense for developers.

article Connecting Qlik Sense QRS data via REST connector in Official Support Articles

Connecting Qlik Sense QRS data via REST connector

Environment:

Resolution: