Obtaining list of data sources

[tomas_kukan]

What API should I use if I want to obtain a list of all my datasources in Qlik? For example, I configured a Postgres connection and extracted 2 tables. Now I would like to get this info from the API - table names, table columns. 

[rwunderlich]

For on-prem the QRS API will provide a list of data connections:

https://help.qlik.com/en-US/sense-developer/February2024/APIs/RepositoryServiceAPI/index.html?page=1...

For Qlik SaaS, it the REST API

https://qlik.dev/apis/rest/data-connections/

You said you want table names and columns -- do you mean the database tables behind those connections or the Qlik tables created from them?

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[tomas_kukan]

Thank you for the quick response.


I am currently focusing on SaaS, but I would like to ideally handle both cases.

---

For Qlik SaaS, it the REST API

https://qlik.dev/apis/rest/data-connections/

This returns only that I have created the connection to my db (postgres in my case), but it does not list the tables/columns I am importing. 

---

You said you want table names and columns -- do you mean the database tables behind those connections or the Qlik tables created from them?

---

Both - I need the database tables/columns and its counterpart in Qlik. Is it possible?

[rwunderlich]

You may be able to some of the info you are looking for from the Lineage Graphs endpoint. A great resource for QLIK API questions is qlikdeveloper.slack.com.

-Rob

[VitorioVincenze]

Check out the Qlik Sense Repository Service (QRS) API. It's your go-to for interacting with Qlik's backend stuff, like fetching details about your connections and tables.

[tomas_kukan]

Thank you. Does QRS work also for the cloud solution, or is it on-premise only? I am having issues finding out how to setup the connection for cloud version.

[rwunderlich]

QRS is on-prem only. 

-Rob