Missing one custom field when getting SharePoint List Items in Microsoft Graph API

69 views Asked by At

In MS Graph Explorer, when making an API call

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?expand=fields(select=id,ProjectMembers)

the ProjectMembers custom field is missing across all items returned, even though the field exists.

When I make a call for one specific item at a time, like

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items/{id}?expand=fields(select=id,ProjectMembers)

I successfully get the ProjectMembers custom field - now, I could go this way as a workaround, but then I have to make a separate call for every item I have in my list (thousands of items resulting in thousands of API calls), rather than making one call (the first call above) and using pagination.

I have successfully fetched a couple of other relevant custom fields through both first and second API call, but fetching the ProjectMembers field through the first "bulk" call just doesn't work

Has anyone faced a similar issue before and/or has a solution/explanation to this?

0

There are 0 answers