Qlik Community

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
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

How to setup a Data Connection to the QRS API using Certificates on the June 2017 release or higher

Andre_Sostizzo
Digital Support
Digital Support

How to setup a Data Connection to the QRS API using Certificates on the June 2017 release or higher

This article will show how to connect to the Qlik Sense Repository API through a Data Connection using Certificates.

 

Environment:

Qlik Sense Enterprise on Windows  

 

Resolution

  1. Create a new data connection using the Qlik REST Connector
  2. Add the URL of the QRS endpoint that you want to connect to:

    url request.png

    Note: Since we are connecting using Certificates, we need to use port 4242 (help.qlik.com reference)

  3. Keep Auto detect response type selected to the default value
  4. In the Authentication section, select Anonymous and Use certificate from file:

    file location.png

    Note: For the Certificate file location, the expected format is file.pfx pointing to the client certificate used by Qlik Sense. Do note that this is a filename and not a file location. The file system location of the file is determined by the CertificateDirectoryPath key in the Qlik REST connector config (C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\QvRestConnector.exe.config). The default location where the Qlik REST connector will look for certificates is C:\ProgramData\Qlik\Sense\Engine\Certificates

    See article Export client certificate and root certificate to make API calls  for instructions on exporting certificates from the QMC

    Note: The Qlik REST connector requires a password on the exported certificates for security purposes.

  5. For the Additional Request Parameters section, you will need to add in the following values:
    1. Query parameter:
    2. Query headers:
      • Name: X-Qlik-Xrfkey
      • Value: Same 16 character alphanumeric string from the xrfkey value
      • Name: X-Qlik-User
      • Value: X-Qlik-User: UserDirectory=<directory>; UserId=<userid>
        • This user will need to have the needed rights on the API endpoint. Using a RootAdmin account here is recommended.
        • Note: If using INTERNAL accounts, it is recommended to use the sa_api user rather than sa_repository. The sa_repository user is used by the Repository Service whereas the sa_api user is purpose built for use in API use cases. This allows better tracking through logs should you need to investigate what occurred on a system.
      • Name: Response-Type
      • Value: application/json

        Like so: 

        additional request paramters.png
  6. Test the connection and save it when it is successful.

 

Labels (2)
Version history
Revision #:
3 of 3
Last update:
‎2021-02-15 03:56 AM
Updated by:
 
Contributors