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.
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). https://graph.microsoft.com/v1.0/groups?$top=999&$select=id,displayName&$expand=owners($select=displayName) 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. Read More
