Thursday, 17 October 2013

Using fn-bea:inlinedXML in OSB to parse XML Text

Using  fn-bea:inlinedXML in OSB to parse XML Text

fn-bea:inlinedXML in OSB

Consider a scenario where in you expect an XML String from the target application.

In case you find it challenging to use the Xpath to parse the XML string and retrieve value from a particular node the, Xquery function fn-bea:inlinedXML in OSB may be used to Parses textual XML and returns an instance of the XQuery 1.0 Data Model.In simple terms ,parse from xml string to xml Element that can be processed by the parser.

A working example is shown below, where I receive an XML String from end system $body,which is converted to an XML object,using the fn-bea:inlinedXML.Just make sure that your XML string is valid with proper tags and namespace declaration.



[caption id="attachment_199" align="alignnone" width="620"]image0011 OSB Assign Statement[/caption]






image0022

Once done the Xpath expression can be applied on $MyVar for Parsing the DOM Structure.
Ø $MyVar/RCRMInterface/Object/InterfaceActivity/ActivityID/text()

-Ritz

2 comments:

  1. Learning from you, even after I left the company!

    ReplyDelete
  2. that was always my pleasure... Learn and share.

    ReplyDelete