DataWeave未贴图的映射

Question

在为此Salesforce有效载荷编写数据驱动时需要一些帮助。
请帮助为此输入和预期输出创建数据启示。

输入

[
    {
        "Order": {
            "Account_Name__c": "test danish 002",
            "Id": "8018s000004mpqjAAA",
            "type": "Order"
        },
        "UnitPrice": "13.45",
        "Product2": {
            "Id": null,
            "type": "Product2",
            "Name": "* 1 LEG FOR MESAHORNO STAND110"
        },
        "Id": "8028s000000kyUDAAY",
        "type": "OrderItem",
        "OrderItemNumber": "0000051590"
    },
    {
        "Order": {
            "Account_Name__c": "test danish 002",
            "Id": "8018s000004mpqjAAA",
            "type": "Order"
        },
        "UnitPrice": "308.45",
        "Product2": {
            "Id": null,
            "type": "Product2",
            "Name": "* 2 Uprights incl castors f RTWZ 600 Var"
        },
        "Id": "8028s000000kyUEAAY",
        "type": "OrderItem",
        "OrderItemNumber": "0000051591"
    },
    {
        "Order": {
            "Account_Name__c": "test danish 002",
            "Id": "8018s000004mpqjAAA",
            "type": "Order"
        },
        "UnitPrice": "31.0",
        "Product2": {
            "Id": null,
            "type": "Product2",
            "Name": "* 25 Comp Glass Rack - 3 Ext - Red Base"
        },
        "Id": "8028s000000kyUFAAY",
        "type": "OrderItem",
        "OrderItemNumber": "0000051592"
    },
    {
        "Order": {
            "Account_Name__c": "test danish 002",
            "Id": "8018s000004mpqjAAA",
            "type": "Order"
        },
        "UnitPrice": "31.65",
        "Product2": {
            "Id": null,
            "type": "Product2",
            "Name": "* 36 Comp Glass Rack 3 Ext - Gray"
        },
        "Id": "8028s000000kyUGAAY",
        "type": "OrderItem",
        "OrderItemNumber": "0000051593"
    }
]

这是OrderLineItems上的Salesforce查询 输出看起来像
输出

{
    "Id":"8018s000004mpqjAAA",
    "Order Name": "test danish 002",
    "Line Items": [
        {
            "Id":"8028s000000kyUDAAY",
            "ItemNumber":"0000051590",
            "Name":"* 1 LEG FOR MESAHORNO STAND110"
        },
        {
            "Id":"8028s000000kyUEAAY",
            "ItemNumber":"0000051591",
            "Name":"* 2 Uprights incl castors f RTWZ 600 Var"
        },
        {
            "Id":"8028s000000kyUFAAY",
            "ItemNumber":"0000051592",
            "Name":"* 25 Comp Glass Rack - 3 Ext - Red Base"
        },
        {
            "Id":"8028s000000kyUGAAY",
            "ItemNumber":"0000051593",
            "Name":"* 36 Comp Glass Rack 3 Ext - Gray"
        }
    
    ]
}

Answer 1

假设所有订单ID都是相同的，则可以直接从有效载荷中映射ID，然后使用MAP on 有效载荷获取行项目

%dw 2.0
output application/json
---
{
  Id: payload[0].Order.Id,
  "Order Name": payload[0].Order.Account_Name__c,
  "Line Items": payload map {
     Id: $.Id,
     ItemNumber: $.OrderItemNumber,
     Name: $.Product2.Name
   }
}

Answer 2

这样尝试：

%dw 2.0
output application/json
---
{
"Id" : payload[0].Order.Id,
"Order Name": payload[0].Order.Account_Name__c,
"Line Items" : payload map{ 
    Id: $.Id,
    ItemNumber : $.OrderItemNumber,
    "Line Items" : $.Product2.Name
}
}

Answer 3

这是您在订购ID时可以尝试的另一种选择，

%dw 2.0
output application/json
---
payload groupBy ((item, index) -> item.Order.Id) 
    mapObject ((value, key, index) ->  
            {"Id": value.Order.Id[0], 
            "Order Name": value.Order.Account_Name__c[0],
            "Line Items": value map ({
                                Id: $.Id, 
                                ItemNumber: $.OrderItemNumber,
                                Name: $.Product2.Name
 
                            })}
)