Not able to use filter query parameter for filtering based on from address of user using 'in' or 'eq'

Question

Not able to use filter query parameter for filtering based on from address of user using 'in' or 'eq'

Anumalasetti, Naveen 0

HI Team,

I have been working on a use case which includes to filter mail based on the from address i.e senders email. I am trying to achieve this using Mulesoft outlook 365 connector where I need to give filter query parameter.

I have tried using 'in' with filter query data parameter but getting error for 'in' saying "The query filter contains one or more invalid nodes.". The format I am using is as follows:-

Format :- from/emailAddress/address in ('******@abbvie.com','******@def.com')

please suggest a solution using 'in' or any other filter that reduce the burden of writing multiple conditional statements if we have more emails.

CarlZhao-MSFT 46,371 Reputation points

2023-07-03T02:14:03.33+00:00

Hi @Anumalasetti, Naveen

Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread.

Thanks,

Carl

1 answer

Your answer

CarlZhao-MSFT 46,371 Reputation points

2023-07-03T02:14:03.33+00:00

Hi @Anumalasetti, Naveen

Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread.

Thanks,

Carl

Answer 1

CarlZhao-MSFT 46,371

Hi @Anumalasetti, Naveen

You should filter with single quotes (' ').

To filter based on individual senders:

https://graph.microsoft.com/v1.0/me/messages?$filter=from/emailAddress/address eq '******@abbvie.com'

To filter based on multiple senders:

https://graph.microsoft.com/v1.0/me/messages?$filter=from/emailAddress/address eq '******@abbvie.com' or from/emailAddress/address eq '******@def.com'

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.

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Anumalasetti, Naveen 0 Reputation points

2023-06-06T10:00:44.4933333+00:00

Hi @CarlZhao-MSFT .can you please help me out with a solution using 'in' to filter based on multiple senders because if I use 'eq' and there are 100 emails i need to write the filter or clause 100 times ..rather I want to use 'in' and filter out all the emails.

please verify the format i updated in the question and help me on it.

I am getting below error "The query filter contains one or more invalid nodes."
CarlZhao-MSFT 46,371 Reputation points

2023-06-07T07:56:50.7933333+00:00
Hi @Anumalasetti, Naveen

Filtering messages by sender list using the "in" operator is not supported. Using the "eq" operator to filter messages by sender is a standard filtering method, if you feel that this method is too redundant for filter the sender list, then you can try to use code filtering locally.

var result = await graphClient.Me.Messages.GetAsync(); String[] str = new string[] { "emailAddress 1", "emailAddress 2", "emailAddress 3", ....... }; int num = 0; for (int i = 0; i < result.Value.Count; i++) { if (str.Contains(result.Value[i].From.EmailAddress.Address) ) { Console.WriteLine(JsonConvert.SerializeObject(result.Value[i].From.EmailAddress)); num = num + 1; } } Console.WriteLine("count:" + num);

Hope this helps.

If it helps you, don't forget to click "Accept Answer".

Thanks,

Carl

Share via

Not able to use filter query parameter for filtering based on from address of user using 'in' or 'eq'

1 answer

Your answer