topic Re: Submit Multiple Rest API's request at a time using One Rest connection of Qlik Sense in Qlik Automate

Submit Multiple Rest API's request at a time using One Rest connection of Qlik Sense

Akhtar — Sat, 04 May 2024 06:27:17 GMT

Hello everyone,

I have a practical scenario where i need to extract data using Rest connection for almost 200 API's provided by Oracle Fusion cloud.

Suppose for every table i need to create a rest api connection which will increase qlik number of connections upto 200 and so on, Is there any smart approach by using which i can send multiple API's request using only single Rest connection of Qlik Sense.

Thanks

Akhtar

Re: Submit Multiple Rest API's request at a time using One Rest connection of Qlik Sense

rubenmarin — Sat, 04 May 2024 13:59:33 GMT

Hi, you can use 'WITH CONNECTION' to change connection parameters like the url, so the same connetion can be reused many times.

You can have a table (inline, excel, sql...) with the different values of the url you wnt to change, and iterate the values of that table to load the different modules.

As an example: https://community.qlik.com/t5/Design/REST-connector-Using-WITH-CONNECTION/ba-p/1523257