0

We have SharePoint 2010 hosted on Windows Server 2008 R2 server. We are trying to access the data in the SP lists using REST queries (GET) such as 

http://server:port/sites/sitecollection/site/_vti_bin/listdata.svc/listname?$filter=ColumnName eq ‘Value’

This query works fine when we access it from any machine other than the server. However, when we access it from the server that hosts SP, we get 500 internal server error.

Improve this question
4
  • 1
    You are missing a t in lisdata.svc, should be listdata.svc
    – Robert Lindgren
    Sep 26, 2014 at 6:37
  • Sorry for the typo. But with the correct query we are getting the error.
    – Kangkan
    Sep 26, 2014 at 7:42
  • 1
    Also the 'around Value looks off, is that to a typo?
    – Robert Lindgren
    Sep 26, 2014 at 7:44
  • Yes @RobertLindgren. As I said, if I make the query using the IE (11) on my machine (Win 7 Enterprise 64 bit) or any other machine it works fine and we get the response. But when we do it from the browser in the same machine (where SP is hosted), it fails. Other queries works fine though.
    – Kangkan
    Sep 26, 2014 at 8:11

2 Answers 2

Reset to default
1

If it works everywhere but on the server then you might be running into the "loop back check" issue. Spence Harbor has a very good post on this: Link

Improve this answer
-1

There is a typo (‘ is not allowed) in your request, the fixed request:

http://server:port/sites/sitecollection/site/_vti_bin/listdata.svc/listname?$filter=ColumnName eq 'Value'

Troubleshooting REST

It is frequently useful to view the HTTP messages that are being sent and received, the following tooling could be utilized for that purpose:

References

Common REST API Error Codes

Improve this answer
3
  • I wish you had read the comments along with. The typos are when I editied it here. As I have said time and again, the same query, Verbatim I say again, works from a remote machine in the network. But if I login (mstsc!) to the server (where the SP is running) and run it there, it fails.
    – Kangkan
    Sep 28, 2014 at 11:57
  • Have you ever tried to analyze the Http messages using the tools I have mentioned in the answer?
    – Vadim Gremyachev
    Sep 28, 2014 at 12:05
  • 1
    Yes @Vadim. I could not get any hint. I used Fiddler as well as the developer tool in the browser (both IE11 and FF). I have not used Wireshark though.
    – Kangkan
    Sep 28, 2014 at 13:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.