Call the Qlik Sense QRS API with Python

Damien_V — Tue, 31 May 2022 06:57:45 GMT

This article is a guide on how to call the Qlik Sense Repository API using Python.

Environments:

Qlik Sense any version
Python 3.x

Prerequisites to host the app on a different server

Export the certificates from the QMC, provide a password and select platform independent PEM-format in the Export file format for certificates option.
Copy the client.pem and client_key.pem certificates to the external server where the application is hosted.

The Qlik Sense Repository (QRS) API is a RESTful API, so in order to call it from Python, you would need to use a module such as requests

This can be simply installed using pip:

pip install requests

Option 1: Connecting using certificates

Create a python file test.py with the following contents (strings in red should be replaced to match your environment):

import requests

requests.packages.urllib3.disable_warnings()

#Set up necessary headers comma separated
xrf = 'iX83QmNlvu87yyAB'
headers = {'X-Qlik-xrfkey': xrf,
"Content-Type": "application/json",
"X-Qlik-User":"UserDirectory=DOMAIN;UserId=Administrator"}

#Set up the certificate path
cert = 'C:\certificates\clientandkey.pem'

#Set the endpoint URL
url = 'https://qlikserver1.domain.local:4242/qrs/app/full?xrfkey={}'.format(xrf)

#Call the endpoint to get the list of Qlik Sense apps
resp = requests.get(url, headers=headers, verify=False, cert=cert)

if resp.status_code != 200:
    # Returns an error if something went wrong.
    raise ApiError('GET /qrs/app/full {}'.format(resp.status_code))
for app in resp.json():
    print('{} {}'.format(app['id'], app['name']))

The clientandkey.pem file should look like below and contains both private key and certificate in pem format (Certificate and private key can be exported from QMC and it can be merged manually using a text editor)

If you get an error involving certificates change the following line in the code
cert = 'C:\certificates\clientandkey.pem'
by
cert = ('C:/certificates/client.pem', 'C:/certificates/client_key.pem')

Option 2: Connecting using Windows authentication

You will need to also install the following module to handle NTLM authentication:

pip install requests_ntlm

Create a python file test.py with the following contents (strings in red should be replaced to match your environment):

import requests
from requests_ntlm import HttpNtlmAuth

requests.packages.urllib3.disable_warnings()

#Set up necessary headers comma separated
xrf = 'iX83QmNlvu87yyAB'
headers = {'X-Qlik-xrfkey': xrf,
"Content-Type": "application/json",
"User-Agent":"Windows"}

#Set up user credentials
user_auth = HttpNtlmAuth('domain\\user1','MyPassword')

#add xrfkey to URL
url = 'https://qlikserver1.domain.local/qrs/app/full?xrfkey={}'.format(xrf)

#Call the endpoint to get the list of Qlik Sense apps
resp = requests.get(url,headers = headers,verify=False,auth=user_auth)

if resp.status_code != 200:
    # Returns an error if something went wrong.
    raise ApiError('GET /qrs/app/full {}'.format(resp.status_code))
for app in resp.json():
    print('{1} {0}'.format(app['id'], app['name']))

Example of result obtained:

PS C:\certificates> python test.py
9b428869-0fba-4ba5-9f94-901ae2fdf041 test1
72e183c7-f838-4a8e-8e16-1014aa80acb4 License Monitor
38476273-ae47-475b-bee0-68cffa384ae1 Operations Monitor
9cdad10c-a230-4c78-b4f7-0d97ca30a48a testuser2
9fa859ed-b59c-4574-bf26-2620e09f1289 test1(1)
d3c96fe7-2b3b-457a-82d7-2b32edbf4190 License Monitor_22.0.4.0
df32a902-bccb-4187-8c64-4223f6694f7c Operations Monitor_22.0.4.0

! The information in this article is provided as-is and to be used at own discretion. Ongoing support on the solution is not provided by Qlik Support.

Re: Call the Qlik Sense QRS API with Python

cpra_qlik — Fri, 25 Feb 2022 16:58:24 GMT

Hi @Damien_V ,

this is an amazing article, which I have been able to use and works as expected. I have a question though:

We are using a third party server provider for our ssl certificate.

The question I have is using the PEM files, as per above i.e. Qlik default ones is the connection secure?

Or do we need to generate equivalent PEM files from our ssl certificate ?

Re: Call the Qlik Sense QRS API with Python

Damien_V — Mon, 28 Feb 2022 12:50:41 GMT

Hello @cpra_qlik

In the current product design, it's not possible to replace the QlikClient certificate by a 3rd party generated certificate. The API can only be called by the QlikClient certificate generated by Qlik Sense itself.

Re: Call the Qlik Sense QRS API with Python

DavidFosterVF — Thu, 19 May 2022 11:09:43 GMT

@Damien_V will this approach work via the proxy server rather than direct to port 4242?

Re: Call the Qlik Sense QRS API with Python

Damien_V — Thu, 19 May 2022 12:20:03 GMT

@DavidFosterVF

Yes, that's what option 2 is explaining if you scroll down in the article.

Re: Call the Qlik Sense QRS API with Python

DavidFosterVF — Thu, 19 May 2022 13:59:54 GMT

@Damien_V got it working now. Thanks

Re: Call the Qlik Sense QRS API with Python

LDR — Mon, 24 Oct 2022 07:14:50 GMT

Hi @Damien_V ,

First at all thanks for sharing this example.

I'd like to know how to adapt your script to obtain the script for each app. I mean, I'd like to send the request below:

{
"handle": 1,
"method": "GetScript",
"params": {}
}

I understand your script is working with the Global object and to run the GetScript request I have to work with Doc object. The list of docs objects can be obtained from your script however I don't know how to request "GetScript".

Thanks

Re: Call the Qlik Sense QRS API with Python

Sonja_Bauernfeind — Thu, 03 Nov 2022 09:45:30 GMT

Hello @LDR

To receive more direct assistance with your customisation request, I would recommend posting about this in the correct forum (APIs and Intregations ).

All the best,
Sonja

Re: Call the Qlik Sense QRS API with Python

LDR — Thu, 03 Nov 2022 10:54:48 GMT

Hi @Sonja_Bauernfeind

I'll do that. However, so far I'm learning about Qlik APIs maybe REST APIs will be enough according my requirements.

Thanks for your point of view

Re: Call the Qlik Sense QRS API with Python

Kellerassel — Tue, 22 Aug 2023 09:25:44 GMT

@Damien_V Works perfectly. But how can I verify the certificates to avoid getting warnings all the time?

Re: Call the Qlik Sense QRS API with Python

maurizio_lospinoso — Sat, 06 Jul 2024 18:18:25 GMT

Hello @Damien_V ,

please do you know if it s possible to connect Python to Qlik Sense Enterprise?

I have some data sheets in some streams and I d like to access them automatically

thanks for your help

article Call the Qlik Sense QRS API with Python in Official Support Articles

Call the Qlik Sense QRS API with Python

Environments:

Prerequisites to host the app on a different server

Option 1: Connecting using certificates

Option 2: Connecting using Windows authentication

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python

Re: Call the Qlik Sense QRS API with Python