โ06-13-2023 03:57 AM
Hello Snaplogic experts,
is it possible from input
[
{
"Manufacturer":
"BMW"
"type":
"M3"
"Fuel":
"petrol"
}
{
"Manufacturer":
"BMW"
"type":
"M5"
"Fuel":
"petrol"
}
{
"Manufacturer":
"Mercedel"
"type":
"GLS"
"Fuel":
"diesel"
}
]
create output like this:
[
{
"Manufacturer": BMW
"Infos":
[
{
"type":"M3"
"Fuel":"petrol"
}
{
"type":"M5"
"Fuel":"petrol"
}
]
}
{
"Manufacturer": Mercedes
"Infos":
[
{
"type":"GLS"
"Fuel":"diesel"
}
]
}
]
ive tried with group by fields and withou success โฆ iam curious if it is possible to add โInfosโ into output, if it wasnt mentioned in input
thank you
Solved! Go to Solution.
โ06-13-2023 04:12 AM
Hello,
You can achieve this by using a Mapper Snap with the following settings:
Try it, and let me know if this helps.
BR,
Aleksandar.
โ06-13-2023 04:12 AM
Hello,
You can achieve this by using a Mapper Snap with the following settings:
Try it, and let me know if this helps.
BR,
Aleksandar.
โ06-13-2023 04:45 AM
Yes sir, it works as i wish โฆ ๐
โ06-14-2023 02:17 AM
My output looks like this: every โInfosโ has its own manufacturer object. Is it possible to group/map it somehow
so there will be one Manufacturer field for x objects? in this case only one manufacturer for X3 and X5 type
[
{
"Manufacturer": BMW
"Infos":
[
{
"type":"M3"
"Fuel":"petrol"
}
]
"Manufacturer": BMW
"Infos":
[
{
"type":"M5"
"Fuel":"petrol"
}
]
}
{
"Manufacturer": Mercedes
"Infos":
[
{
"type":"GLS"
"Fuel":"diesel"
}
]
}
]
i would like to group it into/with Manufacturer so i will have only one Manufacturer for x types
[
{
"Manufacturer": BMW
"Infos":
[
{
"type":"M3"
"Fuel":"petrol"
}
{
"type":"M5"
"Fuel":"petrol"
}
]
}
{
"Manufacturer": Mercedes
"Infos":
[
{
"type":"GLS"
"Fuel":"diesel"
}
]
}
]
do i need group by field or structure snap ?
thank you
โ06-14-2023 02:21 AM
Hi, can you please provide me the exact valid JSON?