SSIS Components for Azure DevOps

Build 24.0.9063

TeamIterations

Retrieve a team's iteration.

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.
  • ProjectId supports the '=' operator.
  • TeamId supports the '=' operator.
  • AttributesTimeFrame supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM TeamIterations WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM TeamIterations WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = '2bc932aa-21bd-4d2f-860d-43c843b46431'
	SELECT * FROM TeamIterations WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND AttributesTimeFrame = 'current'

Insert

The following are examples of inserting into TeamIterations table:

INSERT INTO TeamIterations (ProjectId, TeamId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', '619e870e-5242-4218-bedd-c52d8c003591', 'hello@122')
This example shows how to add a separate Iterations table:
INSERT INTO TeamIterations (ProjectId, TeamId, Id) VALUES ('c831d3b4-a289-462f', '7f1d8582-a070-4d2b', 'afaad11d-8025-4c31')

Update

The following is an example of updating a TeamIterations table:

UPDATE TeamIterations SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND TeamId = '619e870e-5242-4218-bedd-c52d8c003591'

Delete

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

DELETE FROM TeamIterations WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND TeamId = '619e870e-5242-4218-bedd-c52d8c003591'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

Id of the iteration.

ProjectId String False

Id of the project.

TeamId String False

Teams.Id

Id of the team.

AttributesFinishDate Datetime False

Finish date of the iteration.

AttributesStartDate Datetime False

Start date of the iteration.

AttributesTimeFrame String False

Time frame of the iteration, such as past, current or future.

Links String True

Aggregate of the reference links.

Name String False

Name of the iteration.

Path String False

Relative path of the iteration.

Url String False

Full http link to the resource.

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