AnswerBun.com

SharePoint Designer Get an Excel Value (REST)

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:

  1. The URL: I’ve found some REST endpoints for Excel here. But I cannot find the endpoint for cell values. :-/

  2. 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:

enter image description here

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:

One Answer

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

Add your own answers!

Related Questions

Error creating SPFx with React JS

1  Asked on October 28, 2020 by tezz-chaudhary

   

Depolying SPFX Web Part on On Prem 2019

0  Asked on October 12, 2020 by kurt-cooney

       

Automate posting to SharePoint with Python

1  Asked on October 4, 2020 by brinley

 

Workflow updating a multiple value lookup column

1  Asked on October 3, 2020 by jl421

     

how to search people in search box in sharepoint 2013

1  Asked on September 6, 2020 by sharepointman

   

How to see checked out file

2  Asked on September 2, 2020 by dingo

 

SharePoint o365/online – This site can’t be reached

1  Asked on August 26, 2020 by rohit-waghela

 

Ask a Question

Get help from others!

© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP