Google Analytics 4 and Data API v1 via REST resource issue

bqst · January 31, 2025, 9:33am

Hello !
I need help integrating the Google Analytics Data API to retrieve GA4 data.

Goal:

Integrate Google Analytics 4 via Data API into Retool resource

Steps:

Enable the Google Analytics 4 Data API and get my credentials.json from Google Analytics Data API v1 (API Quickstart | Google Analytics | Google for Developers)
Add service account to the Google Analytics property (XXX@XXX.iam.gserviceaccount.com)
On Retool, create a REST API resource with
- Base URL: https://analyticsdata.googleapis.com/v1beta/
- Headers: Content-Type: application/json and charset: utf-8
- Authentication: Google Service Account and my credentials.json content as Service account key
- Service Account OAuth Scopes: https://www.googleapis.com/auth/analytics.readonly
Then, in my App :
- Select my resource
- POST → {PROPERTY_ID}:runReport
- Body → Raw

{
  "dateRanges": [{ "startDate": "2024-09-01", "endDate": "2024-09-15" }],
  "dimensions": [{ "name": "country" }],
  "metrics": [{ "name": "activeUsers" }]
}

Details:
Here's the error I'm getting back

{
  "message": "<!DOCTYPE html>\n<html lang=en>\n  <meta charset=utf-8>\n  <meta name=viewport content=\"initial-scale=1, minimum-scale=1, width=device-width\">\n  <title>Error 404 (Not Found)!!1</title>\n  <style>\n    *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}\n  </style>\n  <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n  <p><b>404.</b> <ins>That’s an error.</ins>\n  <p>The requested URL <code>/v1beta/{PROPERTY_ID}:runreport</code> was not found on this server.  <ins>That’s all we know.</ins>\n"
}

Note: I am replacing {PROPERTY_ID} with my actual GA PROPERTY ID

Am I missing something ?
Thank you for your help !

Isaac-H · January 31, 2025, 10:53am

Hey there!

If you're getting HTML back from a rest API query, then usually the URL is misconfigured or you're hitting rate limits. In this case it looks like a 404, so most likely a URL issue.

Took a quick stab at this with a test project and it seems to be working like this:

Perhaps it just needs the /properties/ in front.

N.B I'm also using OAuth 2 with https://www.googleapis.com/auth/analytics for my scopes to rule out any permissions issues.

Either way, it should just be a URL config issue.

Cheers,
Isaac

bqst · January 31, 2025, 1:24pm

Hey Isaac,

You were absolutely right! The issue was that I forgot to include /properties/ in the URL. Google’s documentation got me this time!

Thanks a lot for your help, really appreciate it!

Cheers,
Bastien