Skip to Content

Data Values Getting Mixed Up after Value Mapping

Hello,

I am facing a weird problem where, after a value mapping in my integration flow, the data from two different records is getting mixed up. Let me try to illustrate the issue with an example.

My source XML payload looks something like this:

<Collection>
<Entity1>
<ID>1111</ID>
</Entity1>

<Entity2>
<ID>2222</ID>
<AdditionalInfo>
<Color>Red</Color>
</AdditionalInfo>
</Entity2>
</Collection>

In the value mapping that follows the source payload, my intent is to move the element ("Color" in this case) under the "AddtionalInfo" element to directly below the root element (i.e. the Entity element). Although that is happening, unfortunately, the "Color" element gets added under the wrong entity (i.e. Entity1 instead of Entity 2) as depicted below.

<Collection>
<Entity1>
<ID>1111</ID>
<Color>Red</Color>
</Entity1>
<Entity2>
<ID>2222</ID>
</Entity2>
</Collection>

Any idea what could be causing this erratic behavior and how can it be resolved?

Thanks,
Akshat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 07, 2017 at 05:20 PM

    Hi Akshat,

    Are your creating and managing the value mapping in web?. If not, i would recommend to do so as the value mapping capabilities in web is quite comprehensive and there are many more operation you can perform in web as against working with the XML in eclipse. Please can you attach the screenshot of the value mapping editor in web and also of the valueMap function used in the message mapping. This would help to advise you on the next steps on how this issue can be resolved.

    Regards,

    Gayathri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kumar Akshat

      hi akshat,

      Are you still able to work with eclipse as i am getting the below error while installing new software in eclipse-oxygen version :

      not able to find the repository

      with ECLIPSE NEON version, the HANA cloud platform or HCI link is itself not coming for me in Install new software option

      Thanks

      Rohit