Excel Add-In for Azure DevOps

Build 25.0.9434

BacklogPanelFields

Retrieves panel fields for the specific backlog level.

Table Specific Information

Select

The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • ProjectId supports the '=' operator.
  • TeamId supports the '=' operator.
  • BacklogId supports the '=' operator.
The rest of the filter is executed client-side in the add-in.


NOTE: Specifying the TeamId and BacklogId can improve the performance when querying BacklogPanelFields.

For example:

    SELECT * FROM BacklogPanelFields WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND BacklogId = 'Microsoft.EpicCategory'
    SELECT * FROM BacklogPanelFields WHERE ProjectId = '03e4b7af-3bff-49d0' AND TeamId = '60efe1db-5742-4fe1' AND BacklogId = 'Microsoft.EpicCategory'

Columns

Name Type References Description
ProjectId [KEY] String Id of the project in which the backlog was created.
TeamId [KEY] String

Teams.Id

Id of the team for which the backlog was created.
BacklogId [KEY] String

Backlogs.Id

Id of the backlog these column fields belong to.
Name [KEY] String The name of the field.
ReferenceName String The reference name of the field.
Url String The REST URL of the field.

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