How to List Documents in a SharePoint 2010 Folder with REST

Question

I'm trying to access an SPS 2010 document library that contains folders, which in turn contain documents. I can successfully list the content of the library and see all folders and root-level documents, yet I can't figure out the way to list the contents of a library folder.

For example, a site has a library called Shared Documents, which in turn contains a folder called F1. I can successfully list the contents of the Shared Documents library:

https://contoso.com/_vti_bin/ListData.svc/SharedDocuments

and even retrieve details for the folder:

https://contoso.com/_vti_bin/ListData.svc/SharedDocuments(3)

but I can't figure out how to list the contents of the folder F1. For example, the most obvious thing doesn't work:

https://contoso.com/_vti_bin/ListData.svc/SharedDocuments/F1

This returns an error that I can't fathom:

The request URI is not valid. Since the segment 'SharedDocuments' refers to a collection, this must be the last segment in the request URI. All intermediate segments must refer to a single resource.

Neither does this:

https://contoso.com/SharedDocuments/_vti_bin/ListData.svc/F1

That request errors out without much specific information.

Sadly, I have to use the REST API, no other methods are acceptable in this specific case. Is it even possible to list subfolders with the REST API on 2010?

Answer 1

In order to return items from a specific folder use $filter query option with Path property:

$filter=Path eq '<folder relative url>'

Example

Assume a Documents library that contains Orders folder.

Then, the following REST query returns all documents located under Orders folder:

https://contoso.sharepoint.com/_vti_bin/ListData.svc/Documents?$filter=Path eq '/Shared Documents/Orders'

References

Use OData query operations in SharePoint REST requests