Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
gren
Contributor
Contributor

API call from Qliksense

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. 

 

Labels (2)
4 Replies
ajaykakkar93
Specialist III
Specialist III

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)

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

gren
Contributor
Contributor
Author

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

gren
Contributor
Contributor
Author

Any pointers from others who had done would be helpful.  

ajaykakkar93
Specialist III
Specialist III

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

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting