Extract reports through Graph API

Microsoft made it clear that MS Graph API will be the de facto for all API level access for office 365 workloads as well as Azure. They deprecated many exchange online powershell cmdlets and asked to move to MS Graphs. MS Graph has nice way to provide granular authorization. For an example if you want someone to just read some report then you can provide such access.

In this article we will extract IMAP usage report from MS Graph API using postman.

• Configure an app on https://portal.azure.com, This is required to have client secret. required in postman app.
• Provide necessary permission to extract reports.
• Install POSTMAN app.

https://www.getpostman.com/download?platform=win64

• Launch Postman
• Fill this information in ‘Get New Access Token’
• Get New Access Token
  • Token Name – Token Name
  • Grant Type – Authorization Code
  • Callback URL – https://localhost
  • Auth URL – https://login.windows.net/common/oauth2/authorize?resource=https%3A%2F%2Fgraph.microsoft.com
  • Access Token URL – https://login.windows.net/common/oauth2/token
  • Client ID – <this is application id>
  • Client Secret – <this will be shown in key section of app >
  • Scope – leave it blank
  • State – State
  • Client Authentication – Send as Basic Auth header
• Click on ‘Request Token’
• You will be asked to provide credentials of a user, who has authorization on requested data.
• If successful, you will be presented to ‘use token’ option.
• Now you can customize the different reporting details in GET Section with the level of authorization you were granted.
  • https://graph.microsoft.com/beta/reports/getEmailAppUsageUserDetail(period=’D180′)?$format=text/csv
• Body will show detail like below:

• Refer this article to get more type of reports through api :
  • https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/resources/report

Thank your for reading and provide your comments for improvement.