graph onedrive search + orderby

Question

question

FrancescoCarraro-4351 asked Jan 6, '22 saldana-msft edited 3 days ago

graph onedrive search + orderby

I'm trying to execute the following query for retrieving a flat list of pictures from my onedrive:

https://graph.microsoft.com/v1.0/me/drive/root/search(q='jpg')?select=id,lastModifiedDateTime,createdDateTime,name&orderby=lastModifiedDateTime+desc

I'm facing the issue related to the orderby clause that doesn't work.

Other info: I'm using a personal account for test but I'm would like to use the query in an app that use personal delegated access to onedrive.

Any solution?

Thanks in advance for any help

microsoft-graph-files microsoft-graph-search microsoft-graph-query-parameters

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-01-07T02:00:37.97Z

dkoeder answered Jan 7, '22

Try changing the +desc to %20desc.

 https://graph.microsoft.com/v1.0/me/drive/root/search(q='jpg')?select=id,lastModifiedDateTime,createdDateTime,name&orderby=lastModifiedDateTime%20desc

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-01-07T06:30:45.177Z

FrancescoCarraro-4351 answered Jan 7, '22 dkoeder commented Jan 7, '22

already tried. It doesn't work. It seems that orderby clause doesn't work with 'search'....when I try a query without the 'search' clause, the results are correctly ordered

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dkoeder · Jan 07 at 02:49 PM

Have you tested it against the sample account at https://developer.microsoft.com/en-us/graph/graph-explorer? It sorted correctly for me, when I tested it there, even with the 'search(q='jpg')'.

0 ·

Answer 3 · 2022-01-07T19:49:58.857Z

FrancescoCarraro-4351 answered Jan 7, '22 FrancescoCarraro-4351 commented Jan 10, '22

Hi,
thanks for the answer...it seems you're right: by using the sample account results are correctly ordered....so....is it a permission issue? do you know which kind of permission is required for having results ordered in the right way? or is it something else?

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BrianTJackett · Jan 08 at 03:51 AM

Based on my testing, this appears to sort properly with Work or School accounts (i.e. querying OneDrive for Business). When using a personal account (i.e. querying consumer OneDrive) it appears to not order the results as expected.

0 ·

FrancescoCarraro-4351 BrianTJackett · Jan 10 at 06:13 PM

thanks for your reply.
if so this is really a big issue for me....also this kind of difference in behaviour depending on the account type it's not documented....really a
big mess.....I have to find an alternative solution for exploring recursively the OneDrive account.

0 ·

question