Excel Add-In for Azure DevOps

Build 26.0.9770

WorkItemIds

Retrieves a list of work items.

Table Specific Information

Select

Unlike the rest of the tables in the Analytics schema, which use the OData API, this table uses the REST API.

This is because other tables in the Analytics schema require the work item id, but since work item ids cannot be retrieved via OData, they must instead be retrieved using the REST API.

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) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770