AnsweredAssumed Answered

One of the fields in XML output is semicollen separated. I need to do a connector for each one of them

Question asked by gouthamr388096 on Jul 10, 2018
Latest reply on Jul 10, 2018 by SaiKumarGoud Mallari

One of my XML outputs is as follows. If you notice PursuitTeam is a semicollen separated value. I need to somehow take each of these values and do a connector call to get userid's for each of these values. the final output should be something like (see the second XML). Can anyone suggest or give me some pointers please?

 

<Project>
      <ProjectTypeName>chargeable work</ProjectTypeName>
      <ClientUpdatedByName>tkocher</ClientUpdatedByName>
      <FullServiceLineName>Customer Experience</FullServiceLineName>
      <PursuitTeam>Cindy Garrett; Andrew Gaeckle; Etienne Coulonge</PursuitTeam>
</Project>

 

Desired output

 

<Project>
      <ProjectTypeName>chargeable work</ProjectTypeName>
      <ClientUpdatedByName>tkocher</ClientUpdatedByName>
      <FullServiceLineName>Customer Experience</FullServiceLineName>
      <PursuitTeam>Carrett; AGaeckle; ECoulonge</PursuitTeam>
</Project>

Outcomes