Trouble getting SharePoint list contents via OData RRS feed

  • Question

  • I'm trying to get information about outstanding Access Requests from a SharePoint site.  I can access the Access Requests list field information by URL in a browser and in Power Query with the following:

    = OData.Feed("https://<site>/_api/web/lists/getbytitle('Access%20Requests')/fields")

    I have trouble when I try to access the list entries, however.  The following works fine in a browser and returns the requested columns from the $select:


    When I try this in Power Query, however, I get the error:

    DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Cannot find resource for the request $metadata.)
        https://<site>/_api/web/lists/getbytitle('Access Requests')/$metadata

    Thanks in advance,


    Wednesday, July 22, 2015 9:09 PM


All replies