Forum Discussion
SharePoint REST API: How to retrieve all folders in a list?
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
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 1But the problem is that just like yours, the response does not give the folders' names.
Then I found:
/_api/web/lists/GetById('${ListID}')/rootFolder/FoldersIt 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
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
Joel Rodrigues I have a feeling that no matter how complex site content types get, any instance of any type will always have a field "FSObjType" that is always equal to 0 for non-folders and 1 for folders. I myself am trying to filter out folders and Document Sets but include everything else. Is this the way to do this?
- Thank you Joel. I am working on SharePoint Online and used the api to get all folders from a Document Library. I have issue when i use $select=FileLeafRef,FileRef,Id. The return JSON object have duplicate ID property like (Id and ID) both have same value. This is a issue while parsing JSON in PowerAutomate as schema contains duplicate properties. Any help appreciated to avoid getting duplicate ID property.. Thank you
