1

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'
Improve this question

1 Answer 1

Reset to default
1

Try using this SharePoint REST API endpoint:

https://bamgroup.sharepoint.com/sites/036222/_api/web/lists/getbytitle('Project Files')/items?$filter=Modified gt datetime'2022-09-30T12:56:11.000Z'
Improve this answer
5
  • Did that, but it only returns changed folders. bamgroup.sharepoint.com/sites/036222/_api/web/lists/… gt datetime'2022-10-04T09:00:00.000Z' That retrieves modified files and I missed the datetime in the formula..... Why do w add the .000Z Isn't 2022-10-04T09:00:00 already in that date time format? Commented Oct 4, 2022 at 13:33
  • Is it working for you as expected or not? Commented Oct 4, 2022 at 13:38
  • 1
    You can ignore .000Z part (milliseconds) as well if not required. Check different ways to filter based on date column in SharePoint REST API at: sharepoint.stackexchange.com/questions/255543/… Commented Oct 4, 2022 at 13:40
  • 1
    Yes working as expected now! thanks. Where do I click that you solved this? i can't find it Commented Oct 4, 2022 at 14:57
  • Great, glad it worked for you! Commented Oct 4, 2022 at 15:18

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.