Skip to Content
0

Extract personIdExternal from EC and use result for query for request-reply

Sep 25, 2017 at 05:45 AM

16

avatar image
Former Member

Hi,

I have a requirement where I need to extract all personIdExternal. I have done this by calling SF using SF adapter and used perPerson entity and selecting only personIdExternal. After this, I need to use the list of personIdExternal to query LMS SF. How can I use the personIdExternal that were extracted on first step into the query for my 2nd channel? I think I saw one post here that says to split them then use the split payload, then merge them again.

Thanks.

Edit: I found the link:

https://answers.sap.com/questions/278836/hci-synchronous-split.html

Can this work in my requirement? Also, how can I use the poid that I added thru content modifier in my channel?

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

1 Answer

Sriprasad Shivaram Bhat
Sep 25, 2017 at 06:11 AM
0

Hello Raye,

You can do it in multiple ways based on your requirement.

1) Follow the post which you have mentioned if incoming data is JSON .

2) You can use Content Enricher if output of LMS call is XML which is more simpler.You can provide the key element from Source message as personIdExternal and target as userId ( not sure about the exact field which matches to personIdExternal from LMS perspective) .

Regards,

Sriprasad Shivaram Bhat

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Sriprasad,

If I use option 2. How can I use personIdExternal from my payload in request-reply.

Would it be like this:

Sender -> SF (get all personIdExternal) -> content Enricher -> LMS.

If so, what would my query look like in the channel between content enricher and LMS?

should I use {body.personIdExternal}?

Thanks.

0