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

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

User's image

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.

Share via

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

1 answer

Your answer