AnsweredAssumed Answered

XML Data transform

Question asked by oleg.chuev@konicaminolta.ru on Nov 1, 2016
Latest reply on Apr 19, 2017 by oleg.chuev@konicaminolta.ru

Hello!

 

I have a question about data transform.

I have a chain of processes. I need to insert to the flexi task notification a variable that contains information about all updates in table style.

 

I read information about the item by “Call Web service” action.

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m="http://schemas.microsoft.com/sharepoint/soap/">
  <soap:Header>
  </soap:Header>
  <soap:Body>
    <m:GetVersionCollection>
      <m:strlistID>{Common:ListID}</m:strlistID>
      <m:strlistItemID>{ItemProperty:ID}</m:strlistItemID>
      <m:strFieldName>AppendedText</m:strFieldName>
    </m:GetVersionCollection>
  </soap:Body>
</soap:Envelope>

 

This action provide me XML:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <soap:Body>

    <GetVersionCollectionResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/">

      <GetVersionCollectionResult>

        <Versions>

          <Version Comment="User, First (Approve) 10/28/2016 3:14 PM - 10/28/2016 3:14 PM&#xA;(User, First) Some text comment" Modified="2016-10-28T12:14:37Z" Editor="2;#User,, First,#i:0#.w|domain\first,#first.user@domain.com,#first.user@domain.com,#First,, User" />

          <Version Comment="User, Second (Approve) 10/28/2016 3:13 PM - 10/28/2016 3:13 PM&#xA;(User, Second ) One more text comment" Modified="2016-10-28T12:13:59Z" Editor="2;#User,, Second ,#i:0#.w|domain\second,#Second.user@domain.com,#Second.user@domain.com,#User,, Second" />

          </Versions>

      </GetVersionCollectionResult>

    </GetVersionCollectionResponse>

  </soap:Body>

</soap:Envelope>

 

I’m trying to transform this data using XSL or XPath transform in to the table like below and insert it to the task notification:

table example

I used the link to Vadim Tabakman site (http://www.vadimtabakman.com/nintex-workflow-xsl-transformation.aspx) and tried to do as he describes, but without success.

 

Could you please help or advice me  if it possible, with XSL transform.

Outcomes