如何使用Mule 4删除XML中返回null的属性

Question

我需要删除"空"；使用dataweave 2.0、的XML属性

我尝试了skipNullOn＝"；"无处不在"；并且skipOnNull＝"0"；属性"；只处理元素而不处理属性。

使用skipNullOn时出错：

"Option `skipOnNull` is not valid. Valid options are: `writeDeclaration`, `indent`, `doubleQuoteInDeclaration`, `encoding`, `escapeGT`, `defaultNamespace`, `bufferSize`, `inlineCloseOn`, `onInvalidChar`, `writeNilOnNull`, `escapeCR`, `skipNullOn`, `writeDeclaredNamespaces`, `deferred`

输入XML:

<?xml version="1.0" encoding="UTF-8"?>
<DTOApplication id="Application-1660258480-1493174910" ApplicationNumber="AP-00006354">
<DTOLine id="Line-101746978-972142087" StatusCd="Active" >
<DTOCoverage id="Coverage-1713637162-341585712" CoverageCd="MINP" >
<DTOSteps>
<DTOStep Order="1" Name="Premium" value="8" factor="8"/>
<DTOStep Order="2" Name="Term Factor" value="9" factor="9">
<DTOSteps>
<DTOStep Order="1" Name="Minimum Premium" value="10" factor="10"/>
<DTOStep Order="2" Name="Rated Premium" value="null" factor="null"/>
</DTOSteps>
</DTOStep>
</DTOSteps>
</DTOCoverage>
<DTOCoverage id="Coverage-763105832-915106268" CoverageCd="TRIAL">
<DTOSteps id="Steps-Coverage-763105832-915106268">
<DTOStep Order="1" Name="Premium" value="18" factor="18" />
</DTOSteps>
</DTOCoverage>
</DTOLine>
<DTOCoverage id="Coverage-863105832-915106268" CoverageCd="EBRK" >
<DTOSteps id="Steps-Coverage-863105832-915106268">
<DTOStep Order="1" Name="Base Rate" value="null" factor="null"/>
</DTOSteps>
</DTOCoverage>
</DTOApplication>

预期的XML输出：https://github.com/Manikandan99/Map_request/blob/main/null_removed.xml

关于如何删除属性return，有什么想法吗；空"；使用dataweave 2.0？

Answer 1

尝试以下DW

DW

%dw 2.0
output application/xml
var updateval = (element) ->
element mapObject (value, key) -> {
(key) @(
(
if (key.@?)
(key.@ mapObject ((avalue, akey) -> { 
((akey): avalue) if (avalue != "null")
}))
else {}
)
) :
if (value is Object)
updateval(value)
else value
}
---
updateval(payload)

输出

<?xml version='1.0' encoding='UTF-8'?>
<DTOApplication id="Application-1660258480-1493174910" ApplicationNumber="AP-00006354">
<DTOLine id="Line-101746978-972142087" StatusCd="Active">
<DTOCoverage id="Coverage-1713637162-341585712" CoverageCd="MINP">
<DTOSteps>
<DTOStep Order="1" Name="Premium" value="8" factor="8"/>
<DTOStep Order="2" Name="Term Factor" value="9" factor="9">
<DTOSteps>
<DTOStep Order="1" Name="Minimum Premium" value="10" factor="10"/>
<DTOStep Order="2" Name="Rated Premium"/>
</DTOSteps>
</DTOStep>
</DTOSteps>
</DTOCoverage>
<DTOCoverage id="Coverage-763105832-915106268" CoverageCd="TRIAL">
<DTOSteps id="Steps-Coverage-763105832-915106268">
<DTOStep Order="1" Name="Premium" value="18" factor="18"/>
</DTOSteps>
</DTOCoverage>
</DTOLine>
<DTOCoverage id="Coverage-863105832-915106268" CoverageCd="EBRK">
<DTOSteps id="Steps-Coverage-863105832-915106268">
<DTOStep Order="1" Name="Base Rate"/>
</DTOSteps>
</DTOCoverage>
</DTOApplication>