QlikSense AWS Json parsing

mansoorjtax — Tue, 30 Jul 2019 23:44:52 GMT

We have recently setup AWS and are trying to parse JSON data that is stored in S3 buckets into QlikSense (not sure where exactly the database is located). Company directive is to use available QlikSense features to parse the JSON data which is stored in a column. I have completed reading through most of the community discussions around this and also successfully parsed nested JSON in Qlikview using macros but unable to parse the data in QlikSense.

I am uncertain what should be the URL for the REST connector configuration as the data is stored in AWS.

I have also tried accessing JSON data by setting up the ODBC driver by following https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html . Was able to get to the table but that JSON data column does not show anything (see attached document) in QlikSense

QlikSense output

whereas the same column in Athena is showing JSON data.

Athena output

In Athena, we are able to parse the JSON column using a presto function

Athena JSON function

My goal is to be able to parse JSON data stored in S3 regardless of the JSON structure or be able to use Athena functions in QlikSense.

Any help is greatly appreciated.

topic QlikSense AWS Json parsing in Integration, Extension & APIs

QlikSense AWS Json parsing