How to retrieve all uncategorized emails in office 365 mailbox using Microsoft graph api in PowerShell

Question

How to retrieve all uncategorized emails in office 365 mailbox using Microsoft graph api in PowerShell

Benard Mwanza 1,006

Is it possible to retrieve all uncategorized emails in office 365 mailboxes using Microsoft graph API. If yes, how does the microsoft graph api endpoint look like.

Have tried below but its not working

$mail_user = "emailaccounthere"
$graphuri = "https://graph.microsoft.com/v1.0/users/$mail_user/mailfolders/Inbox/messages?$filter=categories/any(a:a+eq+'Null+Category')&count=true"


$resp = Invoke-RestMethod -Method get -Uri $graphuri -ContentType "application/json" -Headers @{Authorization=("bearer {0}" -f $accessToken)}

$resp | fl

Zehui Yao_MSFT 5,881 Reputation points

2022-05-30T08:33:30.247+00:00

Hello @Benard Mwanza , I'm currently doing some research on this issue, will let you know as soon as possible.
azurabennett 0 Reputation points

2023-09-25T06:31:27.46+00:00

you can't directly filter uncategorized emails using Microsoft Graph API. However, you can fetch all emails from the Inbox and then use PowerShell to filter out the uncategorized ones. Just remove the $filter part from your URI and use Where-Object in PowerShell to do the filtering. This way, you'll get the uncategorized emails you're looking for.
azurabennett 0 Reputation points

2023-09-28T10:23:57.2133333+00:00

To retrieve all uncategorized emails in an Office 365 mailbox using Microsoft Graph API in PowerShell, you can use the following command:

Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages?$filter=categories/any(a:a eq '')" -Headers @{Authorization = "Bearer $AccessToken"}

Make sure to replace $AccessToken with your actual access token. This will fetch all emails in the Inbox that have no categories assigned.

8 answers

Your answer

Zehui Yao_MSFT 5,881 Reputation points

2022-05-30T08:33:30.247+00:00

Hello @Benard Mwanza , I'm currently doing some research on this issue, will let you know as soon as possible.
azurabennett 0 Reputation points

2023-09-25T06:31:27.46+00:00

you can't directly filter uncategorized emails using Microsoft Graph API. However, you can fetch all emails from the Inbox and then use PowerShell to filter out the uncategorized ones. Just remove the $filter part from your URI and use Where-Object in PowerShell to do the filtering. This way, you'll get the uncategorized emails you're looking for.
azurabennett 0 Reputation points

2023-09-28T10:23:57.2133333+00:00

To retrieve all uncategorized emails in an Office 365 mailbox using Microsoft Graph API in PowerShell, you can use the following command:

Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages?$filter=categories/any(a:a eq '')" -Headers @{Authorization = "Bearer $AccessToken"}

Make sure to replace $AccessToken with your actual access token. This will fetch all emails in the Inbox that have no categories assigned.

Answer 1

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.

Comments have been turned off. Learn more

Answer 2

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.

Comments have been turned off. Learn more

Answer 3

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.

Comments have been turned off. Learn more

Answer 4

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.

1 deleted comment

Comments have been turned off. Learn more

Answer 5

Benard Mwanza 1,006

Hello @Zehui Yao_MSFT Thank you for the concern. Below is the solutions.

GET https://graph.microsoft.com/v1.0/users/$mail_user/mailfolders/Inbox/messages?  
    $select=categories&$filter=NOT(categories/any())&count=true

If $filter=categories/any() would return all messages with any category, then the opposite of that can be achieved by using not operator. That successfully returned all messages without any category applied.

Zehui Yao_MSFT 5,881 Reputation points

2022-05-31T05:28:43.117+00:00

Glad to hear you solved your problem, have a great day!

Share via

How to retrieve all uncategorized emails in office 365 mailbox using Microsoft graph api in PowerShell

8 answers

Your answer