Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
romeop
New Contributor

How to parse JSON file

Hi,

is there a way to parse a JSON file like this?

{"error":[],"result":{"XETHZEUR":[[1550910600,"128.83","128.84","128.71","128.72","128.75","926.43406754",62],[1550911500,"128.72","128.72","128.71","128.71","128.71","1059.62385678",47],[1550912400,"128.71","128.72","128.71","128.71","128.71","175.02881442",39],[1550913300,"128.72","128.74","128.50","128.51","128.65","1581.71128106",89],[1550914200,"128.51","129.35","128.22","129.35","128.76","1624.74361491",182],[1550915100,"129.35","129.91","129.15","129.78","129.63","300.48145121",109],[1550916000,"129.78","129.96","129.58","129.71","129.77","315.67284410",72],[1550916900,"129.71","129.91","129.64","129.84","129.78","285.05113479",33],[1550917800,"129.84","130.00","129.71","130.00","129.87","297.65317789",53],[1550918700,"129.99","130.49","129.99","130.10","130.26","1595.54489031",231],[1550919600,"130.24","130.25","129.92","130.01","130.06","320.77938029",56],[1550920500,"130.01","130.06","130.00","130.05","130.03","31.80359879",20],[1550921400,"130.06","130.06","129.90","129.91","130.01","186.60557641",65],[1550922300,"129.91","130.43","129.71","129.90","130.01","2692.90238707",136],[1550923200,"129.84","130.09","129.54","129.92","129.87","658.13616374",109],[1550924100,"129.92","130.06","129.63","129.95","129.88","1886.04736907",95],[1550925000,"129.96","130.20","129.93","130.01","130.16","1347.69209683",44]],"last":1550924100}}

 

Better option is using onedrive connector to access the file on a remote folder but also load from local folder is good!

Many thanks

1 Reply
Partner
Partner

Re: How to parse JSON file

Hi,

Yes, this is possible with Qlik Web Connectors (QWC).

First thing to do is to create a connection from QWC to your OneDrive (where json file is stored), once you passed authentication check file ID and use getRawBinary method and "Run Table" - QWC will bring you a URL.

Pass this URL to REST connector (choose Windows NTLM authentication and pass empty credentials).

Result should be similar to below:

40608.PNG

Hope this helps.

//Andrei