Forum Discussion

imbourg's avatar
imbourg
Copper Contributor
Dec 06, 2018
Solved

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

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 witho...
  • Joel Rodrigues's avatar
    Joel Rodrigues
    Dec 07, 2018

    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

imbourg's avatar
imbourg
Copper Contributor
Dec 07, 2018

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

Joel Rodrigues's avatar
Joel Rodrigues
MVP
Dec 10, 2018

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