Graph API not returning SharePoint List items columns

Copper Contributor

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

$uri = "https://graph.microsoft.com/v1.0/sites/$($siteid)/lists/$($listid)/items?expand=fields($select=Title..."

2 Replies

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.

i kind of have this problem too