SSIS Components for Azure DevOps

Build 24.0.9060

WorkItemRevisions

Retrieves a list of work item revisions. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.

Columns

Name Type References Description
Id [KEY] Integer Id of the work item.
Revision [KEY] Integer Revision of the work item.
ProjectId String Id of the project this changeset belongs to.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

Name Type Description
AsOf Datetime AsOf UTC date time string.
ErrorPolicy String The flag to control error policy in a bulk get work items request.

The allowed values are fail, omit.

Expand String The expand parameters for work item attributes.

The allowed values are all, fields, links, none, relations.

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