Get all items from a folder using REST

Question

Currently I am using REST in order to get item titles in the Pages directory. The problem is that it is pulling all the elements that are in the pages directory and I only want it to pull from a certain subfolder in the pages directory.

var moduleServiceUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/lists/getbytitle('Pages')/Items?$select=ID,Title,FileRef,Modules";

This is what the call currently looks like.

score 11 · Answer 1 · edited Apr 13 '17 at 12:41

11

Try to use this endpoint GetFolderByServerRelativeUrl to return all files and folder at a specific folder URL

https://server/_api/Web/GetFolderByServerRelativeUrl(<folder url>)?$expand=Folders,Files

To return only all files at a specific folder URL

https://server/_api/Web/GetFolderByServerRelativeUrl(<folder url>)?$expand=Files

For more details check get all the files and folders contained inside a SharePoint folder in one rest API call.

Also if you need work with CSOM check How to get all the files inside the folder in list

edited Apr 13 '17 at 12:41

Community

1

answered Sep 20 '16 at 21:31

Mohamed El-Qassas MVP

45,382
9
53
96

It only retrieves the first 100 and includes a link to "next 100" Is there any way to pull everything in the list without pagination? – Si8 Mar 22 '17 at 16:00
Add to your url the parameter: &$top=1000 – Oskar Apr 05 '18 at 06:57

score 1 · Answer 2 · answered Mar 30 '17 at 21:43

The query you are using will return all items irrespective of type (folder/file). You can use change to below syntax.

_spPageContextInfo.webAbsoluteUrl + "/_api/web/getfolderbyserverrelativeurl('<<folder relative path>>')/Files

Example for folder relative path is

/[subsite]/<<library name>>/<<folder name>>

score 1 · Answer 3 · answered May 12 '23 at 15:54

1

You can try using:

_api/web/Lists/GetByTitle('{listTitle}')/Items?$filter=FileDirRef eq '{serverRelativeUrl}'

However it will only give items from the specific folder.

This query:

_api/web/Lists/GetByTitle('{listTitle}')/Items?$filter=startswith(FileDirRef, '{serverRelativeUrl}')

should return items from other sub folders also.

answered May 12 '23 at 15:54

Beniamin

131
4

Thanks, that filter is what I needed to restrict results to a specific folder. – Zarepheth Feb 12 '24 at 19:50

score 0 · Answer 4 · answered Sep 21 '16 at 04:02

0

I don't fully understand what you need but in order to get attributes of a subfolder you need to access the folder first through this endpoint GetFolderByServerRelativeUrl.

Here is a Microsoft documentation regarding Files and folders REST API call.

answered Sep 21 '16 at 04:02

iambvttercvp

91
2
12

score -1 · Answer 5 · edited Dec 06 '17 at 08:08

-1

_spPageContextInfo.webAbsoluteUrl + "/_api/Lists/getbyTitle('" + LibraryName + "')/Items?$select=FileLeafRef,FileRef,Id&$top=5000

This URL will Resolve ur all problems

edited Dec 06 '17 at 08:08

Dikesh Gandhi

6,803
4
30
55

answered Dec 06 '17 at 07:44

Negi Rox

211
3
9

Get all items from a folder using REST

5 Answers5

Linked