idea Re: JSON Load in Suggest an Idea

JSON Load

AndrewMcIlwrick — Thu, 15 Jul 2021 17:21:37 GMT

As one of the primary file types used by technologists it is so frustrating that people are still having to use the likes of XLSX or CSV to hold app configuration. XML is archaic.

https://community.qlik.com/t5/Suggest-an-Idea/JSON-File-type/idi-p/1667510 was my original post and I really do not think it should have been closed as the idea was nothing to do with exporting file format.

It is simply to add JSON files to the standard Load capability of Qlik Sense.

I remember listening to technology people in a previous job way back in 2014 saying they would not touch QlikView because of lack of direct JSON support. It is now 2021 and nothing has appeared for Qlik Sense, so again projects being promoted and managed by tech teams might question "why ?".

Re: JSON Load

devan9876 — Sun, 18 Jul 2021 00:06:10 GMT

I agree.

Would also be cool if the store command had the option to export to JSON too.

Re: JSON Load

AndrewMcIlwrick — Sun, 18 Jul 2021 17:18:08 GMT

Great idea - please submit it and you get a +1 vote from me. I think Qlik prefer one item per idea. Or is that one "object" 😉

Re: JSON Load

devan9876 — Sun, 18 Jul 2021 18:29:44 GMT

@AndrewMcIlwrick

From what I understand only luminaries and partners can post ideas.

I have a regular community account so I can just vote/comment on ideas not post them.

If you think it needs to be a separate idea post, I am ok if you want to take the idea and post it under your account.

Re: JSON Load

AndrewMcIlwrick — Sun, 18 Jul 2021 20:15:28 GMT

I think any registered user can create ideas - not sure why Qlik would want to restrict that - @Meghann_MacDonald ? PS I am neither a partner or a luminary.

Re: JSON Load

Meghann_MacDonald — Mon, 19 Jul 2021 12:46:32 GMT

Hi @devan9876 and @AndrewMcIlwrick , the ideas board is open to view and like from everyone with an account, but in order to post an idea you need to be a customer, partner, luminary etc. Registering with your Qlik customer account allows you access.

Re: JSON Load

i_shamaev — Wed, 25 Aug 2021 18:25:26 GMT

Sometimes I met that data in cell of database table was saved as json.

To extract data from a json file or json string it will be great if qliktech add this functionality.

Thanks for idea!

Re: JSON Load

juraj_misina — Mon, 30 Aug 2021 15:08:04 GMT

Hi @i_shamaev. You can use From_Field statement to load such json data, given that the json structure is flat. If it is not, you're doomed.

json file support is very limited and must be improved. +1 on this idea.

Re: JSON Load

Carl_Hunter — Tue, 21 Sep 2021 17:40:43 GMT

I used Power BI Desktop to manipulate the JSON exported from Qlik CLI when doing a Client-Managed to SaaS migration recently. Mad that I have to use another tool to interrogate the data Qlik CLI provides as Qlik Sense does not support JSON file formats...

Re: JSON Load

AndrewMcIlwrick — Tue, 21 Sep 2021 19:28:05 GMT

Agree 100% @Carl_Hunter it is one of the primary weaknesses of the Qlik Sense platform. Years old and no visible solution. So much of our infra config is built on JSON and we need powershell scripts to pre-process them.

Re: JSON Load

juraj_misina — Thu, 07 Oct 2021 10:57:33 GMT

I tried to load WebConnectors logs into Qlik yesterday and realized that Qlik's support for xml is pretty obsolete as well... It deserves some love (or QWCs logs should be in a different format)

Re: JSON Load - Status changed to: Open - On Roadmap

Ian_Crosland — Tue, 20 Dec 2022 15:42:02 GMT

Re: JSON Load - Status changed to: Open - On Roadmap

Ian_Crosland — Wed, 08 Feb 2023 10:06:52 GMT

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

Meghann_MacDonald — Wed, 02 Aug 2023 15:39:30 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: JSON Load - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:39:32 GMT