Forum Discussion
Graph API with expand only bringing max 100 rows even though top=999
When I use the following endpoint, it returns 999 rows for each page which is expected.
https://graph.microsoft.com/v1.0/groups?$top=999&$select=id,displayName
However, as soon as I expand owners, it reduces the number of rows per page down to 100 (even though I've got top=999).
Can anyone help me understand why this is happening, and any workaround to get the full 999 rows per page with owners extended?
I know how to handle paging using nextLink, etc. However, I have ~100k groups, so getting ~1000 rows per page means only 100 API calls. With ~100 rows per page, that throws it out to 1000 API calls.
- That's a known limitation as detailed here: https://learn.microsoft.com/en-us/graph/query-parameters?tabs=http#expand-parameter
