Hi,
I need specs for the below JSON transformation using JOLT (https://jolt-demo.appspot.com/).
It would be grateful if someone could help on the same.
Input JSON:
[
{
"Name": "Construction",
"ID": "2",
"Canonical Definition": "Chemicals used for removal of the sticky & other bonding materials from the surface where adhesives are used.",
"MIs": "Wax Remover, Sample, Test 1",
"DNIs": "Graffiti Remover",
"Children": "11",
"Primary Path": "2",
"Allpath": "2;3,30"
},
{
"Name": "Paints & Supplies",
"ID": "11",
"Canonical Definition": "Cleaners used to remove oil, tar, grease & other petroleum based stains from concrete and brick Surfaces",
"MIs": "Degreaser",
"DNIs": "Stain Removers, Test 2, Test 3",
"Children": "101,102,103",
"Primary Path": "2,11",
"Allpath": "2,11;4,400"
},
{
"Name": "Chemicals & Cleaners",
"ID": "101",
"Canonical Definition": "Chemicals used to prepare the surface by restoring wood's natural color and beauty",
"MIs": "Patio Cleaner; Wood Cleaner",
"DNIs": "Roof Cleaner",
"Children": "1001,1002,1003,1004,1005",
"Primary Path": "2,11,101",
"All Path": "2,11,101"
}
]
Expected Output JSON:
[
{
"Name": "Construction",
"ID": 2,
"Canonical Definition": "Chemicals used for removal of the sticky & other bonding materials from the surface where adhesives are used.",
"MIs": "Wax Remover, Sample, Test 1",
"DNIs": "Graffiti Remover",
"Children": [11],
"Primary Path": [2],
"Allpath":[
{"path":[2]},
{"path":[3,30]}]
},
{
"Name": "Paints & Supplies",
"ID": 11,
"Canonical Definition": "Cleaners used to remove oil, tar, grease & other petroleum based stains from concrete and brick Surfaces",
"MIs": "Degreaser",
"DNIs": "Stain Removers, Test 2, Test 3",
"Children": [101,102,103],
"Primary Path": [2,11],
"Allpath":[
{"path":[2,11]},
{"path":[4,400]}]
},
{
"Name": "Chemicals & Cleaners",
"ID": 101,
"Canonical Definition": "Chemicals used to prepare the surface by restoring wood's natural color and beauty",
"MIs": "Patio Cleaner; Wood Cleaner",
"DNIs": "Roof Cleaner",
"Children": [1001,1002,1003,1004,1005],
"Primary Path": [2,11,101],
"Allpath":[
{"path":[2,11,101]}]
}
]
Thanks in advance.
