SSIS Components for Azure DevOps

Build 24.0.9063

Users

Retrieves a list of users. This table will not retrieve results for the On-premise edition.

Table Specific Information

Select

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

  • Id supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

For example:

SELECT * FROM Users WHERE Id = 'c774bab2-7c43-65da-8ae4-be3ca4519257'

Insert

When performing an Insert, the following fields are required: UserPrincipalName, UserOriginID, AccessLevelAccountLicenseType

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

INSERT INTO Users (UserDisplayName, UserPrincipalName, UserOriginID, AccessLevelAccountLicenseType, UserSubjectKind) VALUES ('Anirudh', '[email protected]', '000300003732A094', 'express', 'user')

Update

The Update operation is not supported for this table.

Delete

Due to the fact that there is no way to distinguish between the API response for a successful and a failed DELETE for this table, the affected row count is always -1.

The following is an example of deleting from the Users table:

DELETE FROM Users WHERE Id = '7342ddfe-abc9-4884-9fbf-773be61e2c92'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Id of the User.

AccessLevelAccountLicenseType String False

Type of Account License (e.g. Express, Stakeholder etc.).

AccessLevelAssignmentSource String False

Assignment Source of the License (e.g. Group, Unknown etc.).

AccessLevelLicenseDisplayName String False

Display name of the license.

AccessLevelLicensingSource String False

Licensing Source (e.g. Account. MSDN etc.).

AccessLevelMSDNLicenseType String False

Type of MSDN License (e.g. Visual Studio Professional, Visual Studio Enterprise etc.).

AccessLevelStatus String False

User status in the account.

AccessLevelStatusMessage String False

Status message.

DateCreated Datetime True

Date the user was added to the collection.

LastAccessedDate Datetime True

Date the user last accessed the collection.

UserDescriptor String False

The descriptor is the primary way to reference the user while the system is running.

UserDirectoryAlias String False

The short, generally unique name for the user in the backing directory.

UserDisplayName String False

This is the non-unique display name of the graph subject.

UserDomain String False

This represents the name of the container of origin for a graph member.

UserMailAddress String False

The email address of record for a given graph member.

UserMetaType String False

The meta type of the user in the origin, such as 'member', 'guest', etc.

UserOrigin String False

The type of source provider for the origin identifier (ex:AD, AAD, MSA).

UserOriginId String False

The unique identifier from the system of origin.

UserPrincipalName String False

This is the PrincipalName of this graph member from the source provider.

UserSubjectKind String False

This field identifies the type of the graph subject.

UserUrl String False

This url is the full route to the source resource of this graph subject.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063