{
"uId" : null,
"data" : [
{
"id" : 2,
"version" : 16,
"code" : "234500001",
"currency" : {
"code" : "TL",
},
"detail" : "XXX,YYY",
"matGroup" : {
"id" : 676,
"name" : "YYY",
"otherName" : "YYY"
},
"matNsnCode" : null,
"matType" : {
"id" : 2,
"name" : "ZZZ",
"otherName" : "ZZZ"
},
"name" : "YYY / AAA",
"prodUnit" : {
"id" : 4,
"otherName" : "BBB"
},
"matCategory" : "CCC",
"materialCodeName" : "234500001 YYY",
"materialUnit" : "BBB"
}
],
"total" : 11940
}
This example converts nested data to a flat structure and assigns new field names. The first shift operation restructures the data, the second default operation fills missing fields with default values.
[
{
"operation": "shift",
"spec": {
"data": {
"*": {
"id": "data[#2].mat_id",
"code": "data[#2].mat_code",
"currency": {
"code": "data[#3].mat_currency"
},
"detail": "data[#2].detail",
"matGroup": {
"id": "data[#3].matGroup_id",
"name": "data[#3].matGroup_name"
},
"matNsnCode": "data[#2].matNsnCode",
"matType": {
"id": "data[#3].matType_id",
"name": "data[#3].matType_name"
},
"prodUnit": {
"otherName": "data[#3].prodUnit_otherName"
},
"matCategory": "data[#2].matCategory",
"materialCodeName": "data[#2].mat_codeName",
"materialUnit": "data[#2].matUnit",
"contactInfo": {
"email": "data[#3].source"
}
}
}
}
},
{
"operation": "default",
"spec": {
"data[]": {
"*": {
"mat_id": null,
"mat_code": null,
"mat_currency": null,
"detail": null,
"matGroup_id": null,
"matGroup_name": null,
"matNsnCode": null,
"matType_id": null,
"matType_name": null,
"prodUnit_otherName": null,
"matCategory": null,
"mat_codeName": null,
"matUnit": null,
"source": "SEM"
}
}
}
}
]
{
"data" : [
{
"mat_id" : 2,
"mat_code" : "234500001",
"mat_currency" : "TL",
"detail" : "XXX,YYY",
"matGroup_id" : 676,
"matGroup_name" : " YYY",
"matNsnCode" : null,
"matType_id" : 2,
"matType_name" : "ZZZ",
"prodUnit_otherName" : "BBB",
"matCategory" : "CCC",
"mat_codeName" : "YYY / AAA",
"matUnit" : "BBB",
"source" : "SEM"
}
]
}