StripLevels xml tags

[nareshv0308]

Hi Everyone,

I have a scenario where I need to trim the XML from backend and convert into JSON . my payload is like this.

<soapenv:Envelope 
   xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header/>
  <soap:Body>
      <Data>
	.
	.
      </Data>
  </soap:Body>
</soapenv:Envelope>

My Config :

<Properties/>
<Options>
  <RecognizeNumber>true</RecognizeNumber>
  <RecognizeBoolean>true</RecognizeBoolean>
  <RecognizeNull>false</RecognizeNull>
  <TextNodeName>content</TextNodeName>
  <StripLevels>2</StripLevels>
</Options>

I just need

{"Data" : "......"...}

Note: I tried different StripLevels like 4,6,8. No luck.

[deboraelkin · Accepted solution]

You have 2 options:

1. Apply an XSL transform before the XML2JSon step, so that your XML looks like <Data>...</Data>
2. After the XML2JSon use an ExtractVariables policy (with JSONPath) to extract the Data Component from your JSON

[dchiesa1]

yes

The StripLevels option strips levels ONLY if there is a single child at each level. The documentation explains this.

If you try XMLToJSON with this configuration,

<XMLToJSON name='XMLToJSON-2'>
  <Source>testMessage</Source>
  <OutputVariable>output_json</OutputVariable>
  <Options>
    <StripLevels>2</StripLevels>
  </Options>
</XMLToJSON> 

with your source XML, then you will see a resulting json, something like this:

{"Header":"","Body":{"Data":"..."}}

Both Header and Body appear. This is because the Header and Body elements are siblings, and as a result, the XMLToJSON won't strip beyond the first level. When there are multiple siblings, there is no way for the logic behind the "StripLevels" option to know which sibling you want to preserve!

The options Debora outlined are the way you can address your requirement.

[nareshv0308]

Yeah, I used the 2 option. However, would like to understand why StripLevels do not work in this scenario. @Dino-at-Google explained me below. Thanks !!

[dchiesa1]

When you say "no luck", what do you mean? What results DO you get?