A flow needs to combine and return data from two different data sources. It contains a Database SELECT operation followed by an HTTP Request operation.
What is the method to capture both payloads so the payload from the second request does not overwrite that from the first?
To effectively combine and return data from two different data sources without the payload from the second request overwriting the first, place the Database SELECT operation inside a Message Enricher scope. The Message Enricher allows you to keep the original payload while adding additional data to the message, thus ensuring that both payloads are captured and maintained.
A. Save the payload from the Database SELECT operation to a variable. Always use variable if want to persist value during the request-response process!