Forum Discussion

cronima's avatar
cronima
New Contributor
2 years ago

Find & Replace using a SOAP Execute to a Mapping Table in Workday

Fairly new SnapLogic user here. I am building a pipeline connecting an ERP system to Workday. I am using the HTTP Client Snap to pull in data from the ERP system. In this call I get a field "account":

When 'account' matches "wd:External_Code" from my Workday SOAP Execute Snap, I need to replace "account" with the value from "Revenue_Category_ID". So in these screenshots, I would need to replace '101-111224' with "RC10638" as seen in the screenshot below. I am having a hard time getting this to work in the Mapper Snap.

In the expression builder, I cannot figure out a way to tell it when 'account' equals "wd:External_Code" and "@wd:type" contains "Revenue_Category_ID", replace with the associated "$".

Anyone know of a way to make this work?

 

2 Replies

  • Abhishek_Soni37's avatar
    Abhishek_Soni37
    Contributor
    2 years ago

    Is it poosible for you to aatch some sample messages from both workday and ERP system?

    • cronima's avatar
      cronima
      New Contributor
      2 years ago

      I was able to resolve this using a splitter, mapper, filter, splitter, mapper, group by fields, mapper. Thanks though. Still working on getting this to write with a SOAP execute.