topic Re: Obtaining list of data sources in Integration, Extension & APIs

Obtaining list of data sources

tomas_kukan — Mon, 22 Apr 2024 11:54:47 GMT

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.

Re: Obtaining list of data sources

rwunderlich — Mon, 22 Apr 2024 15:44:27 GMT

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=1169

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

Re: Obtaining list of data sources

tomas_kukan — Wed, 24 Apr 2024 17:32:04 GMT

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?

Re: Obtaining list of data sources

rwunderlich — Fri, 26 Apr 2024 14:53:49 GMT

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

Re: Obtaining list of data sources

tomas_kukan — Mon, 29 Apr 2024 07:34:50 GMT

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.

Re: Obtaining list of data sources

rwunderlich — Mon, 29 Apr 2024 17:25:36 GMT

QRS is on-prem only.

-Rob