'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView

Mon, 26 Jan 2026 16:26:21 GMT

I have tried to connect QlikView to Google Analytics using the REST Connector several times but can't get the data from GA. I initially used the Google Analytics Reporting API v4, but I have also tried this with the older version 3 with the same outcome. I followed the documentation found here: https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_QV_help/Content/1.0/Create-REST-connection/Connection-examples.htm

I'm trying to get unique pageviews, pageviews, exit rate and bounce rate as the metrics and country, city and pagepath as dimensions. The date range in the test connection was the last 30 days. There is also a filter by pagepath matching a specific substring.

At first all seems to work fine and testing the connection comes back with a success status. When I then try to select the data it auto-detects it as CSV which is incorrect as it should be JSON. If I then change it in JSON it comes up with an error message that states that it cannot parse the response. As it does state that the connector supports JSON, I'm not sure what the problem here is.

I have attached some screenshots, too.

Re: 'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView

Mon, 09 Oct 2017 14:58:11 GMT

Hi Runa,

I am also facing the same error.

Did you get the solution for this error.

Thanks,

Sourabh

Re: 'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView

Demlet — Tue, 02 Jan 2018 15:22:00 GMT

I have the same issue as well.

. Any luck finding a solution?

topic Re: 'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView in QlikView

'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView

Re: 'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView

Re: 'Cannot parse data in selected response type'-error when trying to connect to Google Analytics using the REST Connector in QlikView