Sorting by createdDateTime with Graph API returns unsupportedQuery

Question

Sorting by createdDateTime with Graph API returns unsupportedQuery

Jirayu Methathip 5

Hello,

I am attempting to query users using pagination, sorting by createdDateTime in descending order. According to the official documentation for Graph API, sorting using advanced query parameters should be supported. However, despite including the necessary parameters in the request, I am still receiving the following error message in the response:

{
    "error": {
        "code": "Request_UnsupportedQuery",
        "message": "Unsupported sort property 'createdDateTime' for 'User'.",
        "innerError": {
            "date": "2023-12-26T09:17:14",
            "request-id": "01ad7d5e-c76f-4c07-a66d-dcbb71ebf674",
            "client-request-id": "01ad7d5e-c76f-4c07-a66d-dcbb71ebf674"
        }
    }
}

And this is the request (in curl)

curl --location 'https://graph.microsoft.com/v1.0/users?%24select=identities%2CbusinessPhones%2CdisplayName%2CgivenName%2CjobTitle%2Cmail%2CmobilePhone%2CpreferredLanguage%2Csurname%2CuserPrincipalName%2Cid%2CcreatedDateTime&%24orderby=createdDateTime%20desc&%24count=true' \
--header 'ConsistencyLevel: eventual' \
--header 'Authorization: Bearer {{token}}'

Does anyone have any suggestions or experience with this issue? Thank you in advance for your help!

2 answers

Your answer

Answer 1

Diah.Karim-MSFT 335 Microsoft External Staff

Hi Jirayu..

I think the above endpoint been called with incorrect value (the $count=true should come before the $orderby)

i have tested with below endpoint and its works. And i'm using the Graph Explorer to test it.

https://graph.microsoft.com/v1.0/users?$select=identities,businessPhones,displayName,givenName,jobTitle,mai,mobilePhone,preferredLanguage,surName,userPrincipalName,id,createdDateTime&$count=true&$orderby=createdDateTime desc

Hope this helps.

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

Jirayu Methathip 5 Reputation points

2023-12-27T07:15:09.37+00:00

Thank you for your answer. Yes I tried with the Graph explorer as well and it is only place that works.
But when I tried with either Postman, Curl or Graph SDK (C#). It doesn't work.

Answer 2

CarlZhao-MSFT 46,351

I just did a quick test using Graph Explorer and it seems to be working fine. So I'm sure using the createdDateTime parameter to sort user sets is supported in advanced queries.

57d1e556-a919-4658-a095-a9c3b6e162d2

Bunthita Woramongkolchai 5 Reputation points

2023-12-27T04:36:31.0166667+00:00
Hello, I have the same question with him.
I tested like this in Graph Explorer and it works.

but when I tested it in Postman, it returns error like this

but if I changed $orderby to default field, it can sort in postman.

the different request between graph explorer and postman is the token.
In graph explorer, I think it used the example token. but in my postman I used the real token.

Here are my all permissions for my real token

User.ReadWrite.All

Directory.ReadWrite.All

User.EnableDisableAccount.All

Directory.Read.All

User.ManageIdentities.All

Is it enough for sorting this field? or do I have to do anything for solving this?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
CarlZhao-MSFT 46,351 Reputation points

2023-12-27T05:55:24.3066667+00:00

To me, it doesn't seem to make a difference.
Jirayu Methathip 5 Reputation points

2023-12-27T07:18:20.5766667+00:00

I was thinking the same that it must be supported. I tried with the Graph explorer already and it is place that works. But when using Postman, curl or Graph SDK (C#), they don't work with some reasons.

We need to get it worked via Graph SDK for production code though.
CarlZhao-MSFT 46,351 Reputation points

2023-12-27T07:25:07.86+00:00

I haven't tested it with c# yet, give me a few minutes to do a quick test.

However, as you can see, it works fine in postman in the screenshot I shared.
Bunthita Woramongkolchai 5 Reputation points

2023-12-27T07:30:24.4166667+00:00

Is it possible to be related with the permission? or do we need to config something for sorting in portal?
CarlZhao-MSFT 46,351 Reputation points

2023-12-27T07:35:28.5666667+00:00

@Bunthita Woramongkolchai @Jirayu Methathip

I just did a quick test using the C# SDK. For me, it still works fine.
CarlZhao-MSFT 46,351 Reputation points

2023-12-27T07:41:40.7066667+00:00

@Bunthita Woramongkolchai

Not sure, as my app doesn't look like anything special.

Can you export your token and share a screenshot? I'll try generating a similar token and try again.
Jirayu Methathip 5 Reputation points

2023-12-27T07:52:13.5866667+00:00

@CarlZhao-MSFT Thank you for your confirmation. Would you mind to share the curl? I may miss in some parts.
Bunthita Woramongkolchai 5 Reputation points

2023-12-27T08:23:18.17+00:00

@CarlZhao-MSFT Thank you! but I can't share the token for this. Could I share you a curl that I called for the token and the screen shot for the role level that extracted from my token instead?

Here is the curl that I called for generating token

curl --location 'https://login.microsoftonline.com/{{tenant_id}}/oauth2/v2.0/token' \

--header 'Content-Type: application/x-www-form-urlencoded' \

--header 'Cookie: fpc=cookies; stsservicecookie=estsfd; x-ms-gateway-slice=estsfd' \

--data-urlencode 'grant_type=client_credentials' \

--data-urlencode 'client_id={{client_id}}' \

--data-urlencode 'client_secret={{client_secret}}' \

--data-urlencode 'scope=https://graph.microsoft.com/.default'

and here is the screenshot for the role that I extracted from the token.
CarlZhao-MSFT 46,351 Reputation points

2023-12-27T09:02:23.8266667+00:00

@Jirayu Methathip

I've checked the curl you shared in your question and it looks perfect. It's really puzzling as to why the same command reports an error in your environment.

Can you open a support ticket for this issue to submit it to the support team?
CarlZhao-MSFT 46,351 Reputation points

2023-12-27T09:19:18.5433333+00:00

@Bunthita Woramongkolchai

I just created a new app and requested a new token. Parsing the token I see that it is no different than the screenshot of the token you shared.
Bunthita Woramongkolchai 5 Reputation points

2023-12-27T09:55:37.94+00:00

@CarlZhao-MSFT Thank you very much for your helps. I also checked my token with your token. and I saw that it looks like the same as yours. but I still don't know why I can't do it like you. I will find what is the root cause for this.

Share via

Sorting by createdDateTime with Graph API returns unsupportedQuery

2 answers

Your answer