You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extract data from two sources and combine based on condition

Received Response
16
Views
2
Comments
edited Jul 27, 2020 8:42AM in Integration 2 comments

Content

Hi Experts,

Getting data from two queries and both have a common field <aid>. Based on the <aid>, wanted to merge the data. See the below. Can we achieve the same in OIC? Please suggest.

Data from 1st query:

<?xml version="1.0" encoding="UTF-8"?>
<data>
   <accounts>
      <aid>123</aid>
      <aname>abc</aname>
      <contact>
         <cid>c124</cid>
         <cname>ankur</cname>
      </contact>
      <contact>
         <cid>c123</cid>
         <cname>amit</cname>
      </contact>
   </accounts>
   <accounts>
      <aid>456</aid>
      <aname>xyz</aname>
      <contact>
         <cid>c099</cid>
         <cname>jain</cname>
      </contact>
      <contact>
         <cid>c107</cid>
         <cname>vasim</cname>
      </contact>
   </accounts>
</data>

 

Data from 2nd query

<?xml version="1.0" encoding="UTF-8"?>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!