Jun 02 2022 10:13 AM
I am using Graph API to get the content of a SharePoint Contacts list. I am using this uri:"https://graph.microsoft.com/v1.0/sites/$($siteid)/lists/$($listid)/items"
I am then using the id of each item to get the content with this uri:"https://graph.microsoft.com/v1.0/sites/$($siteid)/lists/$($listid)/items/$($id)"
It is returning the content but if a column is empty on an item it doesn't return that column so each item doesn't return the same number of fields. I would like to return all columns for each item in the list even if they are empty/null. Is there a way to change the uri so all columns are return even if they are empty?
I've tried expand=fields and select the columns I want but it still doesn't return empty columns.
$uri = "https://graph.microsoft.com/v1.0/sites/$($siteid)/lists/$($listid)/items?$expand=fields
Apr 20 2023 09:12 AM
I see there are no replies to this thread. Has anyone looked into this? I'm having the exact same issue. Columns added into a SharePoint list do not return as a "Field" via GraphApi if that column is null in SharePoint. I'd expect all of the column names to be present as a Field, even if null or empty.
Jul 07 2023 12:58 AM - edited Jul 07 2023 12:58 AM
i kind of have this problem too