Converting XML elements into Values in SAP CI

[MortenWittrock]

Experts,

Source Data

<root>
  <test>
     <product>
        <box>square</box>
        <qty>5</qty>
     </product>
  </test>
</root>

Expected Data

<root>
  <Level1>test<Level1>
  <Level2>Product<Level2>
  <Level3>square</Level3>
  <Level4>5</Level4>
</root>

Can you please advice me on how to achieve the above requirement?

TIA,

Barath

[MortenWittrock]

Hi Barath

This is very hard to answer without some more detail. Is the above input and output data just a simplified example (one example out of possibly many), or is it the exact and only input and the exact output, you need produced? The latter is very easy, the former is potentially really quite hard 🙂

Regards,

Morten

[daviddasilva]

Hi,

It depends if the incoming messages are always the same structure?
If so, then you could use message mapping, create the source and target xsd accordingly.
Alternatively, you could do this with a groovy script which will be much more flexible.

Kind regards,

David

[barath_dv]

daviddasilva - Thanks for the comment.

The structure will be dynamic so we cannot make use of message mapping.