Dot Net Mafia

Group site for developer blogs dealing with (usually) .NET, SharePoint, Office 365, Mobile Development, and other Microsoft products, as well as some discussion of general programming related concepts.

Introduction to querying lists with REST and ListData.svc in SharePoint 2010

What I really like about SharePoint 2010 is all of the new ways we can get at list data. You can always use the Client Object Model, Linq to SharePoint, or the existing object model, but one neat new way to get at list data is with listdata.svc. ListData.svc provides a way of getting information from a list (or lists using joins) using REST. What you end up with is a nice RSS feed of list data, that you can consume with whatever client you would like. You can construct URLs in various manners to get specific records, do joins, or perform simple queries. I won’t go through everything that you can do with it today, but I’ll point you towards resources to do the more advanced things.

When you are getting started, the first thing you want to do is check and see if you have ListData.svc up and running. Like any SharePoint web service, it’s located in the _vti_bin folder of any existing site, so it will work with items relative to that site. Here is what a typical URL might look like.

http://<sharepoint-server>/_vti_bin/ListData.svc

Try hitting that URL on your SharePoint 2010 server and see if it works. There is a good chance that you will get a 404 error. This happened to me, so I did some searching and found Rob Garret’s post stating to go out and install ADO.NET Data Services 1.5 CTP 2. There are a few choices, but I have seen others recommend you go with the runtime only. I had issues installing the full package. Once you have it installed, it still didn’t work for me, so I rebooted my server and everything worked fine when it booted back up. My guess is you probably could just reset IIS though.

Once you have a working ListData.svc, hitting it you should get results like this.

You get an XML document of all lists available to be queried. If you notice the href on each collection it gives you an idea of how you can construct subsequent URLs to get data. In today’s example, we’re going to work with a simple task list. We’ll look at the various ways we can get data from this list.

To get the data for this list via REST we simply just add the list name to the URL. In my case the name of the list is called Tasks. Here is what the URL would look like.

http://<sharepoint-server>/_vti_bin/ListData.svc/<ListName>

In my case:

http://sp2010/_vti_bin/ListData.svc/Tasks

Here is what the results look like.

As you can see we get an RSS feed and this is how Internet Explorer renders it. However, if we look at the actual XML of the feed, we’ll find that we get quite a bit of data back about the list. Here is a snippet of the XML.

As you can see in the content element, we can see the various site columns on a particular list item. Of course, there is more we can do with REST than just view everything in a list. If you want a specific item, you can use parenthesis and specify an indexer. Note that it is unit-indexed, not zero-indexed.

http://<sharepoint-server>/_vti_bin/ListData.svc/<ListName>(<Index>)

In my case:

http://sp2010/_vti_bin/ListData.svc/Tasks(3)

However, when you do this, Internet Explorer will give you an error that it cannot display this feed.

Not to worry though, if you view source, you still have a working XML document. It will pretty much look like the one above minus the initial feed information. You can take the query above and go one step further. Say, you just want to know the status for a specific task (note that the site column is actually called StatusValue here), you can simply add it to the URL like this.

The last thing I will cover is simple queries. You can do this with $filter. There are a number of operators you can use here, but the one I will start with today is eq (or equals). For example, say I want to see all tasks that are completed, I would use a URL like this. Put any literals inside quotes.

This returns results that look like this and of course the content element in the XML has the complete data on each list item returned.

You can also use various other types of predicates, such as ne, gt, ge, lt, le, and, or, not, etc. What each one does is probably pretty obvious, but if its not take a look at this MSDN reference for more information on the various filters and parameters you can use. Skip the code stuff at the begging and scroll down a bit to find the good stuff. This is a good start to working with REST in SharePoint, but this really is just the tip of it. What you are learning here isn’t really just specific to SharePoint but it applies to anything you do with ADO.NET Data Services, so it might be useful elsewhere later.

One thing I will point out is that I was not able to use this with an external list. I am guessing this is by design (which sucks), but it doesn’t look like it’s going to work. Of course, my install could just be broken or this could be subject to change.

Comments

Noel Fosterq
said:

ListData.svc does not work with external lists in SharePoint foundation 2010 - i get a 404.

April 23, 2010 12:44 AM

Mark
said:

Hi Corey, great post! I followed your instructions and I can get the page with the feed but the individual list items will not show up. I assumed this was a Firefox thing and tried to use the same url in Internet Explorer 7 but I can't even get the page to load in Internet Explorer. Any suggestions?

June 18, 2010 3:23 PM

Timen
said:

Good walkthrough, covers it all. It looks i have the same issue as Mark. http://<sharepoint-server>/_vti_bin/ListData.svc works!!

But if I go to sp2010/.../Tasks it shows me the RSS feed Tasks without any items.

If I make a list in designer I only get the properties and still no items. Any ideas?

June 25, 2010 7:23 AM

Steve
said:

I cant get this to work with the "Posts" list in a blog site. All of the other lists from the blog site work fine in this manner but when i try adding the "Posts" list i get "the website cannot display the page"

@Steve I've had issues with it myself on particular lists, but I haven't tried it on that particular one. I'll give it a try.

August 23, 2010 11:35 AM

morteng
said:

Hi

Thanks for the post!

I'm facing an issue, i have a custom ContentType with some fields that are of the type Managed Metadata, these fields doesn't get published in the listdatas.svc how to do this? I've been googling for the past 3hours with no luck :(

chaminda somathilaka
said:

I tried using this to add a list item with a lookup field (multiple allowed). But i failed get values added to the lookup field on the list. Also when I retrieve the list for items that have manually added lookup values, the REST service returned nothing.

Thanks for the great tutorial, just one to contribute a little bit that using ADO.NET data services, not only can you retrieve but also create and update data via REST and ListData.svc in SharePoint 2010. Let refer this link (msdn.microsoft.com/.../ff798339.aspx) if you are interested in. :)

December 26, 2011 3:11 AM

Raj
said:

Hi,

Its a great post.

I tried it and succeeded half way till creating data connection. However, when i used this for a dropdown control, nothing shows up. I am sure i binded repeating section and fields properly for the dropdown.

any help???

March 2, 2012 3:54 AM

Don
said:

Was having the same problem as several posters with list data requests returning 404 errors. Turns out that the list name is case-sensitive: sp2010/.../Tasks will work but

Thank you! This is an excellent alternative to display calendar events for a particular office/division where the calendar resides on another site collection. Instead of writing a farm solution to query other site collections for calendar data, or writing a sandboxed silverlight webpart using web services to query lists outside your site collection, this is simple way to surface list items to users. Thanks for the writeup.

Hi, very good explanatory article, but I would need to have something like this article to explain how to work with the TeamDiscussion collection via the ADO.net DATA web service, on simple "get all" query I am getting exception...

January 14, 2013 5:22 AM

Phil
said:

As well as the case sensitivity, the 404 error can be caused by not being able to display the RSS feed due to non-unicode characters in the list text fields