Excel Add-In for Azure DevOps

Build 24.0.9060

WorkItemIds

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

Table Specific Information

Select

The add-in 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 add-in.

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 .

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