Forum Discussion

viji28's avatar
viji28
New Contributor
5 years ago
Solved

XML formatter replaces &quot to &quot

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 &quot to &quot ?

pipeline
xml
xml-formatter
  • viktor_n's avatar
    viktor_n
    5 years ago

    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,

3 Replies

  • viktor_n's avatar
    viktor_n
    Contributor II
    5 years ago

    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&quot; 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,