Inconsistent results when filtering members from a Teams Group chat using Graph API

Michael Brown 0

Hi,

I am trying to retrieve the chat id of a group, containing multiple members (i.e, memebers x , y and Z)

When using the graph api query, sometimes I receive a response back, and sometimes the response is null.

The behavior is very intermittent.

Here is a sample of the query that I am running:

https://graph.microsoft.com/v1.0/users/serviceAccountMember/chats?$expand=members&$filter=chatType eq 'group' and members/any(p:p/microsoft.graph.aadUserConversationMember/email eq 'memberA@mycompany.com') and members/any(p:p/microsoft.graph.aadUserConversationMember/email eq 'memberB@mycompany.com') and members/any(p:p/microsoft.graph.aadUserConversationMember/email eq 'serviceAccountMember@mycompany.com')

Any ideas of what could be happening?

Can the query be optimized better, or is this kind of expected behavior with Graph API?

JimmyYang-MSFT 52,031 Reputation points Microsoft Vendor

2023-09-26T01:45:29.5533333+00:00

Hi @Michael Brown

Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. According to your description, your question is not in our support scope. So I will add teams development tag to your thread. Thanks for your understanding and patience!
Prasad-MSFT 6,681 Reputation points Microsoft Vendor

2023-09-26T05:30:47.57+00:00

Could you please let us know from where you got this filtering query?
There is no such official documentation seems to be available which highlights this.
We tried using the query you provided, but at our end getting below error:
Prasad-MSFT 6,681 Reputation points Microsoft Vendor

2023-09-26T05:33:05.8266667+00:00

Could you please let us know from where you got this API query reference from?
We checked but there doesn't seem to be any official documentation available which highlights this.

We also tried to repro using the filter query provided, but at our end getting below error.
CarlZhao-MSFT 41,286 Reputation points

2023-09-26T05:41:25+00:00

@Prasad-MSFT

You should replace serviceAccountMember with your real user id, otherwise it will print that error.
Prasad-MSFT 6,681 Reputation points Microsoft Vendor

2023-09-26T14:14:37.38+00:00

Getting below response by updating the Id
Michael Brown 0 Reputation points

2023-09-26T15:11:10.1866667+00:00

Thanks for the replies. It turns out there was an issue with including the Top(50) in the query that filtered out a lot of the results. I believe that was the root cause.
Prasad-MSFT 6,681 Reputation points Microsoft Vendor

2023-09-27T04:23:45.29+00:00

Thanks for letting us know.
Please add that as answer and click "Accept Answer" and upvote it, so that developers facing the same issue will have visibility to the solution

1 answer

CarlZhao-MSFT 41,286 Reputation points

2023-09-27T09:02:35.73+00:00

Hi @Michael Brown

Thanks for sharing your solution, it seems that including $top=50 in the query is the root cause of this issue.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Inconsistent results when filtering members from a Teams Group chat using Graph API

1 answer

Your answer