How to get all the column values (including custom columns) in a Sharepoint List via Microsoft Graph API?

Kitty Cheng 1

How to get all the column values (including custom columns) in a Sharepoint List via Microsoft Graph API? I can only get the item id by calling the request query stated in the doc.

2 answers

Deva-MSFT 2,256 Reputation points Microsoft Employee

2020-11-24T16:31:50.61+00:00

i would try columndefinition resource to get the column values.
Please sign in to rate this answer.
Mrachek, Ryan S 1 Reputation point

2022-11-03T15:23:40.127+00:00

Bad Link
Sign in to comment
Sébastien Levert 76 Reputation points Microsoft Employee

2020-11-30T15:53:14.653+00:00
By using the /items endpoint, you should be able to expand on the fields property like this.

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$expand=fields

The response will contain a field property with everything you need!
Please sign in to rate this answer.
Andrew Goodwin 1 Reputation point

2021-02-26T10:32:16.073+00:00

From what we're seeing here it's not everything. Custom columns are not being returned even when specifying custom column names using GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items/{item-id}?expand=fields(select=Column1,Column2)

Sébastien Levert 76 Reputation points Microsoft Employee

2021-02-26T17:03:04.49+00:00

Interesting, as I can't repro right now. I just did the following and it worked (I haven't tested on all types of columns, though).

Added a column named Category using the "Add column" on a document library

Queries the list using https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$expand=fields

The result contained the "custom" data as part of the fields property

What are you types of columns we can't get? Please also make sure you are using the $expand operator also.

Venkatesh Balakumar 1 Reputation point

2021-04-04T16:29:17.99+00:00

Custom column works, only if it has value. The following query returns custom fields if it has some value.

https://graph.microsoft.com/beta/sites/{site-id}/lists/{list-id}/items/{item-id}?expand=fields

Coleman, Mark 21 Reputation points

2021-12-08T19:47:13.627+00:00

I have the same issue - I have tried everything - expanding the fields and using select to specifiy the columns I want.
I have also called the column definitions and can see that the column exists …yet when I try to get the fields for an item it’s completely random which fields I’ll get back.
Sign in to comment