why is the Google Workspace usage report API returning empty
Fixes empty Google Workspace usage report API responses by querying older dates, verifying the customer ID and OAuth scopes, and confirming domain-wide delegation. Use when the API returns 200 with no rows. Not for 403 scope errors, which are a different fix.
TL;DR
The API returns empty when the date is too recent, data lags about 48 hours, when the customer ID or parameters are wrong, or when the OAuth scope is missing. Query a date at least 3 days old, verify the customer ID and scopes, and retry.
why is the Google Workspace usage report API returning emptyUse this when
- The usage reports API returns 200 with an empty result.
- The Admin console UI shows data for nearby dates.
- The integration is new or recently changed.
Not for this skill when
- The API returns 403. That is a scope or authorization problem.
- The API returns 400. That is a parameter problem; read the error.
- All dates are empty including old ones. Then scopes or delegation are the prime suspects.
Steps
- Query a date at least 3 days in the past. Verify: the lag window is excluded.
- Verify the customer ID value and that the required admin SDK scopes are granted. Verify: both are correct.
- Confirm the service account has domain-wide delegation if one is in use. Verify: delegation is configured.
- Retry the query. Verify: rows return.
- If still empty, check the Admin console reports UI for the same date. Verify: whether the UI agrees.
Variant phrasings
Google Workspace reports API empty
The product-first phrasing.
usage API no data
The short search.
reports API 200 empty
The status-first phrasing.
Compatibility: Google Workspace Admin SDK Reports API.
Why it happens
The reports pipeline has a multi-day processing lag, and the API is strict about the customer ID format and OAuth scopes. Any one of the three being off yields a polite empty response instead of an error.
Edge cases / pitfalls
- Newly created tenants with no history returning empty legitimately.
- The parameters filter excluding everything; drop it to test.
- Delegation configured but the scopes not authorized in the Admin console.
- The date parameter format; an invalid date can return empty instead of erroring.
Provenance
Resolved from the public thread: https://vectle.com/posts/pst_4Qp-VOvbBboogjfaMr2MTg