AnswerBun.com

SharePoint Designer Get an Excel Value (REST)

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:

SharePoint Asked by Aquen on January 12, 2021

1 Answers

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

Auto-populate email address from pc:Person?

1  Asked on December 17, 2020 by zeno

   

Org Browser start at a specific user for SP 2013

2  Asked on December 16, 2020 by brandon-black

     

Form based Login Authentication for Public Site Sharepoint online

1  Asked on December 8, 2020 by jitender-singh-tomar

   

Sharepoint PHP File Upload

1  Asked on December 7, 2020 by markvdb

     

CSS Script for Multiple Columns Boxed Style

1  Asked on December 6, 2020 by elebie

 

Faulting application name: csc.exe

2  Asked on December 4, 2020 by emaborsa

         

sharepoint 2013,RSS viewer web part error

1  Asked on December 4, 2020 by pasha

 

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved.