topic Re: Loading Json! in QlikView

Loading Json!

Wed, 25 Nov 2020 16:16:04 GMT

Hi guy!,

I want to retrieve data from api and some of api return without tables name in json string. And the script I found out from qlik community need to set the arrayname. So I modified some part of that javascript and try to load all data from json. But it cannot load into qlikview. In my view, the problem may be qlikview cannot detect the tables. So Is there any way to create dynamic? Here is the script and out put, May I get some help? Thanks

Re: Loading Json!

marcus_sommer — Mon, 27 Mar 2017 13:19:03 GMT

Your output from the function returned no "classical" table-structure. Therefore I suggest to adjust the function to an output like:

Field1 Field2 Field3

Value1 Value2 Value3

I think you could convert the origin structur also with advanced qlikview scripting, for example by replacing:

},{ through } & chr(10) & { to get a line-break between the records and then using various subfield() functions to split the fields and values within them and afterwards you merged everything together again.

- Marcus

Re: Loading Json!

mato32188 — Mon, 27 Mar 2017 13:59:57 GMT

Hi Zwe,

there is great Qlik Web connector package that contains also Qlik General Web connector. It is Windows service (localhost:5555 by default) that enables to convert JSON to xml or standard table readable by QlikView. You can download it from qlik.com.

Martin

Re: Loading Json!

sravanthialuval — Mon, 27 Mar 2017 14:06:20 GMT

Hi,

Using REST Connector we can load the JSON data into Qlikview.

Re: Loading Json!

Frank_Hartmann — Mon, 27 Mar 2017 18:31:38 GMT

Hi,

have a look at the attached sample.

just add an arrayname in maintable and use your json2csv function in Resident Load.

hope this helps.

Re: Loading Json!

Tue, 28 Mar 2017 01:35:13 GMT

Thanks You so much Marcus, I will try it.

Re: Loading Json!

Tue, 28 Mar 2017 01:36:25 GMT

Thanks for your answer Martin, I will try it also.

ZWE

Re: Loading Json!

Tue, 28 Mar 2017 01:39:57 GMT

Thanks You Frank, It work well if I put arrayname, but the problem is nested json. So I finding some way to do. Thanks for your answer Frank.

ZWE

Re: Loading Json!

Tue, 28 Mar 2017 01:40:36 GMT

Thanks for let me know this tool sravanthi.

Zwe