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.of...
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)
Hmm getting a 404 on that link, looks like it may not have copied all of it.
In that case do you know what filter options I have to do on the MailFlowStatus to get say 01/10/22 to 31/10/22 stats? Every option I try ends up as a filter error based on random articles I've found online (they are however for different reports so I'm not surprised the options are slightly different). Making random attempts along the following lines hasn't yielded any results
https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/MailFlowStatus?$format=json&$filter=StartDate%20eq%20%2701/10/2022%27%20and%20EndDate%20eq%20%2731/10/2022%27
- The forum formatted the closing ), you should add it as part of the URL.
It doesn't look like this report supports startdate/enddate filter. On the positive side, the same data is exposed via Get-MailFlowStatusReport.