Home

Excel service rest api throwing forbidden response code in Sharepoint designer 2013 workflow

New Contributor

Objective : Reading excel file (when this file changed) which exist in 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. Workflow will run only when this excel sheet will be changed.

 

Problem: When calling excel service rest api with proper headers, getting forbidden error. Headers passed :

Accept - application/json; odata=verbose

Content-Type - application/json; odata=verbose

 

Analysis : When testing excel service rest api using fiddler, its not throwing any error & giving 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...

 

Related Conversations
Formula Question
Tracie_Barker in Excel on
1 Replies
Sum 2 pivot table Fields where one may not exist
shotgun-68 in Excel on
1 Replies
Help with forumla
robwill100 in Excel on
3 Replies
Graphic
Allan1951 in Excel on
1 Replies
Macro works fine on Excel 2016 - causes crash on Excel 365
gpflinn in Excel on
1 Replies