ODBC guide

Read unread messages

Gets only unread messages. Use SearchCriteria='IsRead eq false' in the WITH clause.

SELECT * FROM get_messages
WITH (UserID='firstname.lastname@domainname.com', SearchCriteria='IsRead eq false')

--Check this link to learn more about search conditions: https://learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http