SSIS Components for Azure DevOps

Build 24.0.9063

DeploymentGroups

Retrieves a list of all deployment groups.

Table Specific Information

Select

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

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

For example:

    SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = 29
	SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Action = 'manage'
	SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Expand = 'tags'

Insert

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

INSERT INTO DeploymentGroups (ProjectId, Name) VALUES ('c831d3b4-a289-462f', 'TestName')

Update

The following is an example of updating a DeploymentGroups table:

UPDATE DeploymentGroups SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Delete

The following is an example of deleting data in a DeploymentGroups table:

DELETE FROM DeploymentGroups WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the deployment group.

Description String False

Description of the deployment group.

MachineCount Integer True

Number of deployment targets in the deployment group.

MachineTags String True

List of unique tags across all deployment targets in the deployment group.

Name String False

Name of the deployment group.

PoolId Integer False

Id of the agent pool.

PoolIsHosted Boolean True

A value indicating whether or not this pool is managed by the service.

PoolIsLegacy Boolean True

Determines whether the pool is legacy.

PoolName String True

Name of the pool.

PoolType String True

The type of the pool.

PoolScope String True

The scope of the pool.

PoolSize Integer True

The current size of the pool.

ProjectId String True

Id of the project.

ProjectName String True

Name of the project.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name Type Description
Action String

Get the deployment group only if this action can be performed on it.

使用できる値は次のとおりです。manage, none, use

Expand Boolean

Include these additional details in the returned object.

使用できる値は次のとおりです。none, tags

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