[Open Bugs Parented to Closed Stories] Set Work Item Parent to Related and Reparent to Regression Bugs

main.js

let vsts = require('vso-node-api');

let collectionURL = 'https://mcfddigitalservices.visualstudio.com/defaultcollection'
let workItemURL = 'https://mcfddigitalservices.visualstudio.com/_apis/wit/workItems/'

let token = 'TOKEN_HERE'

let authHandler = vsts.getPersonalAccessTokenHandler(token);
let connect = new vsts.WebApi(collectionURL, authHandler);

// ID of Regression Bugs Parent User Story
const regressionBugsUSId = 6294;

async function run() {
  let project = 'MCFD Digital Services';
  let vstsWorkTracking = await connect.getWorkItemTrackingApi();

  // Run Patrick's Bugs to Closed Stories Query
  let queryResults = await vstsWorkTracking.queryById("efea8964-582d-45cd-8a85-0346746bff62", {project: project})
  
  // Filter for linked bugs
  let linkedBugs = queryResults.workItemRelations.filter((item) =>{
    return item.rel == 'System.LinkTypes.Hierarchy-Reverse' && item.source != null && item.target != null;
  })

  for(let link of linkedBugs){
    let bugId = link.source.id
    let parentId = link.target.id

    let workItem = await vstsWorkTracking.getWorkItem(bugId, null,null, 'Relations')

    // Find index of parented story
    let relation = workItem.relations.findIndex((relation) => {
      return relation.rel == 'System.LinkTypes.Hierarchy-Reverse' && relation.url.includes('/workItems/' + parentId)
    })

    if (relation != -1) {
      // Remove parent story and make it related, add Regression Bug user story as parent
      let request = [
        {
          'op': 'remove',
          'path': '/relations/' + relation
        },{
          'op': 'add',
          'path': '/relations/-',
          'value': {
            'rel': 'System.LinkTypes.Related',
            'url': workItemURL + parentId
          }
        },{
          'op': 'add',
          'path': '/relations/-',
          'value': {
            'rel': 'System.LinkTypes.Hierarchy-Reverse',
            'url': workItemURL + regressionBugsUSId,
            'attributes': {
              'comment': 'Automated parenting to Regression User Story'
            }
          }
        }
      ]
      let updated = await vstsWorkTracking.updateWorkItem(null, request, bugId)
      console.log('Updated sucessfully: #' + bugId)
    }
  }
}

run();