Share via

Cannot connect to Excel Services REST API

Anonymous
2019-04-02T05:11:33+00:00

Hi there,

I am currently trying to connect an audit report to the Excel Services REST API, for the purpose of eventually connecting that file to Power BI to visualize my data analytics.

I am using the following format to try and access this API:

http://<ServerName>/_vti_bin/ExcelRest.aspx/<DocumentLibrary>/<FileName>/<ResourceLocation>

However, when I attempt to connect to the API, I am thrown an error message that the item does not exist despite it clearly being there in my document library. Below is an image of the screen that I see:

I would appreciate any support and advice you could provide!

Sincerely,

Jericho

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2019-04-02T06:19:10+00:00

Hi Jericho,

According to the following article, the Excel Services REST API applies to on-premise SharePoint, and since you are using SharePoint Online, you may use Microsoft Graph API instead:

Excel Services REST API

"Note:

The Excel Services REST API applies to SharePoint and SharePoint 2016 on-premises. For Office 365 Education, Business, and Enterprise accounts, use the Excel REST APIs that are part of the Microsoft Graph endpoint."

You may also refer to Lee-MSFT's reply in the following thread to check the details of using Microsoft Graph API from SharePoint Online to access your Excel files:

How to access Excel Data stored in Sharepoint Online Document Library using Excel Rest API in a Sharepoint Framework (SPFx) app?

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​​

Please let us know if you have any further concerns.

Best Regards,

Nathan

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2019-04-06T14:20:20+00:00

    Hi Jericho,

    May I know if my information above could address your concern about the Excel Services REST API? Please let us know if you have any further concerns.

    Best Regards,

    Nathan

    Was this answer helpful?

    0 comments No comments