Fail to find message by singleValueExtendedProperties using $filter, where singleValueExtendedProperty is a UUID

Preda Radu 6 Reputation points
2021-05-26T14:31:48.037+00:00

Hello,

I'm using the graph sdk to send mails with two singleValueExtendedProperties. Both properties use the "{type} {guid} Name {name}" convention for setting the id. For both of them the value is a random UUID set at send time.
We have a suite of automated test (they are ran by a CI pipeline), that verify if the mails created are present in the sent folder. I'm using $filter to find the mail by singleValueExtendedProperties id and value, but in some runs the query doesn't return the mail sent. Stranger than this, the mail is present in the mailbox, using other queries (no $filter, only the $expand for the targeted singleValueExtendedProperty)

Query example:

$expand=singleValueExtendedProperties($filter=id eq 'String {guid1} Name PropertyName1')
$filter=singleValueExtendedProperties/Any(ep:ep/id eq 'String {guid2} Name PropertyName2' and startsWith(ep/value, 'UUID'))
$top=1000
$select=singleValueExtendedProperties

My first thought was that the issue is caused by the startsWith operator, but unfortunately replacing it with 'contains' or 'eq' gives the same result (no result)

I'm assume that it has something to do with using a UUID as a value

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
13,264 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.