Users

List Users

Table Specific Information

Select

The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side in the connector.

UserSK supports the '=,in' operators.

For example:

	
	SELECT * FROM Users WHERE UserSK = '4dbc0cec-c473-652b-972f-f42587b4494d'
	SELECT * FROM Users WHERE UserSK IN ('4dbc0cec-c473-652b-972f-f42587b4494d', '6ddc3cee-c232-634b-342f-f84325b4494d')

Columns


Name	Type	References	Description
ParentReference	String		Parent reference. Only available if IncludeReferenceColumn=true.
UserSK [KEY]	String		User surrogate key.
AnalyticsUpdatedDate	Datetime		Watermark that indicates the last time the Analytics data was updated.
UserEmail	String		Email associated with a user account identity.
UserId	String		Unique identifier assigned to a user account identity.
GitHubUserId	String		GitHub user ID associated with the user account.
UserName	String		The type of user.

CData Python Connector for Azure DevOps

Users

Table Specific Information

Select

Columns