13,721 questions
I will use lastModifiedDateTime, Thank you
How to filter/query multiple messages with Microsoft Graph API
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 47%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hda
0
Reputation points
Hello !
I would like to filter / query on custom attributes on /messages
I have an Azure mail server that allows me to retrieve received emails via Microsoft's Graph API. I would like to avoid retrieving all emails and instead only retrieve those where "alreadyFetched" ne true, for example.
"alreadyFetched" would be a custom value affected to all mails with the default value false. Then, when I fetch all mails I patch the value to true.
I have read about extensionAttributes, open extensions, and schema extensions, but I am not sure how to implement them to achieve my goal. I have managed to do it one message at a time using open extensions:
POST https://graph.microsoft.com/v1.0/me/messages/{messageId}/extensions
Then I can filter with the $filter=extensions/any
But I can't create extension for every /message when dealing with thousands of emails.
Any suggestions on how I can accomplish this?
Do you have an Idea on how could I do ?
Thank you.
Microsoft Security Microsoft Graph
{count} votes
-
Azizkhon Ishankhonov 540 Reputation points2024-05-21T12:36:35.92+00:00 Hi
Could you please clarify why do you need such filtering? Just because you want handle only new messages or there other reason to such filter?
I'm asking because there already property that may solve problem with retrieving only new messages like "IsRead". You can just retrieve all mails by "isRead eq false" and after handling mark it as read.
-
Hda 0 Reputation points
2024-05-21T12:46:48.97+00:00 I just noticed that I can't filter on a specific propertie value with open extension
-
Hda 0 Reputation points
2024-05-21T12:57:31.55+00:00 Hello,
I will try to clarify what I'm trying to do.I have an application that retrieves all received emails and then distributes them to all available agents. Currently, I use the ReceivedDate to fetch all new emails every 15 minutes.
(Something like GET ... where ReceivedDate > lastFetchDate
The problem arises when an email is sent to the spam folder. If an admin reads it and decides it is not spam, they move the email back to the desired mailbox, but the ReceivedDate does not change. As a result, the query will never retrieve this email. -
Azizkhon Ishankhonov 540 Reputation points
2024-05-21T18:19:33.66+00:00 Maybe a change notification subscription will be the more suitable option for this case?
for example, you can subscribe to certain folders of emails and handle them when the email comes.
Or
there is also another property on the message resource: lastModifiedDateTime, which you may use for this scenario, it will updated when you move the email from one folder to anotherhttps://learn.microsoft.com/en-us/graph/api/subscription-post-subscriptions?view=graph-rest-1.0&tabs=http#contact-event-and-message
https://learn.microsoft.com/en-us/graph/api/resources/mailfolder?view=graph-rest-1.0
Sign in to comment