Graph - edit files shared with me

Question

I am totally new to the whole Microsoft ecosystem. I write Rails applications.

I need to be able to automate editing excel spreadsheets that have been shared with me. They are on a onedrive for business account (ie. sharepoint backed). The URL looks like this:

https://comanyname-my.sharepoint.com/:x:/g/personal/john_doe_company_com/EXTlp2 ....

When I click the link that was shared with me, assuming I am logged into my own microsoft account, I can view and edit it. (If I'm not logged in it prompts me to before I can see it.) So I have the relevant permissions on the file. The file does not appear in the 'shared with me' section of my onedrive or in my O365 apps.

Can I use Graph to edit it? How would I get the relevant identifiers to be able to specify which file I want to edit?

Using Graph Explorer I can see how to get this information for files in my onedrive but not for files shared with me as above.

Answer 1

Seems to work ok

PATCH https://graph.microsoft.com/v1.0/me/drives/b!dtFE1JiOtEKfOe8EMOwkjRdQjarpXD1KjrHRN12E8C02WFhJKKk5R6zJz9nRfWVn/items/01EHPWZACK6FNFXXBK5BDL4MDTAS5PQPVO/workbook/worksheets('Sheet2')/range(address='A1:B2')

{ "values" : [["Hello", "100"],["1/1/2016", null]], "formulas" : [[null, null], [null, "=B1*2"]], "numberFormat" : [[null,null], ["m-ddd", null]] }

Answer 2

Hi @Steve Rawlinson ,

Based on my research and testing ,I have not yet found a way can edit the file share with me using Graph api. I suggest you can propose a feature request on this issue. Many features of our current products are designed and upgraded based on customers’ feedback. With requirements like this increase, the problem may well be released in the future. Thanks for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

---

Answer 3

Hi@Steve Rawlinson ,

As per my research you can fetch the details of a file which is shared using this api drive-sharedwithme.

Currently using Update workbook api it is not able to edit. Please raise a feature request so that the respective team will make the changes based on the priority.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".