A lot of us want JSON to be read natively by Qlikview, and it simply doesn't support it out of the box. So, you can try the following:
- If the data you need retrieved is short and simple, you can try standard string parsing of the JSON
- You can try a cobbled-together JSON-to-XML solution like this one: http://blog.qvapps.com/2010/09/20/using-qlikview-with-web-services/
- I've let my Qlikview account rep know that this is the biggest need in an otherwise great product
- Chris Brain (who developed QVSource, a great 3rd-party API connector) indicated he may take a stab at integrating a JSON reader into a future version of QVSource
Good luck, futebol70
We have also added a solution for this now for our QVSource users: http://www.qvsource.com/wiki/General-Web-Connector-For-QlikView.ashx Would be interested in any feedback as it's just the first version.