topic Re: API call from Qliksense in App Development

API call from Qliksense

gren — Tue, 12 Sep 2023 02:50:33 GMT

hi,

Is it possible to do an API call from qlik sense and pass a specific value from the sheet?

More details- There is an API which takes say OrderNO and performs some task. I have a list of order nos in my qliksense sheet. I wanted to give user an option to select an OrderNo and call the API and pass that value. I dont necessarily need to wait for the API to complete its action, Just pass the value and done.

Any pointers would be helpful.

Re: API call from Qliksense

ajaykakkar93 — Tue, 12 Sep 2023 05:50:52 GMT

Hi,

What i understand is to call /trigger the API from qlik sense application and pass that value as parameter ?

If that is the case then you can use the below extension to perform that task

InputForm Extension for qlik sense

Note: API should have the below checklist

HTTPS
SSL
whitelisted In both environments (qlik sense & API server)

Re: API call from Qliksense

gren — Tue, 12 Sep 2023 14:52:32 GMT

Thanks Ajay. Can you please give a sample qliksense file with this? that would be helpful..

Re: API call from Qliksense

gren — Tue, 12 Sep 2023 14:56:15 GMT

Any pointers from others who had done would be helpful.

Re: API call from Qliksense

ajaykakkar93 — Wed, 13 Sep 2023 02:47:09 GMT

Hi,

It's a DIY form please look at the options at https://github.com/ajaykakkar93/InputForm#readme

That will help,

The API checklist

HTTPS: it runs on port 443 configuration on a server where your API is places
SSL: An SSL certificate is a digital certificate that authenticates a website's identity and enables an encrypted connection
whitelisted In both environments (qlik sense & API server) : for qlik sense follow the below checklist
- Go to QMC
- Virtual Proxy
- Central Proxy
- Check the option of "Advanced"
- Scroll to the option "Host allow list"
- Add your System IP / URL without HTTPS
- Add the below in the option "Additional response headers"
  - Access-Control-Allow-Origin: *

You are good to go