Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 25, 2017 at 06:11 AM

    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

    Add comment
    10|10000 characters needed 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.