06-08-2021 10:14 AM
I have an input to the XML formatter which looks like this 🙂
{
“@SEGMENT”: “1”,
“code”: “B00001”,
MVodafone 150" BLACK
“test_p”: [
]
}
when this input is passed to XML formatter, it gives output as below:
“code”: “B00001”,
MVodafone 150amp;quot; BLACK
Note** I have edited the output to place it in the forum.
Is there any way, where we can stop xml formatter from replacing the " to " ?
Solved! Go to Solution.
06-10-2021 09:18 AM
Hi @viji28,
As @j.angelevski said data is not valid so I guess that it should look something like this ?
[
{
"@SEGMENT": "1",
"code": "B00001",
"MVodafone": "150" BLACK",
"test_p": []
}
]
So I tried with this sample, and it should solve your problem if you check the Format as canonical XML field, inside of XML Formatter.
What I received on output with the checked filed:
<RootElement SEGMENT="1"><code>B00001</code><MVodafone>150" BLACK</MVodafone></RootElement>
Regards,
06-10-2021 08:32 AM
Hi @viji28,
The provided JSON data is not valid, can you share the correct data ?
06-10-2021 09:18 AM
Hi @viji28,
As @j.angelevski said data is not valid so I guess that it should look something like this ?
[
{
"@SEGMENT": "1",
"code": "B00001",
"MVodafone": "150" BLACK",
"test_p": []
}
]
So I tried with this sample, and it should solve your problem if you check the Format as canonical XML field, inside of XML Formatter.
What I received on output with the checked filed:
<RootElement SEGMENT="1"><code>B00001</code><MVodafone>150" BLACK</MVodafone></RootElement>
Regards,
06-21-2021 09:58 PM
Great. This works. Thank you so much.