AnsweredAssumed Answered

How do I flatten a json record?

Question asked by bsande947117 on Jul 23, 2018
Latest reply on Jul 26, 2018 by bsande947117

I have a json document with the structure below and I need to convert the array of field objects into a flattened document with each field name as the property name and the corresponding value. I've tried several things and the mapping implicitly keeps creating a document per field object.  I've seen a question about flattening an array of values to a concatenated string but I don't see how that would apply to what I am trying to accomplish.

 

Any help would be appreciated.  

 

source

Source Profile 

 

destination

destination profile

Outcomes