Skip to Main Content

Parsing XML in Oracle Integration Cloud

User_IPAFBSep 9 2022 — edited Sep 11 2022

Hi
We have subscribed to business event for create customer contact , but the response of the event is only contact point id, we want to extract this value from xml response and then feed to DB adapter to get other information abt contact.
I want help on how to extract Value below response using OIC and then feed to DB adapter i am getting below response message in OIC when business event is raised.
<BusinessEvent_Input xmlns="http://xmlns.oracle.com/apps/wf/businessevents">
<InputParameters>
<ns:BusinessEvent xmlns:ns="http://xmlns.oracle.com/apps/wf/businessevents">
<ns:EventName>oracle.apps.ar.hz.ContactPoint.create</ns:EventName>
<ns:EventKey>oracle.apps.ar.hz.ContactPoint.create9715196</ns:EventKey>
<ns:ParameterList>
<ns:Parameter>
<ns:Name>ERROR_TYPE</ns:Name>
<ns:Value>ERROR</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>USER_ID</ns:Name>
<ns:Value>0</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>CONTACT_POINT_ID</ns:Name>
<ns:Value>50367298</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>SECURITY_GROUP_ID</ns:Name>
<ns:Value>0</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>RESP_APPL_ID</ns:Name>
<ns:Value>660</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>RESP_ID</ns:Name>
<ns:Value>52184</ns:Value>
</ns:Parameter>
</ns:ParameterList>
</ns:BusinessEvent>
</InputParameters>
</BusinessEvent_Input>

Thanks
Sumir

Comments
Post Details
Added on Sep 9 2022
0 comments
42 views