How to get Board detail (name or id) for board column in case of shared area path between 2 boards ?

Copper Contributor

I am having 2 kanban team boards under a project in ADO. I have a story item which is having shared area path between these 2 team boards. 
In order to retrieve item I am using API :
https://dev.azure.com/tasktop-sync-demo/Test Board Column/_apis/wit/workItems/5792498

On both boards my work item is on 2 different columns i.e. Column1 on Board1 and Column2 on Board2, Here in response I am getting these 2 columns with some generatedId keys "WEF_34545787865766_Kanban.Column"

 

{
"WEF_785DDB2D72A74EBCB0E642E4A45F12EC_Kanban.Column": "Column1", "WEF_785DDB2D72A74EBCB0E642E4A45F12EC_Kanban.Column.Done": false, "WEF_C2ECE6B228114F51A87D025B7DDB85CB_Kanban.Column": "Column2", "WEF_C2ECE6B228114F51A87D025B7DDB85CB_Kanban.Column.Done": false
}

 


My question is I want to map these generatedId with boards from which these Board columns are coming from for example if "WEF_785DDB2D72A74EBCB0E642E4A45F12EC_Kanban.Column" is coming for some BoardA then how can we get to know details such as Boardname about that corresponding board ?

1 Reply

@bizdevaccts we have to do it in multiple steps.

For example, work item here exist in two boards ("ProjectA Team" and in "MultiTeamDemo") , in same column Active. (it can be in different columns as well similar to yours)
https://dev.azure.com/chamindac/MultiTeamDemo/_apis/wit/workItems/2115

chamindac_0-1721811452489.png

Now when list borads for team "MultiTeamDemo" with https://dev.azure.com/chamindac/MultiTeamDemo/_apis/work/boards
I can get the board ids. Then I get the board id of my stories board for team "MultiTeamDemo"

chamindac_1-1721811988781.png


Then getting that board information with https://dev.azure.com/chamindac/MultiTeamDemo/_apis/work/boards/656164f9-01b2-46d0-bf13-f15e36334f13  (or you can use url for stories board returned by https://dev.azure.com/chamindac/MultiTeamDemo/_apis/work/boards) gives the refernece name WEF_FF38659E9F984B12B955413C347F6B1D_Kanban.Column

chamindac_3-1721812290961.png


same way for  "ProjectA Team" team using https://dev.azure.com/chamindac/MultiTeamDemo/ProjectA%20Team/_apis/work/boards can obtain the boad ids

chamindac_4-1721812435526.png

the board has the reference name  WEF_133F1CE23A904B95BFBD37CD9968BAB0_Kanban.Column in fieds


https://dev.azure.com/chamindac/MultiTeamDemo/ProjectA%20Team/_apis/work/boards/c609a8d9-9d84-4ec3-a... (or you can use url for stories board returned by https://dev.azure.com/chamindac/MultiTeamDemo/ProjectA%20Team/_apis/work/boards)

chamindac_6-1721812751543.png


So it is not straight forward. What you have to do is

  1. List all boards for your teams in the ADO project (including the boads of the team project (root team)), and filter for stories boards and obtain ids of those boards.
  2. Then query each board with id and obtain the fields.columnField.referenceName, so you can have list (table) of board IDs and its column reference.

    This will give you a map between column reference name and the board id.