Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

Easy Json Reader

marcel_olmo
Partner
Partner

Easy Json Reader

Hi guys,

I think it would be nice if we can add a json local file as easy as we can read a csv or txt file.

Best Regards, Marcel.

6 Comments
John_Teichman
Employee
Employee

Hello @marcel_olmo,

Thank you for your idea. There is a previous post with a similar idea. That idea has been declined. 

https://community.qlik.com/t5/Ideas/JSON-File-type/idi-p/1667510.

mountaindude
Luminary Alumni
Luminary Alumni

That previous idea was indeed declined, but I'd say it was declined based on a pretty incorrect rationale. 

The suggestion here is that it would be very useful to load data from JSON (or YAML for that matter) files residing in folder data connections. Just as Excel, csv, xml etc files can be loaded today.

XML.... come on. It's 2020. JSON and YAML rule today, of course QV/QS should be able to load JSON files from disk, anything else is just... strange.

Worth noting also that the REST connector loads JSON files just fine, but only from online sources. 
Sure, I could create a small http server that serve my json files and then load them using the REST connector (this is how I have solved this issue in the past).... but why? JSON support should be built-in.

marcel_olmo
Partner
Partner

I completely agree with you @mountaindude . I hope Qlik could consider our recommendations. As I see in the similar post @John_Teichman have sent me, the users have similar oppinions about hat.

Best regards, Marcel.

AndrewMcIlwrick
Luminary Alumni
Luminary Alumni

Agree 100% as mine at https://community.qlik.com/t5/Ideas/JSON-File-type/idi-p/1667510 was declined. The lack of JSON support is a huge feature gap in my opinion.

If Qlik genuinely will not provide this can we as a community work together to deliver it as an open source project ? We would need R&D guidance on the REST connector and API's. Just a thought ?

P-O_Davidson
Employee
Employee

This is certainly something that would make sense to add support for (it is indeed 2020). However, this is not in our short-term roadmap. Please show your support for this idea by clicking on the "like" button.

Status changed to: Open - Collecting Feedback
onebot88
Partner
Partner

Hi all!

Marcel is right, it would be really really usefull to have the possibility of just read a json file without having to connect through a rest api connection or developing something in open source (eventhough it would be great and fun).

Also, I would like to add that Power Bi already includes that feature by default since 2017...

So Marcel, you have my vote!