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:
- 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.