How can we get the user Account Id in confluence cloud via email id ?

Question

Hi All,

I am trying to get the user account id via email because I did not have the full name of the user to provide the space permission using below API

https://aidtdmtrename.atlassian.net/wiki/rest/api/search?cql=user.email~"xxx@gmail.com"&start=0&limit=1000

but we are getting below error :

{    "statusCode": 400,    "data": {        "authorized": true,        "valid": true,        "errors": [],        "successful": true    },    "message": "com.atlassian.confluence.api.service.exceptions.BadRequestException: No field exists with the name: 'user.email' Did you mean one of : user.fullname, user.accountid, user"}

Can anyone help me on the same.

Jamie Wolman · Answer

Sadly using the full name does not work as we have multiple systems that store the full name differently (be it a true full name or a nickname, etc.) that chances are this will not work 100% of the time. Whereas email is consistent across these systems, why can't we have this work to get user by email?

Aaron Pavez _ServiceRocket_ · Answer

Hi @d_b_kumar_chauhan

It seems the user.email doesn't work. Can't find documentation on that one.

https://developer.atlassian.com/cloud/confluence/rest/v1/api-group-users/#api-wiki-rest-api-user-email-get

But the full name does work:

https://adpbcj.atlassian.net/wiki/rest/api/search?cql=user.fullname~"aaron"

The email asks for the account ID.

email?accountId={accountId}'

Regards