Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

shus_lopez
New Contributor II

How to load json data in qliksense

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.

9 Replies
MVP
MVP

Re: How to load json data in qliksense

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
Contributor III

Re: How to load json data in qliksense

Hey Steve,

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

MVP
MVP

Re: How to load json data in qliksense

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
Contributor III

Re: How to load json data in qliksense

Hey Steve,

It works fine. There was some structure issue.

MVP
MVP

Re: How to load json data in qliksense

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

arvind1494
Valued Contributor

Re: How to load json data in qliksense

Rest connector is the best way

swijnans
New Contributor III

Re: How to load json data in qliksense

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
MVP
MVP

Re: How to load json data in qliksense

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

Steve

MVP
MVP

Re: How to load json data in qliksense

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.

Community Browser