Multimapping with Dynamic Filename in SFTP receiver adapter

[aakanksha_kumari]

I am working on Proxy to SFTP scenario.

I am not able to achieve the variable substitution in SFTP receiver adapter because I have used MessageTransformBean for converting the XML file to .csv format.

The structure is like this

<Payment>

<LineItem>

<FILENAME>ABC_2017_100.csv</FILENAME>
<LINENO>01</LINENO>
<BATCHNO>12</BATCHNO>
<STATUS>received</STATUS>

</LineItem>

<LineItem>

<FILENAME>ABC_2017_100.csv</FILENAME>
<LINENO>01</LINENO>
<BATCHNO>12</BATCHNO>
<STATUS>received</STATUS>

</LineItem>

<LineItem>

<FILENAME>ABC_2017_200.csv</FILENAME>
<LINENO>01</LINENO>
<BATCHNO>12</BATCHNO>
<STATUS>received</STATUS>

</LineItem>

</Payment>

Two files should generate with the name ABC_2017_100.csv and ABC_2017_200.csv

We need to pick a filename from the payload content and then we need to set the filename dynamically.

[manoj_khavatkopp · Accepted solution]

AAkansha,

Any specific reason going for MTB ? This can be handled via FCC ryt.

However there are no straight forward solution below are few approach:

https://blogs.sap.com/2016/01/05/multi-mapping-with-dynamic-filename-using-variable-substitution/

https://blogs.sap.com/2015/01/28/multi-mapping-with-dynamic-configuration-soap-loopback-approach/

https://blogs.sap.com/2014/03/05/a-new-approach-multi-mapping-dynamic-configuration-using-a-generic-...

Br,

Manoj