Qlik Cloud & Python Integration

[rolmontero]

Hi Qlik Community,

I am currently working with a user who creates data transformation processes in Python, and I would like to know if I can reuse them in Qlik Cloud just as a stored procedure or a SQL query. I have read some articles regarding this integration, but with Qlik Sense Desktop and/or Qlik Sense Client Managed, both of which do not apply for this use case.

I look forward to hearing from you soon

Thanks a lot!

[igoralcantara · Accepted solution]

Yes, it is possible. I have been using Qlik Cloud resources in Python on a daily basis and I have wrote a few articles about it. Here is one example:

Call Qlik AutoML from Python

Basically, you have 2 options:

To get the data from Qlik cloud objects, you can use the library pytoqlik. It is super straight forward.

Another way is to use Qlik Cloud APIs. I used to upload my Python treated datasets back to Qlik Cloud, for example. Check out the documentation:

REST APIs | Qlik Developer Portal

I hope this helps.

[rolmontero]

Hello @igoralcantara for your answer,

I see that option number two would be the best approach for me. I have never used Python, but I would assume you can upload the treated data to SharePoint and connect it to Qlik Cloud. Python will run daily, for example, and therefore I will have fresh data to create visualizations.  

Correct me please if I am wrong

Thanks again for such a quick response

[igoralcantara · Accepted solution]

Yes, you are correct. 

Here is one example of how to use Python to upload data to Sharepoint:

How to Upload Files to SharePoint Using Python | In Plain English

[FedericoC]

But if I need to download data from Qlik Sense Cloud with python? I had a lot of problems with authentication.. error 401. Thanks