Qlik Community

Ideas

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

Easy Json Reader

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.

4 Comments
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.

Luminary
Luminary

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.

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.

Luminary
Luminary

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 ?