topic API call for Teams usage in Developer

API call for Teams usage

s-roberts — Fri, 14 Aug 2020 12:34:13 GMT

Without the GraphAPI connector in PBI, we have to build web api calls to fetch teams usage data from scratch.

What would be the API call to fetch usage by Team?

This is the call to fetch the usage by user (https://graph.microsoft.com/beta/reports/getTeamsUserActivityUserDetail(date=YYYY-MM-DD)), but a user can belong to many teams, so we are unable to summarize from this content.

Re: API call for Teams usage

lbendlin — Fri, 14 Aug 2020 18:00:26 GMT

"a user can belong to many teams, so we are unable to summarize from this content"

Please elaborate. You can run multiple API calls in Power Query and then combine the results.

Re: API call for Teams usage

s-roberts — Fri, 14 Aug 2020 18:18:07 GMT

The mentioned call provides an activity count by user and by day (not broken down by team).

When a user belongs to multiple teams, it would not be accurate to apply all the activities to each team. We'd need the portion of that activity that applies to each team.

Is there another call that would already have acitvity counts by team and by day (and possibly by user).

Re: API call for Teams usage

Anonymous — Wed, 19 Aug 2020 07:06:06 GMT

HI @s-roberts ,

I checked the official document but not found the api that shows each record without any aggregate.
Perhaps you can try to access the admin portal to confirm if any export feature that allow you to export the detail user activity logs.
Regards,

Xiaoxin Sheng