Forum Discussion
rpc1235x - take a look at the JSON Splitter snap. For your example, you will want to enable the "Include scalar parents" option to retain the name, color, and animal attributes.
- j_angelevski4 years agoContributor III
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" } }
- JensDeveloper4 years agoContributor II
Hi @SL12345 ,
Have you tried putting a groupByN snap behind it and as target field $Cars.
Regards
Jens