Make excel file readable/editable using Graph Api's

Question

I have a requirement where I have to make my excel file readable or editable from my java application .

I am following this approach https://learn.microsoft.com/en-us/graph/api/worksheetprotection-protect?view=graph-rest-1.0&tabs=http

• The first problem I faced was getting the id of my file
• After lot of research I got the id from this api https://graph.microsoft.com/v1.0/sites/{siteID}/lists/{listId}/items/{ItemID}/driveItem/children
• My item or excel file is inside a list and subfolder structure
• I used the above approach and constructed api https://graph.microsoft.com/v1.0/users/{userID}/drive/items/{IDofFile}/workbook/worksheets/{IdOfFile}/protection/protect
• But I am a getting a response itemNotFound
• I know in the actual api it has used /me , but I am not able to use that from my Postman as it returns
• What is Ia m doing wrong ? Or is there an alternate way to achieve this .

message": "/me request is only valid with delegated authentication flow.",

    "error": {
        "code": "itemNotFound",
        "message": "The resource could not be found.",}

Answer 1

Thanks for reaching out.

The problem here is how you're authenticating. The "/me" endpoint refers to the user in whose context you are running request, thus is only available for delegate permission flows. The application permissions model (client credentials), you are running your code without any user context, so there is no user to "resolve" for the "/me" endpoint and hence you are using /users/{userID}.

In postman, you have to get token by clicking on Application folder, Authorization -> Get New Access Token. then you will be able to make calls to /users/... endpoints.

For more details refer documentation.

Hope this will help.

---

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