Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am working in SP2010 and have a simple InfoPath form that calls the listdata.svc to populate a drop down. I am trying to work out the URL that will return me all of the State data from a list of 27K state data sets.

The atom/xml looks like this:


<entry m:etag="W/"1"">
    <id>http://blah.com/sites/S/_vti_bin/listdata.svc/US_Distance_Table(1)</id> 
  <title type="text">AL</title> 
- <content type="application/xml">
- <m:properties>
   <d:State>AL</d:State> 
   <d:City>ABBEVILLE</d:City> 
   <d:BandCode>100 Mile Band</d:BandCode> 
  </m:properties>
  </content>
</entry>

URL I am trying is:


http://Blah.com/sites/S/_vti_bin/listdata.svc/US_Distance_Table?$filter=State eq'TX'


But it returns error. Now peeling back the URL does return some results. For example, I can call ....listdata.svc/US_Distance_Table(5) and get the 5th record. What am I missing here?

share|improve this question

1 Answer 1

Your URL looks right

But if your table has 27000 items, then you're probably hitting a resource throttling limit unless it's State is an indexed column

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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