Json array Parse

CloverDX Platform
1

{“results”:[
{
“images” : [
“https://s3.amazonaws.com/fre.jpg”,
“https://s3.amazonaws.com/f.jpg”,
],
“specname”:[
“Dynamic coefficient of friction”,
“Chemical resistance”,
“Resistance to freeze”,
“Surface abrasion”,
“Stain Resistance”,
“Water absorption”,
“Breaking strength”,
“Scratch hardness”
],
“model”:“Sequoyah”,
specvalue":[
“≥ 0.42*”,
“CLASS A”,
“RESISTANT”,
“IV”,
“CLASS A”,
“≤ 0.5%”,
“≥ 400”,
“≥ 6”
]
} ]}
the above json i have to reformat as :
{
“model”:“Sequoyah”,
“images” : [
“https://s3.amazonaws.com/fre.jpg”,
“https://s3.amazonaws.com/f.jpg”,
],
“productSpecifications” : [
{
“name” : “Dynamic coefficient of friction”,
“value” : “≥ 0.42*”
},
{
“name” : “Chemical resistance”,
“value” : “CLASS A”
},
{
“name” : “Resistance to freeze”,
“value” : “RESISTANT”
},
…
…
]
}
…
i have to do the following task .Components that are required and methods to parse the arrays as required.
PLZ nreply ASAP!!

2

Hi,

for reading JSON files, you might use one of the following components:

  • JSONExtract- this one uses a graphical mapping editor, JSONExtract is also faster than JSONReader, this component is similar to XMLExtract

  • JSONReader- uses a XPATH expressions

In our documentation (click above links), you can find more information about these components and their settings.

Hope this helps.