Suggest an Idea

[marcel_olmo]

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.

[John_Teichman]

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]

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]

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]

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]

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.

[onebot88]

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]

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]

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]

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.