DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Xquery with Name value pairs

3b8d3e8c-86d8-4791-80d5-fd112743a996Dec 14 2015 — edited Feb 29 2016

Hi,

I am having difficulty in mapping as below in OSB xquery. My target system is sending the xml as below

target xml:

<OutputParameters

xmlns="http://xmlns.oracle.com/pcbpel/adapter/db/sp/GetStatus" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Row>

<Column group_name="varchar" id="status_message">Does not meets the guidelines</Column>

</Row>

<Row>

<Column group_name="varchar" id="status_message">Application Received</Column>

</Row>

<Row>

<Column group_name="varchar" id="status_message">Complete</Column>

</Row>

</RowSet>

</OutputParameters>

I need to convert this to below format using xquery in OSB. Need to group by groupname and then map StatusMsg. Name value pairs is making the mapping difficult. Any help?

Source xml:

<ns1:Status>

<ns1:groupList>

<ns1:GroupName>APP</ns1:GroupName>

<ns1:statusList>

<ns1:StatusMsg>Application Received</ns1:StatusMsg>

</ns1:statusList>

<ns1:statusList>

<ns1:StatusMsg>Complete</ns1:StatusMsg>

</ns1:statusList>

</ns1:groupList>

<ns1:groupList>

<ns1:GroupName>PSS</ns1:GroupName>

<ns1:statusList>

<ns1:StatusMsg>Does not meets the guidelines</ns1:StatusMsg>

</ns1:statusList>

</ns1:groupList>

</ns1:Status>

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2016

Added on Dec 14 2015

#xml, #xquery

1 comment

2,167 views