Sort order for Sharepoint API “GET sites?search=*"

Question

https://learn.microsoft.com/en-us/answers/questions/2152627/sort-order-for-sharepoint-api-get-sites-search-*?comment=answer-1908331&page=1#comment-1894317

In the past, the above query showed that “GET sites?search=” does not support sorting, but “GET sites?search=&orderby=name” sorts alphabetically. The response we received was that “GET sites?search=*&orderby=name” sorts alphabetically.

I have an additional question: In the “GET sites?search=*&orderby=xxx” API, what is the sort order when “size” and “lastModifiedDateTime” are specified in the orderby query? I would like to know about the sort order when “size” and “lastModifiedDateTime” are specified in the orderby query.

Also, the following document states that the only property that can be sorted when searching a site is “createdDateTime”.

https://learn.microsoft.com/ja-jp/graph/api/site-search?view=graph-rest-1.0&tabs=http

Is it correct that both the “name” and “lastModifiedDateTime” properties are internally sorted, but only the “createdDateTime” property is able to refine the sorting function?

Answer 1

Hi @Ayase Morita,

I'm sorry that there are some mistakes in the previous case. After confirming with our team and test in our environment, the only property that works for sorting is createdDateTime. The GET sites?search=*&orderby=xxx API allows sorting by other properties.

---

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.