locked
OData Feed Link Format for an Excel Workbook Stored in SharePoint RRS feed

  • Question

  • I've heard it is possible to use an OData Feed Link to get data from an Excel Workbook that is stored on SharePoint 2013 online. Does anyone know the format for the link? I've been searching high and low and cannot get any specific format that works. Thanks!

    Wednesday, November 19, 2014 7:59 PM

Answers

  • I received this from someone on our team:

    • In PQ, click From File -> From Excel.
    • In the file dialog that appears, paste in your site url (e.g. https://mycompany.sharepoint.com/teams/myteam).
    • The file dialog will display the files stored in your sharepoint site. Navigate until you reach the desired excel file.
    • Select it and click done.
    • On the credential prompt, use Organizational.

    Let me know if it works for you.

    Ehren

    Thursday, December 4, 2014 8:30 PM
  • Here's some more info on how the Excel OData REST API works in O365 or SharePoint on prem today.

    Let's say you start with the url:
    https://contoso.sharepoint.com/teams/myteam/Documents/Document.xlsx
    The OData endpoint for it will be the transformed URL: 
    https://contoso.sharepoint.com/_vti_bin/ExcelRest.aspx/teams/myteam/Documents/Document.xlsx/Odata

    Hope that helps!
    Ehren

    Wednesday, December 10, 2014 6:17 PM

All replies

  • I received this from someone on our team:

    • In PQ, click From File -> From Excel.
    • In the file dialog that appears, paste in your site url (e.g. https://mycompany.sharepoint.com/teams/myteam).
    • The file dialog will display the files stored in your sharepoint site. Navigate until you reach the desired excel file.
    • Select it and click done.
    • On the credential prompt, use Organizational.

    Let me know if it works for you.

    Ehren

    Thursday, December 4, 2014 8:30 PM
  • Here's some more info on how the Excel OData REST API works in O365 or SharePoint on prem today.

    Let's say you start with the url:
    https://contoso.sharepoint.com/teams/myteam/Documents/Document.xlsx
    The OData endpoint for it will be the transformed URL: 
    https://contoso.sharepoint.com/_vti_bin/ExcelRest.aspx/teams/myteam/Documents/Document.xlsx/Odata

    Hope that helps!
    Ehren

    Wednesday, December 10, 2014 6:17 PM