Teams

Retrieves a list of all teams and details of specified team.

Table Specific Information

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.

For example:

	SELECT * FROM Teams WHERE ProjectId = '837ccd31-8159-4db3' AND Id = '7f1d8582-a070-4d2b'

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

INSERT INTO Teams (ProjectId, Name) VALUES ('837ccd31-8159-4db3', 'TestTeam')


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique Identifier of the team.
Description	String	True		The description of the team.
IdentityId	String	True		Id of the identity.
IdentityIsActive	Boolean	True		Indicates whether the identity is active.
IdentityIsContainer	Boolean	True		Indicates whether the identity is a container.
IdentityMasterId	String	True		Master Id.
IdentityMetaTypeId	Integer	True		Meta Type Id.
IdentityProviderDisplayName	String	True		The display name for the identity as specified by the source identity provider.
IdentityResourceVersion	Integer	True		Resource version.
IdentitySubjectDescriptor	String	True		Subject descriptor.
IdentityUrl	String	True		Identity REST API URL to this team.
Name	String	False		The name of the team.
ProjectId	String	True	Projects.Id	The Unique Identifier of the project this team belongs to.
ProjectName	String	True		The name of the project this team belongs to.
Url	String	True		Team REST API URL.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ExpandIdentity	Boolean	A value indicating whether or not to expand Identity information in the result WebApiTeam object.
Mine	Boolean	Return all teams requesting user is member. Otherwise return all teams user has read access.