SSIS Components for Azure DevOps

Build 24.0.9063

WorkItemIds

Retrieves a list of work items, for use with other tables in the Project schema.

Table Specific Information

Select

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

  • Id supports the '=' operator.

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

For example:

SELECT * FROM WorkItemIds WHERE Id = 1

Columns

Name Type References Description
Id [KEY] Integer Id of the work item.
Url String Full HTTP link URL.
ProjectId String Id of the project.

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