topic Re: how to import the JSON in QlikView

how to import the JSON

sanka123 — Sat, 16 Nov 2024 02:29:00 GMT

I am new to Qlikview. need to create the report based on the JSON files. and please find the sampler JSON format. please help me on the script

{"Header":{"Type":"BS","Ver":"2.0"},"Instruction"
:{"Header":{"Type":"ABCD","Time":"2013-12-
05T12:32:36.588+0200","Tid":13489709,"Fid":9382817,"Uid":
952415,"Sid":1386008738698,"User":"ID:10001/MM","RU"
:"ID:10001/MM"},"Amount":25000,"

Re: how to import the JSON

Vegar — Sun, 15 Sep 2019 05:45:03 GMT

If the json is a web resource then you can use the Qlik Rest Connector, if it is a local file then it is a bit more complicated.

For local sources take a look at @Frank_Hartmann solution in this thread How to load local JSON file into Qlik Sense

Re: how to import the JSON

Brett_Bleess — Thu, 26 Sep 2019 13:25:05 GMT

Sanka, did Vegar's post and links help you get things working? If so, be sure to circle back and use the Accept as Solution button to give him credit and let others know this helped you. If you are still working on things and need further help, provide an update on where you stand, and if you did something else, consider posting that and mark that as the solution for future visitors to the post.

Regards,
Brett