AnsweredAssumed Answered

How to Map JSON to JSON with transformation/grouping?

Question asked by hectorical on Aug 16, 2017
Latest reply on Aug 21, 2017 by Adam Arrowsmith

Hi All,

 

I'm evaluating Boomi at the moment and would appreciate some help from the knowledgeable.

 

I'd like to map from one json Order format to another. However it's not just a straight mapping that's required. There needs to be some transformation/grouping in between.
The source format includes an array element for each size, whereas the target requires that these are grouped together.

 

Source

...

...

"items":[

   {
      "name": "Origine II Black",

      "sizes":[
      {
         "size":"35",
         "quantity":2
      },
      {
         "size":"36",
         "quantity":5
      },

   }

]

...

...

 

Target

 

"items":[
   {
      "name": "Origine II Black",
      "delivery_date":"2016-08-01",
      "sizes": "2 x 35
                     5 x 36"
   }
]

 

I have attached a file that provides a simplified example showing the source format and the required target format.

If anyone could help me out, or at least point me in the right direction i would be greatly appreciated.

Attachments

Outcomes