Important Update: Archer Community Scheduled Maintenance on November 23–24 - New Community Launching Soon! Learn More..
2021-04-06 03:25 PM
Sorry to ask such a basic question but I did try for some time to get it down.
I am attempting to use Web Services API to pull a list of user accounts without a domain, GETUSERDOMAINLIST.
I have it all setup but I can not get the right value to pass for the domain, <usersDomain>No Domain</usersDomain>.
I tried NULL and various other keywords but I end up with, Server was unable to process request. ---> Domain not found..
Ideas?
2021-04-07 03:19 PM
That returns all users though, correct? It does not provide any mechanism for filtering results?
I have 100k+ user accounts, so I would rather just return the 15 or so accounts without a domain.
2021-04-07 03:34 PM
I recommend using REST API so that you can apply OData filters. For example, the following will select a few user attributes, filter users without a domain, and sort by last login descending. For more OData examples, check out the API Templates Application.
URL: /api/core/system/user
Body:
{
"Value": "?$select=Id,UserName,DisplayName,LastLoginDate&$filter=DomainId eq null&$orderby=LastLoginDate desc"
}