List Users

Table Specific Information

Select

The component 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 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')

Insert

The following is an example of inserting into a Users table:

INSERT INTO Users (UserPrincipalName, AccessLevelAccountLicenseType, UserSubjectKind) VALUES ('[email protected]', 'express', 'user')

Columns

Name	Type	References	Description
ParentReference	String
UserSK [KEY]	String
UserEmail	String
UserId	String
UserName	String