Answered

SharePoint search api

(0) Share

Report

Posted on by rolanddaane

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'

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Expiscornovus 33,867 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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:

https://learn.microsoft.com/en-us/sharepoint/dev/general-development/sharepoint-search-rest-api-overview

Was this reply helpful? Yes No
Verified answer

rolanddaane 73 on at

Like (1)

Report
Copy link

Link copied!

THanks, and indeed I think I need to use the search api

Was this reply helpful? Yes No