How to load json data in qliksense

[shus_lopez]

Hello everybody, i need to load data from json file in qlik sense, but i dont know how to do, i read in this forum maybe with rest connector but i dont achieve yet.

[stevedark]

Hi Jesus,

You are correct that you need to use the REST connector.  This is a separate download that you will need to make and install on the same machine you are running Sense.  You can download it from here:

https://da3hntz84uekx.cloudfront.net/RESTConnector/1.0/12/_MSI/QlikRESTConnector_x64setup.exe

The REST connector can only load from HTTP or HTTPS files, so you will need to ensure that your JSON file can be accessed in this way.  You can do this by putting your JSON file on a web server, or a cloud service that allows you to get a download link.

I have just tested this by putting a JSON file into dropbox, requesting a link, changing the download parameter from 0 to 1 and using that as the endpoint for the rest connection.

As the file is not secured at this point (it just has an impossible to guess file path) you can just enter than into the URL of the REST connector and leave all other fields blank.

Hope that gives you enough pointers to solve this.  Post back if not.

Cheers,

Steve

[nikhilgarg]

Hey Steve,

i am not able to load my JSon file this way. Can you help me knowing the steps to implement this?

[stevedark]

What have you tried so far? Is your JSON file available at a URL that the Qlik load script can see?

Is it data that can be shared, if so if you place it at a URL that is publicly available then I can test. If not you could try replicate the file with dummy data to try it.

[nikhilgarg]

Hey Steve,

It works fine. There was some structure issue.

[stevedark]

Glad it's working.  Thanks for posting here and letting me know.

[arvind1494]

Rest connector is the best way

[Suus]

You can read json files directly from a directory.

In QlikView this option was available from table load. In Sense it dissapeared.

The script still works though 😉

Here's an example

YSIS_BarthelScore:

    LOAD

    PatientID

      , Barthelscore

      , Datum_van_afname

      , MomentAfname

    from [lib://YSIS/barthelscore.json] (json, codepage is 1252, embedded labels);

• If you dont know the column names first perform a select*
• Create a connection to your directory

[stevedark]

That's a neat solution. Thanks for sharing Suzan.

Steve

[petter]

Just be aware that JSON is per definition required to be UTF-8 or it is not JSON. So codepage 1252 should be avoided actually.

One limitation of the json LOAD for QlikView and Qlik Sense is that it is not handling any kind of nesting. That means that it is only good for "flat" JSON files.