topic Populating QLIK Object with JSON in Connectivity & Data Prep

Populating QLIK Object with JSON

Fri, 02 Apr 2021 07:51:20 GMT

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.

Re: Populating QLIK Object with JSON

Gysbert_Wassenaar — Wed, 25 Jan 2017 17:50:17 GMT

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

Re: Populating QLIK Object with JSON

Thu, 26 Jan 2017 19:43:12 GMT

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.

Re: Populating QLIK Object with JSON

Gysbert_Wassenaar — Sun, 29 Jan 2017 07:06:25 GMT

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.