Mule 4 DataWeave 2.0中使用max()时的空值检查处理方案

我使用DataWeave的max()函数从给定Payload中获取最新的endDate，正常场景下运行正常，但当endDate为空字符串或者字段本身不存在时，函数会报错。需要在计算最大endDate值前进行空值检查，确保在没有有效endDate时返回null。

正常输入Payload #

{
    "cid": "567",
    "payload": {
        "id": "34567",
        "employee": {
            "employType": "PartTime",
            "positions": [
                {
                    "role": "Mulesoft Developer",
                    "startDate": "2023-06-09",
                    "endDate": "2024-02-22"
                },
                {
                    "role": "Senior Mulesoft Developer",
                    "startDate": "2024-02-23",
                    "endDate": "2024-09-30"
                }
            ],
            "Clevel": "987654"
        }
    }
}

当前使用的DataWeave代码 #

%dw 2.0
output application/json

var latestEndDate = max(payload.payload.employee.positions.endDate)

---
latestEndDate

异常场景与预期输出 #

含空endDate的输入Payload #

{
    "cid": "567",
    "payload": {
        "id": "34567",
        "employee": {
            "employType": "PartTime",
            "positions": [
                {
                    "role": "Mulesoft Developer",
                    "startDate": "2023-06-09",
                    "endDate": ""
                },
                {
                    "role": "Senior Mulesoft Developer",
                    "startDate": "2024-02-23",
                    "endDate": ""
                }
            ],
            "Clevel": "987654"
        }
    }
}

预期输出：null

无endDate字段的输入Payload #

{
    "cid": "567",
    "payload": {
        "id": "34567",
        "employee": {
            "employType": "PartTime",
            "positions": [
                {
                    "role": "Mulesoft Developer",
                    "startDate": "2023-06-09"
                },
                {
                    "role": "Senior Mulesoft Developer",
                    "startDate": "2024-02-23"
                }
            ],
            "Clevel": "987654"
        }
    }
}

预期输出：null

解决方案代码 #

%dw 2.0
output application/json
import * from dw::core::Arrays
import * from dw::core::Strings

// 筛选出所有存在且非空的endDate
var validEndDates = payload.payload.employee.positions 
    filter ((pos) -> pos.endDate != null && !isEmpty(pos.endDate)) 
    map ((pos) -> pos.endDate)

// 有有效日期则取最大值，否则返回null
var latestEndDate = if (sizeOf(validEndDates) > 0) max(validEndDates) else null
---
latestEndDate

代码说明 #

• 过滤有效日期：通过filter操作剔除endDate为null或空字符串的项，只保留有效的日期值；再用map提取这些有效日期组成数组。
• 条件判断返回结果：检查有效日期数组的长度，若有数据则调用max()计算最大值，无数据时直接返回null，完全匹配预期需求。

内容的提问来源于stack exchange，提问作者Sunny85