当API没有记录时，Google GA4 batchRunReports抛出500 (内部服务器错误)

Question

https://developers.google.com/analytics/devguides/reporting/data/v1/rest/v1alpha/TopLevel/batchRunReports

请求:

{
"entity": {
    "propertyId": "XXXXXXXX"
},
"requests": [
    {
        "entity": {
            "propertyId": "XXXXXXXX"
        },
        "dimensions": [
            {
                "name": "date"
            },
            {
                "name": "dateHour"
            },
            {
                "name": "firstUserCampaignName"
            }
        ],
        "metrics": [
            {
                "name": "sessions"
            }
        ],
        "dateRanges": [
            {
                "startDate": "2021-04-06",
                "endDate": "2021-04-07"
            }
        ],
        "metricAggregations": [
            "TOTAL"
        ],
        "dimensionFilter": {
            "andGroup": {
                "expressions": [
                    {
                        "filter": {
                            "fieldName": "medium",
                            "stringFilter": {
                                "matchType": "EXACT",
                                "value": "Test"
                            }
                        }
                    }
                ]
            }
        },
        "orderBys": [
            {
                "desc": true,
                "metric": {
                    "metricName": "sessions"
                }
            },
            {
                "desc": false,
                "dimension": {
                    "dimensionName": "dateHour"
                }
            }
        ],
        "keepEmptyRows": true
    }
]

}

响应：

{
"error": {
    "code": 500,
    "message": "Internal error encountered.",
    "status": "INTERNAL"
}

}

但如果从请求中删除以下属性：

 "metricAggregations": [
            "TOTAL"
        ],

在没有行的情况下，我可以看到以下响应：

{
"reports": [
    {
        "metricHeaders": [
            {
                "name": "sessions",
                "type": "TYPE_INTEGER"
            }
        ],
        "metadata": {},
        "dimensionHeaders": [
            {
                "name": "date"
            },
            {
                "name": "dateHour"
            },
            {
                "name": "firstUserCampaignName"
            }
        ],
        "kind": "analyticsData#runReport"
    }
],
"kind": "analyticsData#batchRunReports"

}

知道在这种情况下如何防止500个内部服务器错误吗？

此错误阻止google调用一个小时。

Answer 1

如果生成的报告为空，那么使用metricAggregations的调用失败的数据API似乎存在一个问题。同时，要解决此错误，可以修改查询，以便生成的报表包含超过0行。