cancel
Showing results for 
Search instead for 
Did you mean: 

Remove XML duplicate key from JSON list in XML formatter

Pretpark
New Contributor II

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:

Pretpark_0-1727690410453.png

What i get when i run this through the XML formatter is this:

Pretpark_1-1727690449634.png

But what i would like to see is this:

Pretpark_2-1727690494309.png

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:

Pretpark_3-1727690918455.png

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

1 REPLY 1

Pretpark
New Contributor II

Edit: I dont know (or can't) change the title of the question, so i will post the edit here in the reply.
The title should be changed to: "Remove XML duplicate key from XML formatter output". I think the title causes confusion now.
Sorry