Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 02, 2016 at 11:36 AM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 11:39 AM

    Hi Vidhya,

    I just given the java mapping in below question.

    How to send whole CSV file content into single filed

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded