Search non-app users via CQL

Confluence Development Confluence Cloud
,
1

Hi folks, is it possible to search users while filtering out app users?
Contrary to tickets like https://jira.atlassian.com/browse/CONFCLOUD-70582, the accountTypefield is now populated, however, it seems like it is still impossible to search for non-app users

<instance>/wiki/rest/api/search/user?cql=type=user and user.accountType = atlassian

returns:

{
    "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.accountType' Did you mean one of : user.accountid, user.fullname, user"
}
2

Hello @Corentin

The user field only supports the two sub-fields fullName and accountId to search on via CQL.

The user field documentation falsely claims you can also search on userKey, but just like accountType and all the other sub-fields, it’s not supported and will cause a 400 error.

You’ll just have to filter the CQL results in your code using the accountType value being returned.

3

Thanks, that’s what I did, but it would have been nicer with the pagination if I could have filtered directly on the API query.