Populating QLIK Object with JSON

[#1]

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.

[Gysbert_Wassenaar]

You can use the Rest Connector to retrieve the data from the webservice. See the online help: REST ‒ Qlik Connectors

[#3]

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.

[Gysbert_Wassenaar]

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.