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.