Excel Add-In for Azure DevOps

Build 25.0.9434

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.
ProjectId String Id of the project.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434