Skip to Content
0

HCI: Concatenate multiple SF tables

Jul 12, 2017 at 04:36 AM

141

avatar image

Hi experts,

I am doing a scenario where SF is the sender. We are extracting information from SF using oData. We have to pull data from SF with multiple tables. Since the SF adapter can only pull from one tabe/entitySet per each adapter, how can I do this if I need to pull data from 3 tables? I have read regarding request-reply, is this what I need for this requirement?

Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Sriprasad Shivaram Bhat Jul 12, 2017 at 06:31 AM
1

Hello Raye,

Please find the below details.

You can query from first entity and then later on enrich it with other entities using combine option [ If all the 3 entity calls are independent of each other ]

You can right click on Request Reply and then switch it Content Enricher [ With Aggregation Algorithm Combine ].Output after last content enricher would be combined output from all the 3 entities query [You can use Message Mapping and transform it ].

Regards,

Sriprasad Shivaram Bhat


Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Sriprasad,

Thank you for your answer. I will try this on my end and will reply back. Also, do you know if it is possible to see the message per process step?

Regards.

0

Hello Raye,

Below blog will give more about seeing payload at every step by enabling trace.

https://blogs.sap.com/2016/11/03/hcp-is-hci-enabling-integration-flow-trace-capability-do-it-yourself-from-now-on/

Regards,

Sriprasad Shivaram Bhat

0