XML to String and String to XML conversion

Use Cases

  • Many a times, we may need to convert xml data and pass it as a string inside an XML tag.
  • Sometimes from source, we get data which is in string format but actually is xml encoded in string format.
To do so in Oracle BPEL 12c or OSB 12c we can use built in functions.

XML data to String

Sample input

<inRoot>
    <t1>Hello</t1>
    <t2>World</t2>
    <t3>One</t3>
</inRoot>

Sample output

<outRoot>    <t1>&lt;inRoot&gt;&lt;t1&gt;Hello&lt;/t1&gt;&lt;t2&gt;World&lt;/t2&gt;&lt;t3&gt;One&lt;/t3&gt;&lt;/inRoot&gt;</t1>
</outRoot>

XSLT

This can be accomplished by using the function oraext:get-content-as-string(element as node-set). This function is really helpful when we are working on BPEL as we can use this function in ASSIGN activity or in TRANSFORM activity using XSLT.
xmlns:oraext="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"
element as node-set: xml data(can be variable, xpath, or a function that returns xml data)

Example:

<outRoot>
    <t1><xsl:value-of select="oraext:get-content-as-string(/ns0:inRoot)"/></t1>
</outRoot>

XQuery

Xquery too have a function to convert xml to string i.e. fn-bea:serialize($arg as item()*) as xs:string. This function is really helpful when we are dealing with OSB.
xmlns:fn-bea="http://www.bea.com/xquery/xquery-functions"
$arg: Variable containing XML data.

Example:
$input contains xml data that needs to be converted and assigned to one tag in output payload.

<outRoot>
    <t1>{fn-bea:serialize($input)}</t1>
</outRoot>

String to XML

Sample input
String Data:
'&lt;inRoot&gt;&lt;t1&gt;Hello&lt;/t1&gt;&lt;t2&gt;World&lt;/t2&gt;&lt;t3&gt;One&lt;/t3&gt;&lt;/inRoot&gt;'

Sample output
XML Data
<inRoot>
    <t1>Hello</t1>
    <t2>World</t2>
    <t3>One</t3>
</inRoot>

As we can see in above example that < and > are replaced with &lt; and &gt;. In xml < and > are invalid characters and escaper characters are used in place of these.

XSLT
In xslt, we can use built in function oraext:parseXML(stringData).This function is really helpful when we are working on BPEL as we can use this function in ASSIGN activity or in TRANSFORM activity using XSLT.
xmlns:oraext="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"
stringData: string value of xml data.

Example:
<xsl:copy-of select="oraext:parseXML('&lt;inRoot&gt;&lt;t1&gt;Hello&lt;/t1&gt;&lt;t2&gt;World&lt;/t2&gt;&lt;t3&gt;One&lt;/t3&gt;&lt;/inRoot&gt;')"/>

Note: we have used copy-of instead of value-of as we need all the xml nodes to be copied to the target file. If we want to extract the data from xml without xml tags then we can use value-of.

XQuery
In xquery, we can use fn-bea:inlinedXML($arg as xs:string) as node()*. This function is really helpful when we are dealing with OSB.
xmlns:fn-bea="http://www.bea.com/xquery/xquery-functions"
$arg: variable containing xml data in string format.

Example:
fn-bea:inlinedXML('&lt;inRoot&gt;&lt;t1&gt;Hello&lt;/t1&gt;&lt;t2&gt;World&lt;/t2&gt;&lt;t3&gt;One&lt;/t3&gt;&lt;/inRoot&gt;')


-

Comments

  1. sasniran02 February, 2022 15:28

    Excellent article and this helps to enhance your knowledge regarding new things. Waiting for more updates.
    Angular 12 New Features
    Angular Latest Version Features

    ReplyDelete

Post a Comment

Popular posts from this blog

DateTime formatting using xp20:format-dateTime ()

xs:dateTime Format In XML, we generally use xs:dateTime(xs:xmlns="http://www.w3.org/2001/XMLSchema") data type to store date time data. The generic representation of date time, that is supported by xs:dateTime in xml: YYYY-MM-DDThh:mm:ss[.SSS][Z|(+|-)hh:mm] Example :  2019-09-11T10:16:31.943+05:30 Code Description Example YYYY represents a 4-digit year 2019 MM represents a 2-digit month 09 DD represents 2-digit date 11 hh represents 2-digit hours 10 mm represents minutes in 2-digits 16 ss represents seconds in 2-digits 31 SSS represents milliseconds 943 T represents time separator T Z represents UTC time zone or 0 time zone offset (+|-)hh:mm represents time zone offset +5:30 Few more valid examples : 2019-09-11T21:32:52, 2019-09-11T21:32:52+02:
Read more

Create Delimited String from XML Nodes and Vice Versa in SOA 12c

A delimited string is a string representation of data separated by a delimiter(e.g. ","). A simple representation of the delimited string will look like. Delimited String Examples Sample-1-- Delimiter as ","        Value1,Value2,Value3   Sample-2-- Delimiter as "|"        Value1|Value2|Value3 If we want to represent the above set of delimited values in the form of an XML document under some root and parent tag. The representation will look like this. XML Example <root xmlns="http://test.com/sample/xml">   <Values>     <value>Value1</value>     <value>Value2</value>     <value>Value3</value>   </Values> </root> Sometimes we may need to convert values coming in delimited string to an xml document or vice versa. Since delimited string is similar to csv format. We can create
Read more

Import and Export MDS artifacts in SOA 12c

Image
Oracle SOA-MDS (Metadata Store) repository can be used to access artifacts that can be shared among various SOA composites. For example, we have one common schema for a business fault that is consumed by various applications. Instead of having a localized copy of that schema file in each SOA composite, we can have it in a centralized repository (SOA-MDS). Another benefit of using SOA-MDS is that we can change the file at runtime and need not redeploy the complete code. While developing SOA composites, we use SOA design-time repository, later these changes can be synced to the SOA servers. In this article, we will discuss 2 ways to sync the artifacts available in the SOA design-time repository and the SOA servers. Establishing the connection to SOA-MDS in Jdeveloper. Using SOA em console or Fusion Middleware control console. Moving a file between SOA composite to SOA design-time MDS repository Let's assume, we created a businessFault.xsd which wi
Read more