Question Re: Converting XML elements into Values in SAP CI in Technology Q&A

Converting XML elements into Values in SAP CI

barath_dv — Thu, 22 Jun 2023 10:13:09 GMT

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

Re: Converting XML elements into Values in SAP CI

daviddasilva — Thu, 22 Jun 2023 15:36:19 GMT

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

Re: Converting XML elements into Values in SAP CI

arjun_kar — Thu, 22 Jun 2023 16:48:15 GMT

Hi, I can recommend you to use the XSLT to achieve your output

XSLT:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" indent="yes"/>


  <xsl:template match="/">
    <root>
      <xsl:apply-templates select="root/test/product"/>
    </root>
  </xsl:template>


  <xsl:template match="product">
    <Level1>
      <xsl:value-of select="ancestor::test[1]/name()"/>
    </Level1>
    <Level2>
      <xsl:value-of select="name()"/>
    </Level2>
    <xsl:apply-templates/>
  </xsl:template>


  <xsl:template match="box">
    <Level3>
      <xsl:value-of select="."/>
    </Level3>
  </xsl:template>


  <xsl:template match="qty">
    <Level4>
      <xsl:value-of select="."/>
    </Level4>
  </xsl:template>


</xsl:stylesheet>

Output:

<?xml version="1.0" encoding="UTF-8"?>
<root>
<Level1>test</Level1>
<Level2>product</Level2>
<Level3>square</Level3>
<Level4>5</Level4>
</root>

Re: Converting XML elements into Values in SAP CI

MortenWittrock — Fri, 23 Jun 2023 11:11:39 GMT

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

Re: Converting XML elements into Values in SAP CI

barath_dv — Tue, 04 Jul 2023 15:56:50 GMT

karthikarjun - Thanks for the comment.

<root>
  <dynamic1>
     <dynamic2>
        <dynamic3>square</dynamic3>
        <dynamic4>5</dynamic4>
     </dynamic2>
  </dynamic1>
</root>

The source field names can be dynamic. Is it possible to read and use it?

Re: Converting XML elements into Values in SAP CI

barath_dv — Tue, 04 Jul 2023 15:58:27 GMT

daviddasilva - Thanks for the comment.

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

Re: Converting XML elements into Values in SAP CI

arjun_kar — Fri, 07 Jul 2023 10:32:23 GMT

HI barath.v - In the general scenario, the inbound message does not adhere to a specific pattern for data handling. Instead, it is dynamic, indicating the presence of unstructured data. This situation can be both intriguing and challenging.