Extract data from frontend using REST API - QLIK SAAS CLOUD

[Enphad]

Hello Qlik Community,

I am exploring the possibility of creating a data connection in Qlik SaaS that can access itself using the REST API to extract data from a table or visualization in the frontend. Specifically, I want to set up a REST connection that pulls data from a table (or hypercube) already present in the app, using Qlik's own API.

So far I have found these useful sources, specifically for Qlik Saas:

https://github.com/kolsrud/qlik_rest_sdk

https://qlik.dev/apis/rest/reports/

Has anyone successfully set up a REST connection to the Qlik SaaS frontend? If so, what are the necessary steps for authentication (using an API token or OAuth), and how do I correctly configure the REST connection to pull data from specific objects, such as table?

I have already tried doing this by creating an automation, but unfortunately there is a cap of 100.000 rows. (Get straight table from frontend)

I am looking for guidance on:

1. How to pass the correct authentication headers and body parameters?

2. Any limitations or considerations regarding API quotas and performance when using the API in this way.

Any insights, sample code, or Qlik template app would be greatly appreciated!

Thank you in advance for your help!

[henrikalmen]

Are you saying that you in one and the same app want the load script to open a connection to the app's frontend charts/tables/whatever and retrive data from frontend during reload of the app?

Hopefully I have misunderstood, but if that actually is what you're saying: it's not possible.

During reload, all data is emptied from the app (well, unless you're doing a partial reload), so there's no data available in frontend or in any end until the reload is finished.

[vincent_kozijn]

Thank you so much for responding, would it still be technically possible to split this into two separate apps?

Essentially, I am looking for a way to extract data (that has been through set analysis calculations) from the frontend and store it on a server, such as Sharepoint of SFTP.

I have noticed for example that there is a page on the Qlik dev website about temporary contents, these POST/GET  API's are being called while trying to manually download a table from the frontend into Excel using the 'Download' button from the left mouse button menu.

https://qlik.dev/apis/rest/temp-contents/#post-v1-temp-contents-files

[henrikalmen]

I can't say for sure that it wouldn't be possible to find such a solution. But I am sure that I would have tried to solve this issue in load script. Are you absolutely sure that you need set analysis to make the calculations you want? I'm thinking it should be possible to write something in your load script that achieves what you want. I'm thinking that there's probably nothing you can do in set analysis that you couldn't achieve in load script instead.

There are situations where you want calculations only in front end, and therefore you use set analysis. But in your case you want to use the calculation result in the backend/data model/script, and then you should do those calculations in backend. I strongly believe that you are trying to go down an unnecessary and complicated path. But of course, I don't have the whole picture here.