Just try on the data you had earlier.
Sure, will keep you posted after trying that solution. Thank you.
Hi @SL12345,
Just use a JSON Splitter and split on $CarDetails array, but make sure you have enabled “Include scalar parents” option in the JSON Splitter.
Result:
thank you, that is really what i wanted 🙂 and is it possible to wrap this content into object so from this:
{
"CompanyName": "TestCompany",
"CompanyAddress": "TestAddress",
"Brand": "BMW",
"Year": "2020",
"Fuel": "Petrol"
}
,
{
"CompanyName": "TestCompany",
"CompanyAddress": "TestAddress",
"Brand": "Jaguar",
"Year": "2020",
"Fuel": "Diesel"
}
create this? Adding “Cars” as header or envelope for body/content?
{
"Cars":
{
"CompanyName": "TestCompany",
"CompanyAddress": "TestAddress",
"Brand": "BMW",
"Year": "2020",
"Fuel": "Petrol"
}
,
{
"CompanyName": "TestCompany",
"CompanyAddress": "TestAddress",
"Brand": "Jaguar",
"Year": "2020",
"Fuel": "Diesel"
}
}
Hi @SL12345 ,
Have you tried putting a groupByN snap behind it and as target field $Cars.
Regards
Jens
