Filter "Endswith" results in "The query filter contains one or more invalid nodes." Error

Question

I am trying to filter Messages where the subject ends with a certain value but i am getting the error in the title.

I tried the Query in the Graph explorer and the SDK (opened an issue there first: https://github.com/microsoftgraph/msgraph-sdk-dotnet/issues/2572)

Answer 1

Hi @N&H / Kaba

The endswith filter on the "subject" property is not yet supported. As an alternative, you can try the $search query parameter.

var result = await graphClient.Users["{user_id}"].MailFolders["{folder_id}"].Messages.GetAsync((requestConfiguration) =>
{
    requestConfiguration.QueryParameters.Search = "\"subject:Digest\"";
});

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Answer 2

Hi,

thanks for the answer.

Why is StartsWith supported but not EndsWith?

How would i realise the endswith with search? I need to be able to filter for subjects that end with a specific value. This value can also appear somewhere in the middle of the subject or the start, but i only need the ones where it ends with the specified value.