Issue with the REST API and ExcelWorkbooks

BenMackin — Fri, 19 Oct 2018 21:53:49 GMT

I am trying to use the REST API to access an Excel Workbook I have uploaded to the server.

When I just query the item using:

https://MYSERVER.INT.COM/reports/api/v2.0/ExcelWorkbooks(path='/BusinessReporting/Test/TestFile.xlsx')

I get back the following JSON:

 {
  "@odata.context":"https://MYSERVER.INT.COM/reports/api/v2.0/$metadata#ExcelWorkbooks/$entity","Id":"ecda6463-3fc4-4329-a56e-b5befcb0dce1","Name":"TestFile.xlsx","Description":null,"Path":"/BusinessReporting/Test/TestFile.xlsx","Type":"ExcelWorkbook","Hidden":false,"Size":9913,"ModifiedBy":"XXXXXX\\MackinBW","ModifiedDate":"2018-10-19T14:11:42.333-07:00","CreatedBy":"XXXXXX\\MackinBW","CreatedDate":"2018-10-19T14:11:06.3-07:00","ParentFolderId":"66dd88d9-5c1c-4203-9492-4de8b6934920","IsFavorite":false,"Roles":[
   
  ],"ContentType":null,"Content":""
}

As you can see, it says the ContentType is null, and the Content is also null. If I try and access the content with:

https://MYSERVER.INT.COM/reports/api/v2.0/ExcelWorkbooks(path='/BusinessReporting/Test/TestFile.xlsx')/Content/$value

I get a 404 error.

My understanding of the APIs is that I should get back the contents of the Excel workbook. Is that not correct?

topic Issue with the REST API and ExcelWorkbooks in Report Server

Issue with the REST API and ExcelWorkbooks