Merge two messages

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)