Need Jolt Spec to convert matrix json to denormalized json formart

KarthiAsokan — Tue, 09 Mar 2021 10:30:55 GMT

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.

@Json @NIFIJOLT

Thanks in advance!

Re: Need Jolt Spec to convert matrix json to denormalized json formart

NIFIJOLT — Tue, 09 Mar 2021 10:28:02 GMT

[
{
"operation": "shift",
"spec": {
"*": {
"attributes": {
"*": {
"@(0,value)": "attributes[#4].@(0,name)"
}
}
}
}
}
]

Re: Need Jolt Spec to convert matrix json to denormalized json formart

KarthiAsokan — Tue, 09 Mar 2021 11:14:18 GMT

@NIFIJOLT This is working as I expected. Thank you so much!!!

question Re: Need Jolt Spec to convert matrix json to denormalized json formart in Support Questions

Need Jolt Spec to convert matrix json to denormalized json formart

Re: Need Jolt Spec to convert matrix json to denormalized json formart

Re: Need Jolt Spec to convert matrix json to denormalized json formart