SOA 11g - Delimited String to XML

In this post I will explain you how to convert delimited string to XML fragment/format by using “oraext:create-nodeset-from-delimited-string()” function in SOA 11g.

Input Delimited string

E.g.  Vivek,25,Mumbai

In response we should get below xml

<processResponse>

<Name>vivek</Name>

<Age>25</Age>

<Address>Mumbai</Address>

</processResponse>

We need to use one intermediate schema to accomplish this task, so first we will convert delimited string to intermediate schema format and then to final xml format.

To start with this, we need to create a simple composite application.

-          Create a composite and add one Sync BPEL process in it. Use below schema for BPEL

<?xml version="1.0" encoding="UTF-8"?>

<schema attributeFormDefault="unqualified" elementFormDefault="qualified"      targetNamespace="http://xmlns.oracle.com/TestApplication/DelimitedStringToXml/DelimitedStringToXml"

        xmlns="http://www.w3.org/2001/XMLSchema">

 <element name="process">

  <complexType>

   <sequence>

    <element name="input" type="string"/>

   </sequence>

  </complexType>

 </element>

 <element name="processResponse">

  <complexType>

   <sequence>

    <element name="Name" type="string"/>

    <element name="Age" type="string"/>

    <element name="Address" type="string"/>

   </sequence>

  </complexType>

 </element>

</schema>

-          Create one intermediate schema

<?xml version="1.0" encoding="windows-1252" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"

            xmlns="http://www.example.org"

            targetNamespace="http://www.example.org"

            elementFormDefault="qualified">

  <xsd:element name="Customer">

    <xsd:complexType>

    <xsd:sequence>

    <xsd:element name="CustomerInfo" type="xsd:string" minOccurs="0" maxOccurs="unbounded"/>

    </xsd:sequence>

    </xsd:complexType>

  </xsd:element>

</xsd:schema>

-          Now we will convert delimited string to intermediate xml format.  To do this we will use one function “oraext:create-nodeset-from-delimited-string” in assign activity and the operation will be CopyList not Copy.

<assign name="StringToIntermedaiteXMl">

      <bpelx:copyList>

        <bpelx:from expression="oraext:create-nodeset-from-delimited-string('{http://www.example.org}CustomerInfo',bpws:getVariableData('inputVariable','payload','/client:process/client:input'),',')"/>

        <bpelx:to variable="CustomerInfo"

                  query="/ns1:Customer/ns1:CustomerInfo"/>

      </bpelx:copyList>

    </assign>

-          Now we need to transform intermediate xml format to actual xml format. To do this add one transform.

<assign name="Transform_FinalResult">

      <bpelx:annotation>

        <bpelx:pattern>transformation</bpelx:pattern>

      </bpelx:annotation>

      <copy>

        <from expression="ora:doXSLTransformForDoc('xsl/Transformation_Output.xsl', $CustomerInfo)"/>

        <to variable="outputVariable" part="payload"/>

      </copy>

    </assign>

-          In transform just do the required mapping

                            <xsl:template match="/">

    <client:processResponse>

      <client:Name>

        <xsl:value-of select="/ns0:Customer/ns0:CustomerInfo[1]"/>

      </client:Name>

      <client:Age>

        <xsl:value-of select="/ns0:Customer/ns0:CustomerInfo[2]"/>

      </client:Age>

      <client:Address>

        <xsl:value-of select="/ns0:Customer/ns0:CustomerInfo[3]"/>

      </client:Address>

    </client:processResponse>

    </xsl:template>.

-          Complete Bpel flow

-          Now we are ready to test our bpel peocess. Go to em console and test your bpel process.

You can download code from here

Tweet