Qlik Community

Ask a Question

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Talk to Experts Tuesday: Live chat Aug. 24th 10 AM ET: Bring your Qlik Gold Client questions REGISTER TODAY

Connecting Qlik Sense QRS data via REST connector

Sonja_Bauernfeind
Digital Support
Digital Support

Connecting Qlik Sense QRS data via REST connector


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:

Qlik Sense Enterprise on Windows , all versions
 

Resolution:


1. Create the REST connection:

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

000035886a.png

 000035886b.png

 



  1. 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.

000035886d.png

 

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.
000035886c.png

 

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

 

  1. 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.
Labels (2)
Version history
Revision #:
2 of 2
Last update:
‎2021-05-20 08:21 AM
Updated by:
 
Contributors