Microsoft Graph - Error when using multiple filters for CalendarView

Viewed 2263

I try to get a CalendarView which is filtered by both sensitivity and lastModifiedDateTime, but the graph API is failing when both filters are applied at once. If I run the query with one filter at a time, it works as expected. Through testing, I've discovered that it's lastModifiedDateTime that causes the error.

I haven't been able to find any documentation where it says, that when filtering on lastModifiedDateTime, only one filter is supported.

I run the queries through the Graph Explorer.

Query that fails:

2 filters applied, one is lastModifiedDateTime

https://graph.microsoft.com/v1.0/me/calendarview
  ?startdatetime=2018-10-28
  &enddatetime=2018-10-30
  &$filter=sensitivity eq 'normal' and lastModifiedDateTime ge 2018-10-29T00:00:00Z

It fails with the following error:

{
    "error": {
        "code": "ErrorInternalServerError",
        "message": "An internal server error occurred. The operation failed.",
        "innerError": {
            "request-id": "<GUID>",
            "date": "<DateTime>"
        }
    }
}

Queries that works:

Single filter on sensitivity

https://graph.microsoft.com/v1.0/me/calendarview
  ?startdatetime=2018-10-28
  &enddatetime=2018-10-30
  &$filter=sensitivity eq 'normal'

Single filter on lastModifiedDateTime

https://graph.microsoft.com/v1.0/me/calendarview
  ?startdatetime=2018-10-28
  &enddatetime=2018-10-30&
  $filter=lastModifiedDateTime ge 2018-10-29T00:00:00Z

2 filters, but not lastModifiedDateTime

https://graph.microsoft.com/v1.0/me/calendarview
  ?startdatetime=2018-10-28
  &enddatetime=2018-10-30
  &$filter=importance eq 'normal' and sensitivity eq 'normal'

I hope someone can help me, or clarify why it doesn't work with more than one filter when lastModifiedDateTime is involved.

0 Answers
Related