Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
romeop
Contributor
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
crusader_
Partner - Specialist
Partner - Specialist

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