SOLVED

SharePoint REST API: How to retrieve all folders in a list?

Highlighted
Occasional Contributor

Hello All,

Does SharePoint allow to retrieve all folders in a List? (Not a Doc Library). Just a basic List.

I am using SharePoint Online.

I tried /_api/web/lists/GetById('${ListID}')/Folders without luck.

 

And please can someone share a link to a comprehensive SPO Lists & Doc Lib REST API reference?

I only have this https://msdn.microsoft.com/en-us/library/office/jj860569.aspx#Reference .

Is it not outdated?

3 Replies
Highlighted
Best Response confirmed by imbourg (Occasional Contributor)
Solution

Hi @imbourg

 

You can filter by content type for example.

/_api/web/lists/GetByTitle('Documents')/items?$filter=ContentType eq 'Folder'

From here you can then select and expand other properties to return what you need.

 

Hope this helps

Thank you @Joel Rodrigues

 

I also found this: 

/_api/web/lists/GetById('${ListID}')/Items?$filter=FSObjType eq 1

But the problem is that just like yours, the response does not give the folders' names.

Then I found:

 

/_api/web/lists/GetById('${ListID}')/rootFolder/Folders

It gives the folders' name but curiously it finds an additional folder named Item :( 

Even with a list without folders, it will list that weird folder...

 

Thanks very much

Highlighted

@imbourg 

 

Using FSSobjType is another valid way of doing it.

Having to access the /Folders endpoint is what I meant with selecting and expanding the required properties. You have multiple properties you can select/expand to get all the information you need as they may be split across different endpoints.

 

Glad it's working for you :)

Sorry the delay in replying back. Swapped phone and had issues with MFA...

 

Joel