idea Re: Easy Json Reader - Status changed to: Open - Collecting Feedback in Suggest an Idea

Easy Json Reader

marcel_olmo — Wed, 25 Nov 2020 15:38:50 GMT

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.

Re: Easy Json Reader

John_Teichman — Thu, 14 May 2020 07:28:43 GMT

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.

Re: Easy Json Reader

mountaindude — Fri, 15 May 2020 05:18:52 GMT

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.

Re: Easy Json Reader

marcel_olmo — Sat, 16 May 2020 10:13:30 GMT

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.

Re: Easy Json Reader

AndrewMcIlwrick — Tue, 19 May 2020 08:40:45 GMT

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 ?

Re: Easy Json Reader - Status changed to: Open - Collecting Feedback

P-O_Davidson — Fri, 20 Nov 2020 20:49:38 GMT

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.

Re: Easy Json Reader

onebot88 — Mon, 23 Nov 2020 09:30:40 GMT

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!

Re: Easy Json Reader

AndrewMcIlwrick — Mon, 18 Oct 2021 17:40:14 GMT

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.

Re: Easy Json Reader

marcel_olmo — Wed, 10 Nov 2021 15:11:12 GMT

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.

Re: Easy Json Reader

Helmut — Thu, 28 Apr 2022 13:25:07 GMT

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.

Re: Easy Json Reader - Status changed to: Open - On Roadmap

Ian_Crosland — Mon, 13 Feb 2023 15:00:43 GMT

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:23:53 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Easy Json Reader - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:23:55 GMT