Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am newbie to QLIK.
I was able to create an extension.
I called a Restful Webservice API that returns a json string.
I want to populate QLIK table with the results. How to do that?
Is there a special json format that QLIK understand to populate the table?
Please let me know the steps or point me to an example so that I can use.
Thank you.
You can use the Rest Connector to retrieve the data from the webservice. See the online help: REST ‒ Qlik Connectors
Thank you Gysbert.
So if I use the Rest Connector to retrieve the data from my webservice for example List of orders. Then I display the data in a table in QLIK sense (Order List).
Now when I click on a record on my Order List, I need to make another REST call and get the order details for that order. How should I pass the Order ID to my Subsequent REST call to get the order details for that order.
Please advise.
Thank you.
Uhm, you don't. Qlikview is not a real time live query system. The idea is that you first retrieve all the data from the sources and create a data model in the Qlikview document that will contain all the data in-memory. Then you interact with that in-memory data model with charts, listboxes etc. So you should make all the subsequents REST calls during the load script execution.