cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Sriprasadsbhat
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.