Forum Discussion

rpatrick00's avatar
rpatrick00
Contributor
5 years ago
Solved

Mapping fields from objects in an array to fields in objects in an array

So I have an input schema that has a structure similar to the one shown here: { "MatchUpdatePartyPayload:" { "Address": [ { "NonStandardUS": { ...
  • aditya_gupta41's avatar
    aditya_gupta41
    2 years ago

    Solution:

    I first used group by snap to group userID fields. Next I put a mapper and added a custom encrypted value with expression

    'XXXX'+sl.range(4).map(x => "0123456&#X"[Math.round(Math.random()*9)]).join('')

     Then I added a JSON splitter to split the group and included value of custom encryption.

skatpally's avatar
skatpally
Former Employee
5 years ago
Copy LinkReport

You just need to JOIN them back on the Unique ID

  • rpatrick00's avatar
    rpatrick00
    Contributor
    5 years ago
    Copy LinkReport

    @skatpally, A couple of problems:

    1. Group By Field works but I end up with extra stuff inside each element of the array, which will not work for me. The problem is that in order for Group By Field to work, I need to somehow pass the unique ID field value to use for grouping through the Mapper that is working on the individual array elements. If I explicitly map that field in the Mapper, the output from Group By Field has the unique ID field inside each array element. If I do not map the field and use Pass Through, I end up with all of the pass through fields inside each array element. If I do neither, Group By Field errors out because the payload does not have access to the unique ID field. There probably needs to be a “Remove Group By Field from elements” option in the Group By Field snap.

    2. The Join snap does not work because not all messages have all 5 elements that are being joined by unique ID so the snap errors out if I use any of the join types other than Merge. Merge doesn’t do what I need since the reassembled messages have pieces from various messages combined into a single message. I figured Null Safe Access might be the solution but the Join snap still fails to do the join.

    What am I missing?

    Mapping Conundrum_2020_09_30.slp (48.1 KB)