Skip to main content

Notifications

Power Automate - General Discussion
Answered

SharePoint search api

(0) ShareShare
ReportReport
Posted on by 73

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'

  • Verified answer
    rolanddaane Profile Picture
    rolanddaane 73 on at
    Re: SharePoint search api

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

  • Expiscornovus Profile Picture
    Expiscornovus 31,144 on at
    Re: SharePoint 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:

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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard