Showing posts with label XML with Attribute name. Show all posts
Showing posts with label XML with Attribute name. Show all posts

Thursday, 17 October 2013

Parsing XML element with Attribute names,using XPath in OSB

Parsing XML element with Attribute names,using XPath in OSB ,Say <Element_01 Name="attribute"></Element_01>

<?xml version="1.0" encoding="UTF-8"?>
<?CRM-Property-Set EscapeNames="false"?>
<CRMMessage MessageId="Rhombus_31275" IntObjectFormat="CRM Hierarchical" MessageType="Integration Object" IntObjectName="RCRM Interface Activity External">
<RCRMInterface InterfaceEvent="Insert" SenderSysUID = "Rhombus_Alert_123158" SenderSys = "Rhombus" TransmitTime = "10/03/2013 11:35:19" ReceiverSys="MyCompany CRM" ReceiverSysUID="">

</RCRMInterface>
</CRMMessage>

Solution

· Receive the message in body variable.

·To extract: 123158

Xpath:

  • $body/RCRMInterface/Object/InterfaceActivity/Element_01[@Name="AlertId"]/text()

  • $body/RCRMInterface/Object/InterfaceActivity/Element_01/text()


· To extract Same with tag name: <Element_01 Name="AlertId">123158</Element_01>

Xpath:

  •  $body/RCRMInterface/Object/InterfaceActivity/Element_01