cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member233212
Participant
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182412
Active Contributor
0 Kudos

Hi Vidhya,

I just given the java mapping in below question.

How to send whole CSV file content into single filed

Regards,

Praveen.

former_member186851
Active Contributor
0 Kudos

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-m...

former_member182412
Active Contributor
0 Kudos

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.

former_member186851
Active Contributor
0 Kudos

I mentioned FCC to convert CSV to XML using FCC.