SharePoint API OData order by createddatetime not working

Question

I can't seem to get the orderby createddatetime working with the OData api query.
This are the api requests I've been using:
https://graph.microsoft.com/v1.0/sites/{siteid}/lists/{listid}/Items?$orderby=createdDateTime%20desc&$top=5
&
https://graph.microsoft.com/v1.0/sites/{siteid}/lists/{listid}/Items?$orderby=createdDateTime%20desc

What we have now:
A simple newspage that get's all of the sharepoint news items. We have come to the point that we have too many items to fit into one api answer. We could use the odata next link to get the other items but we just need the last few since we have copies saved into our database. We have a timer that runs every day to put the new items into our database.

What we want:
We want to use the same timer but it just needs to get the newest 5-or-so items.

Is my api request wrong?

Answer 1

Hi @RubenvandenBrinkMployAssociates-7142 ,

oData query parameter $orderby can be used on the expanded properties of fieldvalueset.

PFB screenshot

Note: Please note that Prefer: HonorNonIndexedQueriesWarningMayFailRandomly should be added in the Request headers, but be warned that such queries may fail on large lists.

Hope this helps.

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