ION data flow

unknown

FSM to EAM Integration issue :

The BOD has this string  "<ID accountingEntity="MH25@@1001"&gt;1001@@787&lt;/ID>"

which I would like to capture and modify to " <ID accountingEntity="MH25@@1001"&gt;787</ID>" before it gets to EAM.

Help is needed on how to modify the data flow and create a transformation step that will update the BOD and remove the 1001@@ from the store code before it gets to EAM.

Thanks

Maxime Richard

Hi there,

1) create a mapping in ION Desk

- choose graphical mapping

- choose your  source noun; target noun is the same

- go in XSLT editor, delete all the basic code. Answer "yes" to the question "Manual change in the code". 

- write the following code, something like this:

<xsl:stylesheet version="2.0" xmlns:xsl="">www.w3.org/.../Transform">

<xsl:output method="xml" encoding="utf-8" indent="yes"/>

<xsl:variable name="id" select="SyncMyNoun/ApplicationArea/ID" />
<xsl:variable name="ae" select="SyncMyNoun/ApplicationArea/ID[@accountingEntity]" />

<!-- Identity template : copy all text nodes, elements and attributes -->
<xsl:template match="@*|node()"&gt;
<xsl:copy>
<xsl:apply-templates select="@*|node()" />
</xsl:copy>
</xsl:template>

<!-- When matching ID, change value -->
<xsl:template match="ID">
<ID>
<xsl:attribute name="accountingEntity">
<xsl:value-of select="$ae" />
</xsl:attribute>
@'" />
</ID>
</xsl:template>

</xsl:stylesheet>

--> replace the noun with the one you are using... and the Xpath of <ID> tag if necessary

2) save & approve your mapping

3) Add a mapping step between "CSFSM out" and "EAM in" connection points

4) Test