I'm looking for a way to retrieve all files modified after a given time on SharePoint.
I've tried accessing the endpoints _api/web/lists/getbytitle (Query 1), which only seems to return folders and _api/web/GetFolderByServerRelativeUrl (Query 2), which only returns files in a given folder
Is there a way to search all files changed after a certain date in a document library?
This is the documentation I'm using: https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest
Query 1
https://bamgroup.sharepoint.com/sites/036222/_api/web/lists/getbytitle('Project%20Files')/items?$filter= Modified gt '2022-09-30T12:56:11'
Query 2
https://bamgroup.sharepoint.com/sites/036222/_api/web/GetFolderByServerRelativeUrl('Project%20Files')/files?$filter= Modified gt '2022-09-30T12:56:11'
THanks, and indeed I think I need to use the search api
Hi @rolanddaane,
You queries look ok.
Can you try this Uri as a test. I included the FileLeafRef. Sometimes titles of files can be empty:
_api/web/lists/getbytitle('Documents')/items?$filter=Modified gt '2022-09-30T12:56:11'&$expand=FieldValuesAsText&$select=FileLeafRef
Btw, Microsoft does have a separate Search API endpoint.
_api/search/query
I would also have a look at that specific endpoint: