SharePoint Asked by Aquen on January 12, 2021
I have the following problem: I want to get the values of excel cells with the REST Api and in SharePoint Designer 2013. So to do this I created a workflow with the “Call HTTP web service” action. But now I’m a little bit stuck somewhere:
The URL: I’ve found some REST endpoints for Excel here. But I cannot find the endpoint for cell values. :-/
I have problems with the request header. To get a better feeling for the Excel Api I just wanted to start by getting the titles of all workbook sheets (with the “/Model/Sheets?$format=atom
” endpoint). For this I created the following RequestHeader Dictionary:
But when logging the ResponseCode to Workflow History List I only get “Forbidden”. I thought it was a similar problem like this so I added the “Authorization: (empty string)” to the Request Header, but it did not work. :-/
So why is my request forbidden? :-/
Maybe someone can help me with this two little questions o:
The REST endpoint for getting the cell value of A1 would be something like this: https://.../sites/testsite/_vti_bin/ExcelRest.aspx/DocLib/test.xlsx/Model/Ranges('Sheet1!a1')
I followed the steps here https://sergeluca.wordpress.com/2013/04/09/calling-the-sharepoint-2013-rest-api-from-a-sharepoint-designer-workflow/ and it worked for me.
Maybe there is a case sensivity problem concerning the request parameters: Content-Type, Accept For the values of these I used: application/json; odata=verbose
Answered by tommypage777 on January 12, 2021
1 Asked on October 28, 2020 by tezz-chaudhary
1 Asked on October 24, 2020 by leebongee
1 Asked on October 22, 2020 by snowburnt
2013 internal server error reporting services sharepoint enterprise
0 Asked on October 12, 2020 by kurt-cooney
1 Asked on October 6, 2020 by rajat-raj
1 Asked on October 4, 2020 by user615993
1 Asked on October 3, 2020 by jl421
1 Asked on September 28, 2020 by robert
2 Asked on September 23, 2020 by chetan
1 Asked on September 19, 2020 by plouie21
sharepoint addin sharepoint designer sharepoint enterprise sharepoint foundation
1 Asked on September 17, 2020 by f_gulay
approval process content approval designer workflow workflow
1 Asked on September 6, 2020 by sharepointman
1 Asked on September 3, 2020 by fjay
2013 document library sharepoint library sharepoint permissions sharepoint server
2 Asked on August 31, 2020 by j-dock
1 Asked on August 27, 2020 by nicholas-snr
1 Asked on August 26, 2020 by rohit-waghela
1 Asked on August 20, 2020 by yamini
api discussion board rest sharepoint online sharepoint rest api
1 Asked on August 9, 2020 by sh-olli
2010 calculated column calculated column formula comparison modified
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP