Access metadata of files like Excel/Word which are already stored on Sharepoint (using Microsoft Graph API)

Question

Basically, the status of a Word or Excel document can be set as free text within the metadata. Is there any way to access the metadata, such as status, tags, comments etc. (see attached screenshot - it is in german, but i think you will get the point :) ) via the REST-API which you provide if the documents are uploaded on Sharepoint? I could not find any information about that in the Microsoft Graph API documentation.

Thank you

Daniel

Answer 1

Hi @Kalfas, Daniel ,

The Word/Excel file info metadata is set in Office Client Desktop Software and won't sync to SharePoint library, they are not the same thing, so in SharePoint Online, it's not available to read these properties using Graph/Rest API.

A workaround is that create related column in SharePoint library which fill the same value as metadata in Word/Excel Desktop Client and read with Rest API ListItemAllFields endpoint:

GET https://siteurl/_api/web/getFileByServerRelativeUrl('/sites/SiteName/shared documents/New Microsoft Word Document.docx')/ListItemAllFields

Reference:

Working with folders and files with REST

Thanks
Best Regards

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.