AnsweredAssumed Answered

500 Internal error using ExcelService.asmx

Question asked by waltont on Jul 28, 2017

I was wondering if anyone could give me some pointers as to what I should check on this one.

 

I am attempting to access the excel services web service but I continue to get a 500 internal server error when I try to do so. I can "test connection" and I receive "OK" when I do this on the execute now feature, but the request itself is not working. If I use fiddler to directly hit the web service I get a 400 on it. Here's the XML I'm sending it:

 

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m="http://schemas.microsoft.com/office/excel/server/webservices">
<soap:Header>
</soap:Header>
<soap:Body>
  <m:OpenWorkbookForEditing>
    <m:workbookPath>http://<SANITIZED WEBURL>/IT/TP/Shared%20Documents/Managers.xlsx</m:workbookPath>
    <m:uiCultureName>en-us</m:uiCultureName>
    <m:dataCultureName>en-us</m:dataCultureName>
  </m:OpenWorkbookForEditing>
</soap:Body>
</soap:Envelope>

Outcomes