SSIS Components for Azure DevOps

Build 24.0.9060

Backlogs

Retrieves all backlog levels and details of the specific backlog level.

Table Specific Information

Select

The component 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.
The rest of the filter is executed client-side in the component.


NOTE: TeamId is required in order to query BacklogPanelFields.

For example:

    SELECT * FROM Backlogs WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40'
	SELECT * FROM Backlogs WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND Id = 'Microsoft.EpicCategory'

Columns

Name Type References Description
Id [KEY] String Unique Id of the backlog.
ProjectId String Id of the project in which this backlog was created.
TeamId String

Teams.Id

Id of the team for which this backlog was created.
Color String The color of the backlog level.
DefaultWorkItemTypeName String The name of the field.
DefaultWorkItemTypeReferenceName String The reference name of the field.
DefaultWorkItemTypeUrl String The REST URL of the field.
IsHidden Boolean Indicates whether the backlog level is hidden.
Name String The name of the backlog.
Rank Integer Backlog rank (task backlog is 0).
Type String The type of this backlog level.
WorkItemCountLimit Integer Max number of work items to show in the given backlog.

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