topic LOAD data into Qlikview from Web service in QlikView

LOAD data into Qlikview from Web service

stats101 — Tue, 19 May 2015 14:11:15 GMT

I read somewhere that Qlikview supports loading data directly from a web service using a LOAD call in the following format:

LOAD * FROM [http://mywebservice/setparam?param=$(ParamValue)]

I tried the below in my application, it however is populating the JSON document into a single column:

LOAD * FROM [http://finance.yahoo.com/webservice/v1/symbols/GSK,AAVL,AAWW,ABAC,ABAX,,ABCB,ABCD,MSFT/quote];

Am I doing something wrong?

Re: LOAD data into Qlikview from Web service

petter — Tue, 19 May 2015 21:21:55 GMT

No you are not doing anything wrong. What you get returned is actually not JSON - it is XML. The XML can be manually parse as I show below ... since this is a quite simple XML. However if you select web-files you can of course tell QlikView that what is returned is actually XML. The resulting tables will be a bit complicated but you get the data and you could use that too.