0
0 Comments

Objective: Reading excel file (when this file changed) which exist in a SharePoint online document library. Insert excel data in List.

Technical approach: Create a workflow in Sharepoint Designer 2013 & call excel service Rest API in Workflow. The Workflow will then run only when this Excel sheet is changed.

Problem: When calling Excel Service REST API with proper headers, I am getting a forbidden error.

Headers passed:

  • Accept – application/json; odata=verbose
  • Content-Type – application/json; odata=verbose

Analysis: When testing the Excel service REST API using Fiddler, it’s not throwing any error & returning a correct response. When calling this service in Javascript, its giving result without any error.

Can anyone please tell me what is the problem?

Asked question here but not agree with solution: https://social.technet.microsoft.com/Forums/en-US/5833a92b-cb9b-4335-9cad-0f97428ed492/excel-service…

(Visited 69 times, 1 visits today)
Mark Jones Changed status to publish March 22, 2019
Add a Comment