none
Odata Feed : The remote server returned an error: (500) Internal Server Error RRS feed

  • Question

  • Hi,

    I'm keep getting an error using an Odata Feed:

    DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error.
    Details:
        DataSourceKind=OData
        DataSourcePath=http://xxxx.xxxx.local:8088/OData.svc/$metadata

    xxxx is edited by me..


    Anyone a clue?

    This is the Odata statement:

    =OData.Feed("http://XXXXX.XXXX.local:8088/OData.svc/XXXXX")

    Greetz,

    Hennie 

    Wednesday, September 2, 2015 12:33 PM

Answers

All replies

  • What sort of OData feed is it and do you get the same thing if you go to the address in a browser?
    Wednesday, September 2, 2015 1:56 PM
  • I'm a bit of a newbie on Odata feeds. I'll try to explain the problem.

    We have a Theobald connector and it's retrieving data from SAP BW. That works. Now we come to the part i partially understand. Somehow the data is published via an odata feed.

    If I enter the feed url in the browser, data is retrieved. So that works. 

    But when I try to access the URL via PowerQuery an error occurs..

    We investigated the log in the Theobald connector and there we have found an Object reference error. 

    We're talking with the Theobald developers for more information...

    Greetz

    Hennie

    Wednesday, September 2, 2015 2:34 PM
  • This may or may not be helpful as it goes into some details around getting OData feeds out of SharePoint and some of the issues there.

    https://social.technet.microsoft.com/Forums/en-US/63c57fd7-109a-4a2c-82a7-409494f19303/trouble-getting-sharepoint-list-contents-via-odata?forum=powerquery

    Might spark a thought or two about what is going on with your OData feed.

    Wednesday, September 2, 2015 2:39 PM
  • Solved.. The problem was in the connector
    Thursday, September 10, 2015 12:09 PM