GA4 without client library, using ColdFusion, getting 404 error

Question

I am working in ColdFusion, trying to convert our code to pull from GA4 instead of UA data.

I don't know how to give a minimally reproducible example, without giving security info.

My JSON looks like this: {"DATERANGES":[{"endDate":"2023-02-20","startDate":"2023-01-01"}],"METRICS":[{"name":"activeUsers"}],"DIMENSIONS":[{"name":"country"}]}

I am posting to this:

<cfhttp url="https://analyticsdata.googleapis.com/v1beta/properties/XXXXX:runReport" method="post" timeout="15">
    <cfhttpparam type="header" name="Authorization" value="Bearer #access_token#">
    <cfhttpparam type="header" name="Content-type" value="application/json">
    <cfhttpparam type="formfield" name="reportRequests" value="#jsonText#">
</cfhttp>`

To get my access_token, I am posting to https://accounts.google.com/o/oauth2/token:

<cfhttp method="post" url="https://accounts.google.com/o/oauth2/token" Result="call2data">

    <cfhttpparam type="formfield" name="refresh_token" value="#get_token.refresh_token#">
    <cfhttpparam type="formfield" name="client_id" value="#oauth_client_id#">
    <cfhttpparam type="formfield" name="client_secret" value="#oauth_client_secret#">
    <cfhttpparam type="formfield" name="grant_type" value="refresh_token">

</cfhttp>

I have tested the code to refresh my access_token, and I do get a new access_token everytime, so that code is working.

When I post this code, I get back a 404 error, with this message: "The requested URL /v1beta/properties/XXXXXXX%3ArunReport was not found on this server. That’s all we know."

If I put "123456" in as the access_token in the header, I also get back that same error, so it does seem that the POST is failing on the URL, not on Authorization.

The code DOES work when posting to the API Explorer at https://developers.google.com/analytics/devguides/reporting/data/v1/rest/v1beta/properties/runReport If I enter properties/XXXXXX as the property and

{
  "metrics": [
    {
      "name": "activeUsers"
    }
  ],
  "dimensions": [
    {
      "name": "country"
    }
  ],
  "dateRanges": [
    {
      "startDate": "2023-01-01",
      "endDate": "2023-02-20"
    }
  ]
}

as the request body, I get correct results returned.

However, the API explorer POSTs to https://content-analyticsdata.googleapis.com/v1beta/properties/XXXXXX:runReport?alt=json I tried POSTing to that URL, but got the same error message.

I assume that I am missing something blindingly obvious?? Any ideas, suggestions, war stories would be greatly appreciated. Of course if anyone has an example of accessing GA4 without a client library, that would be awesome.

I’ｍ facing the same problem. Did you solve it?

rluisr
– rluisr

2023-05-06 15:45:49 +00:00
Commented May 6, 2023 at 15:45 — rluisr
– rluisr, Commented May 6, 2023 at 15:45

freddybob · Accepted Answer · 2023-07-11 11:58:07Z

1

I had this problem, it is because of the colon in the URL.

cfhttp automatically changes :runReport to %3ArunReport which causes a 404.

If you are using Lucee, you can stop this behaviour with the encodeUrl="false" parameter.

answered Jul 11, 2023 at 11:58

freddybob

1263 bronze badges

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

Comments

Greg Seedsman · Accepted Answer · 2023-05-08 07:12:18Z

I can't get mine to work as a formfield named reportRequests. Your JSON should be sent as the POST "body".

<cfscript>
    requestJSON = {
       "dateRanges": [{ "startDate": "2023-01-01", "endDate": "2023-03-14" }],
       "dimensions": [{ "name": "sourceMedium" }, { "name": "transactionId" }, { "name": "date" }, { "name": "defaultChannelGroup" }, { "name": "campaignName"}],
        "metrics": [{ "name": "purchaseRevenue" }]
    };
    
    cfhttp(method = 'POST', charset = 'utf-8', url = 'https://analyticsdata.googleapis.com/v1beta/properties/#brand.propertyId#:runReport', result = 'result') {
        cfhttpparam(name = 'Accept', type = 'header', value = 'application/json');
        cfhttpparam(name = 'Authorization', type = 'header', value = 'Bearer #accessToken#');
        cfhttpparam(type = 'body', value = serializeJSON(requestJSON));
    }
                
    GA4Data = deserializeJSON(result.fileContent);
</cfscript>

Collectives™ on Stack Overflow

GA4 without client library, using ColdFusion, getting 404 error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related