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

No comments:

Post a Comment