Pretpark
11 months agoNew Contributor II
Remove XML duplicate key from JSON list in XML formatter
Hello,
As you can see from the title, i am trying to remove a duplicate key in XML which is created by the XML formatter.
The JSON generator contains JSON something along the lines of this:
What i get when i run this through the XML formatter is this:
But what i would like to see is this:
I have tried every possible solution i could find (XML generator, unique snap, deduplicate snap, etc)
What i've also tried is making a Python script which converts the JSON to XML. This worked, but i could not make it work in SnapLogic's Script snap.
This is the python code:
Maybe i am overthinking it? Is it possible to use for example a Mapper snap or the XML generator to solve this issue?
Any help is appreciated.
Thanks in advance.
-Tim