在Dataweave 2.0中将属性文件中的属性转换为json

Question

如何从属性文件转换属性

creditmaster.metadata.AverageFicoScore=700
creditmaster.a.b.c=xyz

以通用的方式转换成json格式

{
creditmasterMetaData: [
{
attributeKey: "AverageFicoScore",
attributeValue: 700
}
]
}

Answer 1

这个脚本是通用的，因为它不关心键的部分是什么，它只按第一个元素(第一个点之前)和最后一个点之后的键名分组，它忽略中间的一切:

%dw 2.3
output application/java
import * from dw::core::Strings
fun mapProperties(props) = 
entriesOf(props) // since Mule 4.3 / DW 2.3
filter (substringAfter($.key, ".") startsWith "metadata.") // to filter keys with .metadata.
groupBy ((item, index) -> substringBefore(item.key, ".")) 
mapObject ((value, key, index) ->  
(key): value map {
attributeKey: substringAfterLast($.key, "."),
attributeValue: if (isInteger($.value)) $.value as Number else $.value
}
)
---
mapProperties(payload)

输入文件:

creditmaster.metadata.AverageFicoScore= 700
other.a.b= 123
creditmaster.a.b.c=xyz
something.metadata.another.maximum=456
creditmaster.metadata.different.minimum=500

输出(以JSON格式显示):

{
"something": [
{
"attributeKey": "maximum",
"attributeValue": "456"
}
],
"creditmaster": [
{
"attributeKey": "minimum",
"attributeValue": "500"
},
{
"attributeKey": "AverageFicoScore",
"attributeValue": "700"
}
]
}

Answer 2

另一种选择是使用pluck函数。它允许您遍历接收条目的对象。

如果你有这个输入

{
"creditmaster": {
"metadata": {
"AverageFicoScore": "700",
"OtherData": "Some value"
}
}
}

与这个转换

{
creditmasterMetaData:
payload.creditmaster.metadata pluck ((value, key, index) -> 
{
attributeKey: key,
attributeValue: value
}
)
}

你会得到这个输出

{
"creditmasterMetaData": [
{
"attributeKey": "AverageFicoScore",
"attributeValue": "700"
},
{
"attributeKey": "OtherData",
"attributeValue": "Some value"
}
]
}