Is it possible to filter the columns received from the report apis in ms graph?

paaz 25 Reputation points
2023-04-07T15:58:09.18+00:00

I'm wondering if it is possible to filter specific columns from the report api requests. As an example, say I was going to use the api request "GET https://graph.microsoft.com/v1.0/reports/getTeamsUserActivityUserDetail(period='D7')" found on this page of the api doc https://learn.microsoft.com/en-us/graph/api/reportroot-getteamsuseractivityuserdetail?view=graph-rest-1.0. The doc says when successful this request would produce and return a csv file with numerous different columns all by user. Is it possible for me to alter the api request in a way that the csv file produced and returned only contains 1 specific column, say "Call Count", for all the users?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,273 questions
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2023-04-07T17:12:28.5533333+00:00

    Hello paaz,

    Thanks for reaching out!
    Currently it is not possible to filter the columns received using getTeamsUserActivityUserDetail API.
    You can Export the data in CSV format and filter the "Call Count" column instead.

    Hope this helps.
    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.