如何继承每个现有子M子4的父元素4

Question

您需要为每个孩子的sku元素复制一系列父元素。

输入：

{
"items": [
    {
        "order": "ASD51247",
        "reference": "271559410",
        "date": "2022-04-01T22:58:19.077Z",
        "lines": [
            {
                "number": "6578523423489",
                "description": "ITEM 1"
            }
        ],
        "received": "2022-03-31T09:46:13.260Z",
        "created": "2022-03-31T09:46:13.109Z"
    },{
        "order": "AST927353",
        "reference": "271944522",
        "date": "2022-04-01T22:58:19.038Z",
        "lines": [
            {
                "number": "4563252696546",
                "description": "ITEM 2"
            },
            {
                "number": "890456234326",
                "description": "ITEM 3"
            }
        ],
        "received": "2022-03-31T10:25:08.508Z",
        "created": "2022-03-31T10:25:08.353Z"
    }
]}

预期输出：

{ "item":[
  {
     "order":"ASD51247",
     "reference":"271559410",
     "date":"2022-04-01T22:58:19.077Z",
     "number":"6578523423489",
     "description":"ITEM 1",
     "receivedAt":"2022-03-31T09:46:13.260Z",
     "createdAt":"2022-03-31T09:46:13.109Z"
  },
  {
     "order":"AST927353",
     "reference":"271944522",
     "date":"2022-04-01T22:58:19.038Z",
     "number":"4563252696546",
     "description":"ITEM 2",
     "received":"2022-03-31T10:25:08.508Z",
     "created":"2022-03-31T10:25:08.353Z"
  },
  {
     "order":"AST927353",
     "reference":"271944522",
     "date":"2022-04-01T22:58:19.038Z",
     "number":"890456234326",
     "description":"ITEM 3",
     "received":"2022-03-31T10:25:08.508Z",
     "created":"2022-03-31T10:25:08.353Z"
  }]}

在输出中，必须继承“线”数组中每个孩子的父元素。任何帮助将不胜感激。谢谢。

Answer 1

%dw 2.0
output application/json
---
item: payload.items flatMap ((item, index) ->

        (item.lines map {
       order: item.order,
       reference:item.reference,
       date: item.date,
       number: $.number,
       description: $.description,
       received: item.received,
       created:item.created

   })
 
 )

修改Imtiyaz的答案

%dw 2.0
output application/json
---
{
    items: (payload.items ) flatMap ((item, index) ->  (
        item.lines map ((line) -> (item - 'lines' - "received" - "created ") ++ {
            description: line.description,
            number: line.number,
            created: item.created,
            received: item.received
        })
    ))
}

Answer 2

尝试以下脚本。

%dw 2.0
output application/json
---
{
    items: payload.items flatMap ((item, index) -> (
        item.lines map ((line) -> (item - 'lines') ++ {
            description: line.description
        })
    ))
}