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

Anonymous — Wed, 30 Nov 2022 10:12:56 GMT

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

Environments:

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:

Use the Qlik Web Connectors: General Web Connector
Host the JSON file on a web server, where the JSON file can be access via a http or https URL
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.

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

p_verkooijen — Fri, 09 Jul 2021 10:20:15 GMT

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-Source-Connectors/General-Web-Connector.htm

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

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

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

Environments:

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