JSON-format is not directly supported by QlikView 11.20.
You could follow one of these routes to get it:
1) You can use the JScript (JavaScript) in the Macro Module to convert from and to JSON. JSON is an acronym for JavaScript Object Notation and it uses the object declaration format in JavaScript as a way of storing more "complex" data. So it is rather straightforward to use the JavaScript to convert back and forth - although only for Javascript capable programmers. This when implemented can be used both as functions being called from the load script while reloading or it could be used as macros being called upon by the GUI application while running.
2) A JSON-connector that has been made available on this forum: JSON connector example.zip
Not supported by Qlik.
3) A Connector Wrapper on Qlik Branch: Connector Wrapper (with JSON example)
Made by a Qlik employee on his spare time - not supported by Qlik as a company.
4) QV Source has a commecial third-party connector for a general JSON web API-connector.
5) Wait for QlikView 12 since it will have support for JSON directly.
6) Use a utility to pre-process or post-process the JSON files and convert them to and from a format QlikView knows.
Depending on your requirements maybe one or more of these routes are viable routes to follow for you....
Hope this helps...
- Petter
