Skip to Content
0

Data Values Getting Mixed Up after Value Mapping

Jul 07, 2017 at 02:52 PM

117

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gayathri Narayana
Jul 07, 2017 at 05:20 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Gayathri,

Thanks for your inputs. Yes, I have been working with Eclipse and not the web UI. I will keep your suggestion in mind for future; it's just that I got my hands dirty on Eclipse right from the beginning and now I am more comfortable with it. Anyway, the good news is that my colleague was able to sort out the issue by changing the "context" in the value mapping. I would have expected the mapping to work fine as-is but apparently, the context was key here.

Thanks again.

Regards,
Akshat

0
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

0