Microsoft-graph-docs: Filtering by date not working in bookings appointments

Created on 6 Jul 2018  路  3Comments  路  Source: microsoftgraph/microsoft-graph-docs

I tried to get appointments filtering by date but I get 400 error code (message: "This filter query is not supported."). There are urls:
https://graph.microsoft.com/beta/bookingBusinesses/<id>/appointments?$filter=start/dateTime eq '2018-06-07T06:50:02.0000000Z'
https://graph.microsoft.com/beta/bookingBusinesses/<id>/appointments?$filter=start/dateTime gt datetime'2018-06-07T06:50:02.0000000Z'
https://graph.microsoft.com/beta/bookingBusinesses/<id>/appointments?$filter=start/dateTime gt '2018-06-07T06:50:02.0000000Z'

Also filtering by null is impossible, for example:
https://graph.microsoft.com/beta/bookingBusinesses/<id>/appointments?$filter=customerPhone eq null
returns 500 error code with message "An error has occurred.".

bookings product

All 3 comments

@fpintos could you share any insight here?
There doesn't seem to be a known limitation here for this https://developer.microsoft.com/en-us/graph/docs/concepts/known_issues#bookings

Filtering by dates should be done by using calendarView.

We'll investigate what is going on with the null case.

Hi @Chotimir , the fix to filter by 'eq null' and 'ne null' has been deployed.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

climam picture climam  路  4Comments

aaronrogers picture aaronrogers  路  3Comments

findyoucef picture findyoucef  路  4Comments

mlafleur picture mlafleur  路  3Comments

andrewfabrizi picture andrewfabrizi  路  3Comments