January 2015 – connectedcircuits

This blog is a just a lesson on how to use XSLT to append many rows into one output node using a map with a XSLT Scripting Functiod.

The source message looked something like the one below, where the Line nodes are the repeated rows that are required to be append to one string value.

<SitaBDS xmlns=”http://ECL.Online.BT.JobBooking.SITAAirNZBDS_FF”>
<BagageClaim xmlns=””>
<DS>
<Lines>
<Field>This is the first line.</Field>
</Lines>
<Lines>
<Field>This is the second line.</Field>
</Lines>
<Lines>
<Field>This is the third line.</Field>
</Lines>
</DS>
</BagageClaim>
</SitaBDS>

The final output should look like this:

<ns0:Root xmlns:ns0=”http://FFSchema.Schema1″><Field>This is the first line. This is the second line. This is the third line. </Field></ns0:Root>

Below are the steps I normally follow to work out the syntax of the XSL to be placed inside an Inline XSLT Scripting Functiod.

1. Create a BizTalk map for the source and destination schemas and add a link between the root nodes as shown below.

I initially use this this technique of linking the root elements together to obtain the correct namespaces and a template XSL code to start from.

2. Click on Validate the map to get Visual Studio to generate the XSLT mapping file. This will create the hyperlinks to the generated file as shown.

3. Clicking on the link to the output file of the XSLT will open the file in Visual Studio. Right click on the page and select View Source and take a copy of the code.

4. In Visual Studio add a new XSLT file to your project and replace the sample XSL with the generated XSL from the above step. It should look something like the code below. This method of pasting the generated XSL code provides the required namespaces and aliases to use.

<?xml version="1.0" encoding="utf-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var"
                exclude-result-prefixes="msxsl var s0" version="1.0"
                xmlns:ns0="http://FFSchema.Schema1"
                xmlns:s0="http://FFSchema.FlatFileSchema1">
  <xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
  <xsl:template match="/">
    <xsl:apply-templates select="/s0:SitaBDS" />
  </xsl:template>
  <xsl:template match="/s0:SitaBDS">
    <ns0:Root>
      <xsl:value-of select="./text()" />
    </ns0:Root>
  </xsl:template>
</xsl:stylesheet>

5. Now we need to modify the XSL between the <ns0:Root> tags to concatenate the field values from the source message. This is the point where I start to construct the XSL syntax. To append the field values the following XSL was added between the root elements.

<?xml version="1.0" encoding="utf-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var s0" version="1.0"
                xmlns:ns0="http://FFSchema.Schema1"
                xmlns:s0="http://ECL.Online.BT.JobBooking.SITAAirNZBDS_FF">
  <xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
  <xsl:template match="/">
    <xsl:apply-templates select="/s0:SitaBDS" />
  </xsl:template>
  <xsl:template match="/s0:SitaBDS">
    <ns0:Root>

      <!-- variable to hold appended values-->
      <xsl:variable name="AppendedValue">
        <!-- iterate through each line-->
        <xsl:for-each select="BagageClaim/DS/Lines/Field">
          <xsl:value-of select="./text()" />
          <!-- add space -->
          <xsl:value-of select="' '" />
        </xsl:for-each>
      </xsl:variable>

      <!-- output the concatenated value -->
      <xsl:element name="Field">
        <xsl:value-of select="$AppendedValue"/>
      </xsl:element>
    </ns0:Root>
  </xsl:template>
</xsl:stylesheet>

6. You should be able to test the XSL syntax by setting the XML Document properties to a sample XML file. Right click anywhere on the XSLT file and select Properties on the context menu. Set the Input property to a valid sample XML source file. Once you have done that press the keys (Ctrl + Alt + F5) to start the transformation without debugging.

This should produce the following output.

<ns0:Root xmlns:ns0=”http://FFSchema.Schema1″><Field>This is the first line. This is the second line. This is the third line. </Field></ns0:Root>

7. Once we have tested the XSL code, we can now add that to our map using the Inline XSLT Functiod.

Remember when using XSL to populate a element, you are responsible for creating the destination node and all child nodes in your XSL. The final map looks like below:

Now testing the map with a real sample source message produces the following output.

Enjoy.

Here is a solution I use to concatenate several XML elements in BRE without having to use static .Net classes. I used this method to avoid having to assert an instance of a .Net class. More in formation about about asserting .Net classes can be found here: http://msdn.microsoft.com/en-us/library/aa950269.aspx

This method simply embeds the XSLT CONCAT string function in the XPATH query. For example to concatenate 2 elements the following code would be used: concat(xpath to element 1, xpath to element 2).

In the sample message below, I am required to append the CorrelationID and JobNo values together and return the concatenated value as a vocabulary in BRE.

The XPATH statement to concatenate the two elements is shown below:

concat(/*[local-name()=’FaultEnvelope’]/*[local-name()=’CustomException’]/*[local-name()=’CorrelationID’],/*[local-name()=’FaultEnvelope’]/*[local-name()=’CustomException’]/*[local-name()=’JobNo’])

This produces the following output. However the only issue now is I require a space between the two values.

A space can be added by appending another concat statement in the xpath as shown.

Now that the XPATH statement is correctly structured, it can be added to the XPath field in Vocabulary Definition Wizard. Note the XPath selector field is required to be set to the root path “/”

In the past I have also used other XPATH functions inside the XPath field with great success.

Enjoy.

Month: January 2015

Using XSLT to map from many-to-one

Like this:

Concatenating XML elements in BRE without using .Net classes

Like this:

Share this:

Like this:

Share this:

Like this: