How to retrieve uncategorized emails using Microsoft Graph API

Ravindra Shukla 116

Hi,

I am using Microsoft Graph to retrieve the emails from the mailboxes, I know how to get the emails based on categories using below query.

https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages?$filter=categories/any(c:c eq 'Yellow category')

However I want to retrieve all the emails or count of all the emails which don't have any categories assigned. I tried using the above query in other way as

https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages?$filter=categories/any(c:c ne 'Yellow category')

and also like as below, but its not working.

https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages?$filter=categories/any()

How can I achieve this?

Any help or pointers are appreciated.

2 answers

Danstan Onyango 3,821 Microsoft Employee

As far as I know, this capability is currently not supported via MS Graph API. I have created this GitHub Issue that may help provide details of whether this is possible and how to achieve it.

Ravindra Shukla 116 Reputation points

2021-05-14T07:10:11.46+00:00

@Danstan Thank you for your reply on this issue. I hope we'll have some update on the github issue.

Randy Arvelo 0

Authentication:

Obtain your tenant_id, client_id, and client_secret from the Azure Portal.
Use these credentials to authenticate and obtain an access token using the client credentials flow.
Request to Microsoft Graph API:

Use the obtained access token to make a GET request to the /me/messages endpoint.
Set the headers with the access token and content type as application/json.
Filter for Uncategorized Emails:

Use the $filter query parameter to filter messages where the "Categories" property is empty or does not exist.

import requests

# Replace these with your actual values
tenant_id = 'your_tenant_id'
client_id = 'your_client_id'
client_secret = 'your_client_secret'
user_email = 'user@example.com'

# Get an access token using client credentials flow
token_url = f'https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token'
token_data = {
    'grant_type': 'client_credentials',
    'client_id': client_id,
    'client_secret': client_secret,
    'scope': 'https://graph.microsoft.com/.default'
}
token_response = requests.post(token_url, data=token_data).json()
access_token = token_response['access_token']

# Make a request to retrieve uncategorized emails
graph_url = f'https://graph.microsoft.com/v1.0/users/{user_email}/messages'
headers = {
    'Authorization': 'Bearer ' + access_token,
    'Content-Type': 'application/json',
}

# Filter based on the absence of the "Categories" property
params = {
    '$filter': 'categories/any() eq false'
}

response = requests.get(graph_url, headers=headers, params=params)
emails = response.json().get('value', [])

# Print the subject of uncategorized emails
for email in emails:
    print('Subject:', email.get('subject'))

Your [skin does naturally limits tanning when it reaches a certain point](https://glamglowing.com/does-your-skin-stop-tanning-at-a-certain-point-truth-facts/).

Remember to replace the placeholder values with your actual credentials. This script uses the Python requests library to interact with the Microsoft Graph API.

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
8 deleted comments

Comments have been turned off. Learn more

Share via

How to retrieve uncategorized emails using Microsoft Graph API

2 answers

Your answer