Forum Discussion
Automation of MailFlow Status Report via REST
Hi, I am looking for a way to automate the pulling of the MailFlow Status report but I've not been able to find anything that works. There appears to be an old reporting service on https://reports.office365.com however I've read reports its end of life and there is no useful documentation for it.
The main metrics I'm looking to export on a monthly basis are: Total mail in/out, Total spam detected in, Total Malware in etc. I'd need these details filtered for the previous month (01/xx/xx - 31/xx/xx) so can use this in our business wide reporting and would need to be available via a REST API.
Is this information available via the Graph? From what I can see under the https://graph.microsoft.com/beta/reports/ endpoint there doesn't seem to be a useful report. What are other organisations doing in this space to report on these metrics outside of the Microsoft ecosystem? From what I have found the only option is to download the excel data after running the GUI report each month manually. Can anyone point me in the right direction, it seems impossible this isn't available somewhere in way that can be automated, it is 2022 after all.
- It's not going away yet, in fact they added OAuth support for it recently: https://www.michev.info/Blog/Post/4067/modern-authentication-oauth-support-for-the-reporting-web-service-in-office-365
The alternative is to get the full span of message trace events and built the reports yourself.VasilMichev Do you know where the updated/latest documentation is so I can figure out whether or not the MailFlowStatus report is going to give me the specific details I need and what odata filters I can use to set a start & end date for the data or whether I need to message trace every message and build the numbers myself. So far after just playing around with the endpoints I cant figure out how to get more than 7 days worth of data. Until I read your OAuth notes I didn't even know the $metadata endpoint existed. Seems very weird that the modern UI reports are not available via any kind of documented API or on the Graph.
- The UI reports are not based on this data afaik, they use an internal API we don't have access to. The documentation for the old reporting web service hasn't changed, the only bits they've updated in the past few years are the OAuth support ones. https://learn.microsoft.com/en-us/previous-versions/office/developer/o365-enterprise-developers/jj984342(v=office.15)
