4 Replies Latest reply: Sep 25, 2017 5:27 AM by Simon Hogg RSS

    Can Qlik Sense read .JSON files?

    Amien Amien

      I know there is a REST Connector. But i need to enter a URL there. With HTTP or HTTPS protocol. Is it possible to link to a JSON folder or file?

       

      Thanks in advanced

        • Re: Can Qlik Sense read .JSON files?
          Simon Hogg

          Yes, absolutely it can (having just done it) but depending on your data structure it might be best not to as it can still involve a lot of editing.

           

          If your JSON data is in a file you should be able to just load it as any other flat table (csv, etc.) but you might have to split it out into sub-tables by hand.

           

          Worst case is probably having to load the JSON into something like MongoDB then load into Qlik from there (that's where I started!!!)