This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 11%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Hi Team,
There is an urgent requirement in my project to fetch below metadata of a file on Sharepoint using API.
1.Number of comments made by the author
2.Time spent by author on the document
3.Number of people who opened the document
4.Total number of open comments etc.
Please help me to achieve the above requirements using API. Any help on this will be appreciated.
Thanks,
Pratik
Added right tags/teams to assist
Do you use SharePoint API's or Microsoft Graph API to fetch the metadata?
Hi @Deva-MSFT ,
Earlier I was using SharePoint API's but a few days back I created 1 new Sharepoint site, but that was not accessible with SharePoint API's so right now I am using Microsoft Graph.
But do you have any idea why we are not able to use SharePoint API's now?
@Baker Kong-MSFT -Need your response to the above query.
Thanks
I want to get Who viewed my files? Show Number of Views and Viewer Names on SharePoint Online files
Can we achieve this with the help of API's as well?
Please refer to the blog for more details.
Hi @Naveed Khan ,
I viewed the blog you provided and activated the related feature:
And below endpoint could get the viewer info:
https://graph.microsoft.com/v1.0/drives/b!xxxxf-G/items/01CGSxxxxJX7/analytics/allTime?$expand=activities($filter=access ne null)
Thanks
Baker Kong
Hi @Naveed Khan ,
Regarding this issue, do you have any other questions? And if the above info is helpful to this issue, Can you accept it as an answer?
Thanks
Baker Kong
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 21%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPU%3C/text%3E%3C/svg%3E)
Hey @Baker Kong-MSFT ,
I have 1 more query regarding the same.
Currently, we are using the below API to fetch the metadata of a file/document in SharePoint .So can we have any other API to fetch the above information as the below API is not providing the required details?
Thanks
Hi @Naveed Khan ,
Sharepoint Rest API does not offer such endpoints to fetch above info. However SharePoint Rest API V2.1 has access to this data. For example:
https://isvdevchat.sharepoint.com/_api/v2.1/drives/b!NxxxxxxxO1f-G/items/01xxxxJX7/analytics/allTime?%24expand=activities(%24filter%3Daccess%20ne%20null)
In fact V2.1 is the under layer of MS graph API, you can access it directly through SP page.
Thanks
Baker Kong
Hi @Naveed Khan ,
There is analytics resource in MS Graph that could return viewer info:
And you can get all activities including Comment Action via below endpoint:
https://graph.microsoft.com/beta/drives/b!Nxxx1f-G/items/01xxxJX7/activities?$expand=driveItem
Best Regards,
Baker Kong
If an Answer 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.
Hi Team,
I have a requirement to fetch the below details.
Please let me know the API with the help of that we can get the below details.(Refer the attached screenshot)
@Baker Kong-MSFT : Please help with this.
1.Number of comments made by the author
2.Total number of open comments etc.
Hi NaveedKhan-2113,
There is no direct way to get Word comments. you may have to use above endpoint to get all activities including Comment Action. After that, you can analyze the result and pick up the comment then count the number.
Thanks
Baker Kong