Forum Discussion

roshan08's avatar
roshan08
Copper Contributor
Sep 13, 2023

API to pull all news post from sharepoint online site

Hi Team, Can we have API to pull all news post or all .aspx pages from sharepoint site.
SharePoint Online
Nishkalank's avatar
Nishkalank
Copper Contributor
Sep 14, 2023

Hey roshan08 

You can use SharePoint Search API to fetch all the news pages from specific sites as below

 

 

https://xxx.sharepoint.com/_api/search/query?querytext='SPContentType:"Site Page" AND IsDocument:True AND FileExtension:aspx AND PromotedState:2 AND FirstPublishedDate=today AND  Path:https://xxx.sharepoint.com/sites/xxx OR Path:https://xxx.sharepoint.com/sites/xxx OR Path:https://xxx.sharepoint.com/sites/xxx/SitePages'&sortlist='FirstPublishedDate:descending'&startRow=0&rowlimit=100&selectproperties='Title,Description,RefinableString03,FirstPublishedDate,PictureThumbnailURL,WebId,Path'

 


There is a possibility to use https://devblogs.microsoft.com/microsoft365dev/sharepoint-pages-microsoft-graph-api-is-now-available-for-public-preview/ as well that you may try it.

Thanks,
Nishkalank Bezawada

Resources