CODEWITHSUNDEEP
microsoft-graph-api
itslittlejohn
itslittlejohn

Reputation: 1878

How to access custom columns in a sharepoint library - graph API

I am listing the children in the root of a document library with custom columns. When I make the following call with the MS graph REST API, no custom column data is returned for the child items.

https://graph.microsoft.com/beta/sites/<site-id>/drive/root/children

I have tried using ?expand=... without success. Is this possible with either the v1 or beta endpoints?

Upvotes: 2

Views: 2835

Answers (1)

Vadim Gremyachev
Vadim Gremyachev

Reputation: 59318

Endpoint GET https://graph.microsoft.com/beta/sites/<site-id>/drive/root/children returns the collection of files metadata (DriveItem resource) in the root of the drive.

The associated document library list items could be retrieved via DriveItem.listItem property including the values of the columns set on this list item (via ListItem.fields property) like this: 

https://graph.microsoft.com/v1.0/sites/root/drive/root/children?$expand=listItem($expand=fields)

Alternatively, SharePoint Library list items and column values (including custom ones) could be retrieved instead:

GET https://graph.microsoft.com/v1.0/sites/root/drive/list/items?$expand=fields

or list items along with files metadata:

GET https://graph.microsoft.com/v1.0/sites/root/drive/list/items?$expand=fields,driveItem

Upvotes: 3

Related Questions