idea Re: JSON File type in Suggest an Idea

JSON File type

AndrewMcIlwrick — Wed, 25 Nov 2020 15:05:15 GMT

Add full support for JSON file type in same way as XML is supported - virtually nobody uses XML any more ?!?

Whilst there are various suggested workarounds using FROM_FIELD and table load, or REST connection all have limitations. Using the Data Connection wizard or the '+' / Add Data options it would be really nice if JSON could be parsed and loaded via the wizard.

Tableau provides this.

PowerBI provides this.

Re: JSON File type - Status changed to: Closed - Declined

Caique_Zaniolo — Mon, 20 Apr 2020 19:37:10 GMT

This is not something we will deliver as part of the exporting capabilities. JSON formats can be created using the APIs endpoints available on Qlik Sense.
Please refer to https://help.qlik.com/en-US/sense-developer/February2020/Subsystems/EngineAPI/Content/Sense_EngineAPI/introducing-engine-API.htm

Re: JSON File type

mountaindude — Fri, 15 May 2020 06:37:57 GMT

@Caique_Zaniolo

The API you refer to is great, but not quite the point of this suggestion I believe.

What I would REALLY appreciate (and what I think @AndrewMcIlwrick is also referring to) is the ability to interact with JSON (or YAML for that matter!!) formatted data as a file format.

Let's say you have a bunch of JSON files on disk and you need to load them into Sense. That's non-trivial right now, simply because Sense does not support JSON formatted files as a folder data source.

In the REST connector you can load JSON data just fine (love that feature, btw!), but not from files on disk.

I talked to some of Qlik's product guys about this... like two years ago and the response was "oh... that doesn't work?" At the time I got the understanding there was no technical or practical reason why this could not be implemented.

Sense supports loading XML and other formats from disk - so why not support the formats currently used by developers out there?

Re: JSON File type

AndrewMcIlwrick — Fri, 15 May 2020 06:21:12 GMT

Agreed ! An "average" user can really not be expected to use APIs to load a common data file format. Also re. product response - the two main competitors for Sense have this. Lack of JSON file loads remains a glaring gap in the product.