Created on 03-09-2021 02:01 AM - edited 03-09-2021 02:30 AM
Can anyone please help me a JOLT spec to convert my matrix type json to denormalized json. Please find the below my input json and my expected josn output.
Input Json:
[
{
"attributes": [
{
"name": "brand",
"value": "Patriot Lighting"
},
{
"name": "color",
"value": "Chrome"
},
{
"name": "price",
"value": "49.97 USD"
}
]
},
{
"attributes": [
{
"name": "brand",
"value": "Masterforce"
},
{
"name": "color",
"value": "Green"
},
{
"name": "price",
"value": "99.0 USD"
}
]
}
]
Expected Json output:
[
{
"brand": "Patriot Lighting",
"color": "Chrome",
"price": "49.97 USD"
},
{
"brand": "Masterforce",
"color": "Green",
"price": "99.0 USD"
}
]
I was trying to build JOLT spec to convert this json. But challenge is the json which I have multiple tables with "attributes" tag.
Thanks in advance!
Created 03-09-2021 02:28 AM
[
{
"operation": "shift",
"spec": {
"*": {
"attributes": {
"*": {
"@(0,value)": "attributes[#4].@(0,name)"
}
}
}
}
}
]
Created 03-09-2021 02:28 AM
[
{
"operation": "shift",
"spec": {
"*": {
"attributes": {
"*": {
"@(0,value)": "attributes[#4].@(0,name)"
}
}
}
}
}
]
Created on 03-09-2021 03:13 AM - edited 03-09-2021 03:14 AM
@NIFIJOLT This is working as I expected. Thank you so much!!!