I need to fix this query https://graph.microsoft.com/v1.0/users$select=id&$count=true&$expand=messages($filter=from/emailAddress/address+endsWith+'@.com'+and+toRecipients/emailAddress/address+endsWith+'@.com')

Question

I need to fix this query https://graph.microsoft.com/v1.0/users$select=id&$count=true&$expand=messages($filter=from/emailAddress/address+endsWith+'@.com'+and+toRecipients/emailAddress/address+endsWith+'@.com')

Babetecno SAT 0

This query is for obtain the amount of mails a user sends in my organization but give me an error i need to fix can someone help me with this?

Babetecno SAT 0

{
    "error": {
        "code": "BadRequest",
        "message": "Bad Request - Error in query syntax.",
        "innerError": {
            "date": "2023-04-18T13:46:45",
            "request-id": "a07a3384-da61-4148-8f66-d2d7a235852a",
            "client-request-id": "ab4f6c72-dad4-0cc6-bfa7-b0b01905b952"
        }
    }
}

Zehui Yao_MSFT 5,881 Reputation points

2023-04-19T07:24:31.8966667+00:00

Hi @Babetecno SAT , we need to do some research on this issue and will let you know as soon as possible.

1 answer

Your answer

Babetecno SAT 0 Reputation points

2023-04-18T13:46:58.7866667+00:00

{ "error": { "code": "BadRequest", "message": "Bad Request - Error in query syntax.", "innerError": { "date": "2023-04-18T13:46:45", "request-id": "a07a3384-da61-4148-8f66-d2d7a235852a", "client-request-id": "ab4f6c72-dad4-0cc6-bfa7-b0b01905b952" } } }
Zehui Yao_MSFT 5,881 Reputation points

2023-04-19T07:24:31.8966667+00:00

Hi @Babetecno SAT , we need to do some research on this issue and will let you know as soon as possible.

Answer 1

Hi Babetecno SAT, Thank you for reaching out.

Please note that endsWith parameters does not always work with certain OData query parameters https://github.com/microsoftgraph/microsoft-graph-docs/issues/4331 github post endswith operator support

However upon some testing we were able to get the query working as such: https://graph.microsoft.com/v1.0/users/<User-GUID>/messages?$count=true&$filter= (contains(from/emailAddress/address,'.com') and contains(to/emailAddress/address,'.com')) Note that a user guid is to be provided to the messages resource type so that the object is filterable. Further an item oData.count value will have the count value of the returned item.

Share via

I need to fix this query https://graph.microsoft.com/v1.0/users$select=id&$count=true&$expand=messages($filter=from/emailAddress/address+endsWith+'@.com'+and+toRecipients/emailAddress/address+endsWith+'@.com')

1 answer

Your answer