OData query for Office 365 reports not working as documented RRS feed

  • Question

  • I building a client for Office 365 reports, and have been consuming the Office 365 reports web service.  While all order reports take the OData query for Date in the correct 'yyyy-MM-dd', except StaleMailboxDetail.

    When I query for StaleMailboxDetail without any OData query I get a bunch of responses, few of which have a Date property set to '2016-12-06T00:00:00'. But when I query with $filter=Date eq datetime'2016-12-06T00:00:00' I get zero results.

    I thought I was using an incorrect Date format so I changed my query to '2016-06-12T00:00:00' and it started showing results with reports with Date property '2016-12-06T00:00:00'. Notice the format change from yyyy-MM-dd to yyyy-dd-MM. All other reports seems to accept yyyy-MM-dd, except StaleMailboxDetail. This behaviour does not align with the Date format documented.

    Do note, that even with this behaviour I cannot query for the date 13th November 2016 because a OData validation kicks in with invalid date format error, as the date is being passed in the months place.

    To me this looks like a bug that should affect all O365 tenants. Anyone else noticed this behaviour?

    • Edited by om9 Thursday, December 8, 2016 3:35 PM
    Thursday, December 8, 2016 3:32 PM