【SharePoint】通过SharePoint rest api获取文档库中的文件（排除文件夹，进获取文件）Exclude folder from results in SharePoint api

前言

很多时候，需要单独获取SharePoint文档库中的文件（不包含文件夹），如下为实现方式

实现

https://weburl/_api/web/lists/getbytitle('list name')/items?$select=file/Name,file/uniqueid&$expand=File&$filter=FSObjType eq 0&$top=20

https://weburl/_api/web/lists/getbytitle('list name')/items?$top=1000&$select=Title,FileLeafRef,FieldValuesAsText/FileRef,FieldValuesAsText/FileRef/Title&$expand=FieldValuesAsText&$filter=FSObjType eq 0

https://weburl/_api/web/lists/getbytitle('list name')/items?$top=1000&$select=Title,FileLeafRef,FieldValuesAsText/FileRef,FieldValuesAsText/FileRef/Title&$expand=FieldValuesAsText&$filter=startswith(ContentTypeId, '0x0101')

--demo 01
var g;  
$.ajax({  
url: _spPageContextInfo.siteAbsoluteUrl + "/_api/web/Lists/GetByTitle('Training Material')/Items",  
type: 'GET',  
dataType: "json",  
headers: {  
    "Accept": "application/json;odata=verbose",  
    "content-type": "application/json; odata=verbose",  
    "X-RequestDigest": $("#__REQUESTDIGEST").val()  
},  
success: function (data) {  
    for (var i = 0; i < data.d.results.length; i++) {  
        if (data.d.results[i].FileSystemObjectType != 1) {            
        }  
    }  
},  
error: function (request, error) {  
    console.log(JSON.stringify(request));  
}  
}); 

--demo 02
var RestUrl= _spPageContextInfo.webAbsoluteUrl+ "/_api/Web/GetFolderByServerRelativeUrl('/Shared%20Documents')?$expand=Folders,Files";      //document library name

    $.getJSON(RestUrl,function(data,status,xhr){

        if(data.Files.length > 0)
        {
        var results = data.Files;
        }
    });