How search inside all folders in Document Library

Question

How can I search thought REST API all files in Document Library(DocLib), inside sub-folders included. Let's say I have:

• Folder 1A
  • Folder 1.1
    • File A;
• Folder 2
  • File AA;
• File AAA;

And I search a so I get:

• File A;
• File AA;
• File AAA

Only files everywhere. Thanks in advance.

PS: I'm pretty new at SharePoint and Rest Api so please explain don't just give me the code. Thanks

Answer 1

If you need to find items by filename the best way is to use CSOM with a CAML query. The important thing is to set the scope to RecursiveAll. It will traverse all folders and all files. The filename column is called FileLeafRef so you need to change below query accordingly.

var ctx = SP.ClientContext.get_current();
var web = ctx.get_web();
var list = web.get_lists().getByTitle(listTitle);
var query = new SP.CamlQuery();
query.set_viewXml('<View Scope='RecursiveAll'><Query><OrderBy><FieldRef Name="Modified" Ascending="FALSE"/></OrderBy></Query><RowLimit>1</RowLimit></View>');
var items = list.getItems(query);
ctx.load(items);
ctx.executeQueryAsync(
  function() {
    if(items.get_count() > 0) { 
       var item = items.getItemAtIndex(0); 
       Success(item);
    }
    else
    {
        Success(null);
    }
  },
  Error
);

Answer 2

use below query in REST API:

This will return all files with the phrase ‘Preview’ in the FileRef field):

/_api/web/lists/getByTitle('ListName')/items?$select=FieldValuesAsText/FileLeafRef&$expand=FieldValuesAsText&$filter=substringof('Preview',FileLeafRef)

where FileLeafRef is internal name for Name field in Document Lib