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.