New to Nifi and looking to see if we can convert results of SQL to JSON in the requested format.
SQL result is :
| member_id | field2 | total | tax | ship | partnum | price | qty |
|---|---|---|---|---|---|---|---|
| 874450963 | 24017 | 173.95 | 0 | 0 | 015935966 | 42 | 1 |
| 874450963 | 24017 | 173.95 | 0 | 0 | 000756009 | 32 | 1 |
| 874450963 | 24017 | 173.95 | 0 | 0 | 012179293 | 99.95 | 1 |
使用100或101进程的开箱即用结果如下所示:
[
{
"FIELD2": "24017",
"MEMBER_ID": "874450963",
"PARTNUM": "015935966",
"PRICE": "42",
"QUANTITY": "1",
"TIMEPLACED": null,
"TOTALPRODUCT": "173.95",
"TOTALSHIPPING": "0",
"TOTALTAX": "0"
},
{
"FIELD2": "24017",
"MEMBER_ID": "874450963",
"PARTNUM": "000756009",
"PRICE": "32",
"QUANTITY": "1",
"TIMEPLACED": null,
"TOTALPRODUCT": "173.95",
"TOTALSHIPPING": "0",
"TOTALTAX": "0"
},
{
"FIELD2": "24017",
"MEMBER_ID": "874450963",
"PARTNUM": "012179293",
"PRICE": "99.95",
"QUANTITY": "1",
"TIMEPLACED": null,
"TOTALPRODUCT": "173.95",
"TOTALSHIPPING": "0",
"TOTALTAX": "0"
}
]
请求是将它们分组，并将partnum、价格和数量作为一个数组，如下所示:
[
{
"FIELD2": "24017",
"MEMBER_ID": "874450963",
"TIMEPLACED": null,
"TOTALPRODUCT": "173.95",
"TOTALSHIPPING": "0",
"TOTALTAX": "0",
"itemDetails": [
{
"PARTNUM": "015935966",
"PRICE": "42",
"QUANTITY": "1"
},
{
"PARTNUM": "000756009",
"PRICE": "32",
"QUANTITY": "1"
},
{
"PARTNUM": "012179293",
"PRICE": "99.95",
"QUANTITY": "1"
}
]
}
]
我们该怎么做呢？
谢谢!
搜索了论坛，没有看到任何类似的东西.