Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Merge two messages — Cloud Customer Connect
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

Merge two messages

Accepted answer
18
Views
8
Comments
edited Jan 12, 2021 10:44PM in Integration 8 comments

Summary

Merge two messages in to single by comparing

Content

Hi All,
 
We have a requirement to merge two API responses in to a single message and this step in OIC integration is causing the performace issue. Reaching out to you seek inputs. 
Here is the scenario.
 
API response 1 (OPA response) has multiple records with below sample fields
OEC Id
Siebel Id
 
API response 2 (Custom App) has multiple records with below sample fields
Amount
Siebel Id
TerminYears
 
The requirement is to have a final output from integration that looks like below
Amount
Siebel Id
TerminYears
OEC Id (to get this from Response 1, we have Siebel Id which is common in both messages and using this get the OEC Id and merge with final message)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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