Is it possible to interpret JSON data directly with Qlik Script when it does not come from a REST API?

[Anonymous]

Is it possible to interpret JSON data directly with Qlik script when it does not come from a REST API?

Environments:

QlikView
Qlik Sense Enterprise on Windows

There is no way to interpret JSON data directly in the Qlik script. Simply the functionality - a parser - does not exists in Qlik Engine.

In order to load JSON data, please consider:

1. Use the Qlik Web Connectors: General Web Connector
2. Host the JSON file on a web server, where the JSON file can be access via a http or https URL
3. Load the URL into QlikView or Qlik Sense using Qlik REST connector

REST connector is included in the default installation of Qlik Sense. For QlikView, REST connector can be downloaded from Qlik download site.

For more information about the REST connector see REST Connector.

[p_verkooijen]

Or use the QlikWebconnectors.
General Web Connector can read JSON files from your local machine.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...

• Allows you to read files (for example, JSON files) directly from your local machine.