FireDAC Components for Azure DevOps

Build 21.0.7930


Retrieves a list of users.

Table Specific Information


The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • Id supports the '=,in' operators.
For example:
	SELECT * FROM Users WHERE Id = '4dbc0cec-c473-652b-972f-f42587b4494d'
	SELECT * FROM Users WHERE Id IN ('4dbc0cec-c473-652b-972f-f42587b4494d','6ddc3cee-c232-634b-342f-f84325b4494d')


Name Type References Description
Id [KEY] String Id of the User.
AccessLevelAccountLicenseType String Type of Account License (e.g. Express, Stakeholder etc.).
AccessLevelAssignmentSource String Assignment Source of the License (e.g. Group, Unknown etc.).
AccessLevelLicenseDisplayName String Display name of the license.
AccessLevelLicensingSource String Licensing Source (e.g. Account. MSDN etc.).
AccessLevelMSDNLicenseType String Type of MSDN License (e.g. Visual Studio Professional, Visual Studio Enterprise etc.).
AccessLevelStatus String User status in the account.
AccessLevelStatusMessage String Status message.
DateCreated Datetime Date the user was added to the collection.
LastAccessedDate Datetime Date the user last accessed the collection.
UserDescriptor String The descriptor is the primary way to reference the user while the system is running.
UserDirectoryAlias String The short, generally unique name for the user in the backing directory.
UserDisplayName String This is the non-unique display name of the graph subject.
UserDomain String This represents the name of the container of origin for a graph member.
UserMailAddress String The email address of record for a given graph member.
UserMetaType String The meta type of the user in the origin, such as 'member', 'guest', etc.
UserOrigin String The type of source provider for the origin identifier (ex:AD, AAD, MSA).
UserOriginId String The unique identifier from the system of origin.
UserPrincipalName String This is the PrincipalName of this graph member from the source provider.
UserSubjectKind String This field identifies the type of the graph subject.
UserUrl String This url is the full route to the source resource of this graph subject.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930