I have source data that looks like below, with certain “known” fields with values, and then an array of “custom” data with name/value fields:
knownfield1: value1 knownfield2: value2 knownfield3: value3 customDataSets: customData: name: customname1 value: customvalue1 customData: name: customname2 value: customvalue2 customData: name: customname3 value: customvalue3
I would like to map this data into a common format with all fields/values, like below:
metadata: knownfield1: value1 knownfield2: value2 knownfield3: value3 customname1: customvalue1 customname2: customvalue2 customname3: customvalue3
The known fields are pretty easy to deal with, but this array of separate name/value fields is giving me a hard time, especially with regards to the “target path” in the mapper not being able to be an expression where the name of the output is dynamic, only the value.