Loading Json!

[#1]

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

[marcus_sommer]

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

[mato32188]

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.

BR

Martin

[sravanthialuval]

Hi,

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

[Frank_Hartmann]

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.

[#6]

Thanks You so much Marcus, I will try it.

[#7]

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

BR

ZWE

[#8]

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.

BR

ZWE

[#9]

Thanks for let me know this tool sravanthi.

BR

Zwe