Authentication error when attempting to fetch google analytics 4 with app script

Question

I would like to connect a community connector to a google analytics 4 account so that I can easily modify the data and send it to data studio. However, My code is returning an authentication error:

{ error: 
   { code: 401,
     message: 'Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.',
     status: 'UNAUTHENTICATED' } }

I have included the token, but I am unsure if I am making the correct url call or if there is some other issue that I am unaware of. I don't believe I need an API key to connect from community connector to a google API, but I may be wrong. I did create an API key but the result was the same.

function testFetch(){
  var url = "https://analyticsdata.googleapis.com/v1alpha:runReport"
  var token = ScriptApp.getOAuthToken();
 
  var options = {
      "method" : 'POST',
      "entity": { "propertyId": "263290444" },
      "dateRanges": [{ "startDate": "2020-12-01", "endDate": "2021-03-01" }],
      "dimensions": [{ "name": "country" }],
      "metrics": [{ "name": "activeUsers" }],
      'muteHttpExceptions': true,
      headers: {
          Authorization: 'Bearer' + token,
        },
      };

  var response = UrlFetchApp.fetch(url, options);

  var result = JSON.parse(response.getContentText());
}

I think that the reason of your error message is due to Authorization: 'Bearer' + token,. In this case, please add a space between Bearer and token like Authorization: 'Bearer ' + token,. But from your script, I'm not sure whether your propertyId and token can be used for requesting to the endpoint. I apologize for this. — Tanaike
– Tanaike, Commented Mar 5, 2021 at 7:56
Does app script support authorization to that api? Can we see how you are authorizing the request? — Linda Lawton - DaImTo
– Linda Lawton - DaImTo, Commented Mar 5, 2021 at 8:23
@Tanaike The 401 error seemed to be caused by the Bearer token space. thank you for the help. — Shan
– Shan, Commented Mar 5, 2021 at 16:19

Martí · Accepted Answer · 2021-03-05 12:38:57Z

3

Here is a small guide on how to do what you are trying to achieve:

Set explicit OAuth scopes (see documentation) to your Apps Script project manifest (appsscript.json). In this case you need to add the following:

{
  ...
  "oauthScopes": [
    "https://www.googleapis.com/auth/script.external_request",
    "https://www.googleapis.com/auth/analytics.readonly"
  }
}

Then you need to separate the method parameters from the fetch options. The fetch options need to be stringified and added to payload. You also need to set the contentType to JSON.

const options = {
  entry: { propertyId: "263290444"},
  // etc.
}
const response = UrlFetchApp.fetch(
  'https://analyticsdata.googleapis.com/v1alpha:runReport',
  {
    method: 'POST',
    muteHttpExceptions: true,
    headers: {
      'Authorization': `Bearer ${ScriptApp.getOAuthToken()}`
    },
    contentType: 'application/json; charset=utf-8',
    payload: JSON.stringify(options)
  }
)

After that, you may use the response as you were doing before.

Note that Bearer and the token need to be separated by a space, which your code does not have. It's hard to see because of the concatenation and that why I usually use template literals (see documentation).

References

answered Mar 5, 2021 at 12:38

Martí

2,8911 gold badge6 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Shan Over a year ago

thank you for the help it was very helpful and solved the 401 error issue. However, I am now receiving a 403 error regardless of the property I try to connect to, do you have any advice on what could cause that?

Martí Over a year ago

@Shan HTTP 403 (Forbidden) means you lack permissions for some reason (there are quite a lot of them, actually). The response body should have an explanation. Also If you find new problems, I'd advise to make a new question instead of asking in answers ;)

Shan Over a year ago

Yeah I figured I should ask another question after I posted that comment, so I did and I managed to get it all working. Thanks for the help!

Collectives™ on Stack Overflow

Authentication error when attempting to fetch google analytics 4 with app script

1 Answer 1

References

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

References

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related