onedrive api returned “The property SMTotalFileStreamSize is not supported for OrderBy”

Question

https://graph.microsoft.com/v1.0/me/drive/root/children?select=id,name,size,webUrl,createdDateTime,lastModifiedDateTime,folder,parentReference&$top=1000&$orderby=size%20desc

Hi，你好，我们调用以上这个接口根据size（orderby=size）排序时，会报以下错误：

{"error":{"code":"notSupported","message":"The property SMTotalFileStreamSize is not supported for OrderBy.","innerError":{"date":"2024-12-25T02:18:45","request-id":"32382729-ed54-4879-ae44-899e59d0a87b","client-request-id":"32382729-ed54-4879-ae44-899e59d0a87b"}}}

我们实际测试的现象是：

onedrive 非会员账号会报这个错误，onedrive 会员账号则不会报这个错误

想请问下这个问题是什么原因，以及我们该怎么解决？

Answer 1

Hi @彦青 段

Try adding Prefer: HonorNonIndexedQueriesWarningMayFailRandomly to the request headers.

GET /me/drive/root/children?select=id,name,size,webUrl,createdDateTime,lastModifiedDateTime,folder,parentReference&$top=1000&$orderby=size%20desc

Prefer: HonorNonIndexedQueriesWarningMayFailRandomly

Hope this helps.

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