Skip to Content
0

I want to send .CSV file to target system using file to soap scenario. How it can be achieved?

Nov 02, 2016 at 11:31 AM

61

avatar image

Hi Experts,

Source system : File to soap scenario.

Target system : Soap to file scenario.

I'm picking a file from ftp and sending the .CSV file to target using soap adapter

I need to convert the .CSV into XML before sending it to target. to achieve this we need to pass complete .CSV file into single field “Payload”. For this I need a java mapping.

Can anyone help me on this?

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

2 Answers

Raghuraman S Nov 02, 2016 at 11:36 AM
0

Hello Vidhya,

Is your scenario like File to SOAP scenario where the XML should be sent in a single field?

If yes,you can convert CSV to XML using FCC

Then using "Return as XML" option in mapping you can send the entire XML in to a single target field.

https://blogs.sap.com/2010/06/17/convert-the-input-xml-to-string-in-pi-71-using-standard-graphical-mapping/

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

You cannot use message mapping for this because source is not an XML, it is CSV file, you have to do it in java mapping.

0

I mentioned FCC to convert CSV to XML using FCC.

0
Praveen Gandepalli Nov 02, 2016 at 11:39 AM
0

Hi Vidhya,

I just given the java mapping in below question.

How to send whole CSV file content into single filed

Regards,

Praveen.

Share
10 |10000 characters needed characters left characters exceeded