Skip to main content

Suggest an Idea

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE

Easy Json Reader

marcel_olmo
Partner - Specialist II
Partner - Specialist II

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.

9 Comments
John_Teichman
Former Employee
Former 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 - Specialist II
Partner - Specialist II

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 - Contributor II
Partner - Contributor II

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!

 

AndrewMcIlwrick
Luminary Alumni
Luminary Alumni

This is indeed a duplicate of https://community.qlik.com/t5/Suggest-an-Idea/JSON-Load/idi-p/1822528 but there are more votes here on Marcels. It's a shame we cannot combine them. Its sad that yours was raised nearly 18 months ago without traction.

marcel_olmo
Partner - Specialist II
Partner - Specialist II

Hi @P-O_Davidson , how many likes do we need to know if this idea is going to pass to the next level?

Best regards, Marcel.

Helmut
Partner - Contributor III
Partner - Contributor III

I'm also on the side, that this should be possible out of the box in the year 2022 in a leading analytics platform.

Nevertheless using the Qlik Web Connectors (General Web Connector > JsonToXmlRaw), some additional Qlik Code and the REST Connector it is possibe, BUT cumbersome.