How to get the @microsoft.graph.downloadUrl of news items

Question

I want to retrieve the four newest news items from a SharePoint site and get the temporary download URL of the first image in it's webParts. Somehow there does not seem to be a direct way to retrieve this, so I found a way in multiple steps:

First I retrieve the top 4 newest news items by calling this URL with the correct access token:

https://graph.microsoft.com/v1.0/sites/{siteId}/pages/microsoft.graph.sitePage?$expand=webParts&$filter=promotionKind%20eq%20'newsPost'&$top=4&$orderby=lastModifiedDateTime%20desc

Then I create a map for all found listId's and get all items of each listId using:

https://graph.microsoft.com/v1.0/sites/{siteId}/lists/{listId}/items?select=eTag,lastModifiedDateTime&expand=driveItem(select=@microsoft.graph.downloadUrl)&top=10000

I know you can get this in pages using skipToken but getting many at once is faster (but still slow).

Then I go through the webParts of the news items and match it's uniqueId with the eTags in the listmaps, if the eTag contains the uniqueId then I find the @microsoft.graph.downloadUrl. Problem of course is that it takes a long time to do this. I tried using "&orderby=lastModifiedDateTime%20desc", this changes the output somewhat but I don't get the newest items at the top (then I could do top=50 or something like that). Also I tried using a filter based on lastModifiedDateTime >= the oldest of the four news items) but I get all kinds of error messages so I don't know how to do that.

Please let me know if you have any idea to optimize this flow, thanks in advance!

Answer 1

Hi @Roel Plieger (Bossers & Cnossen BV) ,

Thank you for posting in this community.

Unfortunately, there does not seem to be a direct way to retrieve the @microsoft.graph.downloadUrl of news items. Personally, I completely agree with you, this is indeed a good addition to the current features of SharePoint. Thank you for bringing things to our attention. We sincerely recommend you go to SharePoint Feedback community to provide your feedback: SharePoint · Community (microsoft.com). This is the best platform to let related team hear from you and make the products and services better for you and others.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.