Google Analytics Error - Request had insufficient authentication scopes

Problem

Sometimes you might get the following error while generating the token using Google-Connection Manager for  SSIS Google Analytics Source

Test Failed: The remote server returned an error: (403) Forbidden.
Response Url: https://www.googleapis.com/analytics/v3/metadata/ga/columns

Status Code: Forbidden

Response Body: {
"error": {
"code": 403,
"message": "Request had insufficient authentication scopes.",
"errors": [
{
"message": "Insufficient Permission",
"domain": "global",
"reason": "insufficientPermissions"
}
],
"status": "PERMISSION_DENIED",
"details": [
{
"@type": "type.googleapis.com/google.rpc.ErrorInfo",
"reason": "ACCESS_TOKEN_SCOPE_INSUFFICIENT",
"domain": "googleapis.com",
"metadata": {
"service": "analytics.googleapis.com",
"method": "analytics.gaapi.v3.AnalyticsMetadataColumns.List"
}
}
]
}
}

Possible Cause

If the user misses selecting the "See and download your Google Analytics data." checkbox (shown below screenshot) while using  Google connection manager for Google Analytic Source  then it shows an error as mentioned above

Possible Solutions

To fix this error you must select the "See and download your Google Analytics data." checkbox while generating the token using Google Connection Manager for Google Analytics Source shown above.

Contact Us

If you have more question(s) feel free to contact us via Live chat or email at [e-mail]

https://zappysys.com/support/