Mapping Configuration

Map the fields between Azure DevOps Server (TFS)/Azure DevOps Services (VSTS) and the other system to be integrated to ensure that the data between both the systems synchronizes correctly.

Click Mapping Configuration to learn the step-by-step process to configure mapping between the systems.
Mapping Configuration

Read Only Fields
Following fields are read-only fields and can be synchronized from Azure DevOps Server/Azure DevOps Services (TFS/VSTS) to other systems.

  • Area Id
  • Attached File Count
  • Authorized As
  • Authorized Date
  • Board Lane
  • External Link Count
  • Hyperlink Count
  • ID
  • Iteration Id
  • Node Name
  • Related Link Count
  • Rev
  • Revised Date
  • Team Project
  • Work Item Type
Note: Refer the table below to see how these fields behave for different kinds of configuration. The check marks mean – the fields allow write feature. The cross mark means – the fields are read only for the given configuration.
Field NameTarget SOAP APITarget SOAP API with Bypass EnableTarget Rest APITarget Rest API with Bypass Enable
Activated By
Activated Date
Board Column
Board Column Done
Changed By
Changed Date
Closed By
Closed Date
Created By
Created Date
Resolved By
Resolved Date
Resolved Reason
State Change Date
Note: All other fields (System or Custom) except the above-mentioned fields are supported for read and write.
  • For Changed By synchronization please mark ”override true” in the mapping (For source system).
  • For Azure DevOps Server/Azure DevOps Services (TFS/VSTS) to Azure DevOps Server/Azure DevOps Services (TFS/VSTS)integration, if source and target project names are different, then, for Path field, advance mapping is to be done. The mapping is as follows:
  • 
    <xsl:choose  xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >   
     <xsl:when test="SourceXML/updatedFields/Property/Path !='<Source Project Name>'">  
     <Path> 
      <xsl:value-of select="concat('<Target Project Name>\', substring-after(SourceXML/updatedFields/Property/Path ,'\'))"/>  
     </Path> 
    </xsl:when>   
    <xsl:otherwise>  
     <Path>  
      <xsl:value-of select="'<Target Project Name>'"/>  
     </Path>  
     </xsl:otherwise>  
    </xsl:choose>
    
  • If you want to create mapping between Micro Focus Test and Azure DevOps Server Test case with Micro Focus Test Parameters and Micro Focus Parameters , then few changes need to be done in the Parameter default mapping. Find field mapping between Micro Focus Test Parameters field and TFS Parameter, then click View/Edit XSLT Configuration to open advance mapping, and do following changes:
    • In case of Micro Focus and Azure DevOps Server mapping, find <xsl:value-of select="value"/> in default mapping and replace with <xsl:value-of select="utils:convertHTMLToPlainText(value)"/>
    • In case of Micro Focus to Azure DevOps Server mapping , find <xsl:value-of select="parameterName"/> in default mapping and replace with <xsl:value-of select="utils:replace(parameterName,' ','_')"/>. Here in replace method , you can use any character which will be replaced in place of space.
    • In case of Bi-directional configuration from Azure DevOps Server to Micro Focus, find <xsl:value-of select="parameterName"/> in default mapping and replace with <xsl:value-of select="utils:replace(parameterName,'_','')"/>. Here character provided in second parameter of replace method should be same which is given in previous configuration ,during Micro Focus and Azure DevOps Server mapping.

Integration Configuration

In this step, set a time to synchronize data between Azure DevOps Server (TFS)/Azure DevOps Services (VSTS) and the other system to be integrated. Also, define parameters and conditions, if any, for integration.

Click Integration Configuration to learn the step-by-step process to configure integration between two systems.
Azure DevOps Server (TFS)/Azure DevOps Services (VSTS)


Criteria Configuration

If you want to specify conditions for synchronizing an entity between Azure DevOps Server/Azure DevOps Services (TFS/VSTS) and the other system to be integrated, you can use the Criteria Configuration feature.

To configure criteria in Azure DevOps Server/Azure DevOps Services (TFS/VSTS), integration needs to be created with Azure DevOps Server/Azure DevOps Services (TFS/VSTS) as the source system. Query in Azure DevOps Server/Azure DevOps Services (TFS/VSTS) system is a valid Azure DevOps Server/Azure DevOps Services (TFS/VSTS) project query that contains a reference column as criteria available in the Azure DevOps Server/Azure DevOps Services (TFS/VSTS) system for a project. Display value for that field is the value for the criteria in Azure DevOps Server/Azure DevOps Services (TFS/VSTS).

How to get the reference name for Azure DevOps Server/Azure DevOps Services (TFS/VSTS) work item fields: To know the reference name of Azure DevOps Server/Azure DevOps Services (TFS/VSTS) work-item fields, refer section Find Reference Name of field. It will open a window in which you can find the Ref Name for the field for which you want to enter query.

Sample Criteria Examples

Field TypeCriteria DescriptionCriteria Snippet
LookupSynchronize all entities which have priority value as ‘1’[Microsoft.VSTS.Common.Priority] = ‘1’
LookupSynchronize all entities which have backlog status value ‘Active’ or ‘Done’[Microsoft.VSTS.Common.State] in (‘Active’, ‘Done’)
TextSynchronize all entities which contains ‘Bug Title’ in title field[System.Title] = ‘Bug Title’
UserSynchronize all entities which created by ‘user@domain.com’ user[System.CreatedBy] = ‘user@domain.com’
Lookup and UserSynchronize all entities which created by ‘user@domain.com’ user and primary as ‘1’[System.AssignedTo] = ‘user@domain.com’ and [Microsoft.VSTS.Common.Priority] = ‘1’

You can find more Criteria Configuration details on Integration Configuration page.


Appendix

Find Reference Name of field
  • Log in Azure DevOps Server (TFS)/Azure DevOps Services (VSTS) with a user having administrative rights.

Azure DevOps Server (TFS)/Azure DevOps Services (VSTS)

  • Select the Open workitem from Server menu item under the Tools > Process Editor > Work Item Types> Open WIT from Server.
  • Select the collection of the project that is to be synchronized.
  • Expand the project and then select the entity that is to be synchronized.
  • Click OK to open the Work Item Type Fields screen.

Expand the project

  • Here you find list of all the fields with data-type and reference name for selected work-item.

Expand the project