I am trying to access excel of a document library using rest service. I have a workflow which is retrieving data using rest api: The http request is: https://<>.sharepoint.com/sites/<>/_vti_bin/ExcelRest.aspx/TestDocLibrary/Tracker.xlsx/model/Ranges('DashBoard!J6')?$format=atom

In RequestHeaders, I tried both option:

1-accept & content-type 2- accept & content-type & Authorization (as mentioned here Excel Services REST API returns 401 Unauthorized in Workflow)

For permission I follwed this link : https://docs.microsoft.com/en-us/sharepoint/dev/general-development/create-a-workflow-with-elevated-permissions-by-using-the-sharepoint-workflow

The responsecontent is empty string and responsestatuscode is forbidden. In another workflow, I am able to update list, add entry in list, get list item using rest api. So I think there is no problem of permission to run workflow.

But excel service is throwing forbidded error. Can anyone please help ? Attaching screenshot of workflow.

enter image description here enter image description here enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.