Skip to Content
author's profile photo Former Member
Former Member

SOAP Axis sender with CSV file attachment

Hi Experts,

I have a requirement where I receive a CSV file attachment from a Web Service post ( i.e a SOAP sender with attachment). I decided to use SOAP with Servlet(Axis) protocol, since standard SOAP sender does not allow modules to be used.

I am able to test this interface through SOAPUI with attachment to the point where I can get the attachment payload as my main payload in IE, but it fails in mapping since CSV needs to be converted to XML. I have following queries for proceeding ahead with this scenario:

1. How do I convert the CSV attachment to XML inorder for mapping to be used in IE. Is there a standard axis handler available for this ???? Also where should this handler be called in the sequence of Axis modules ???

2. Can I use MessageTransformationBean for converting plain to XML ??? If yes where should this module be called in the sequence of Axis modules. I tried using this module between the CallSapAdapter and the first AdapterBean but it returns exception in SOAPUI saying " Messaging exception: No Main"

3. Is there a blog available which illustrates about using additional modules/handlers in Axis. I have had a look at the FAQ note of Axis but it just gives the overview.

Thanks.

Siddhesh S.Tawate

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2010 at 10:01 PM

    Solved :).

    1 AF_Adapters/axis/HandlerBean Local Enterprise Bean xireq

    2 AF_Adapters/axis/AFAdapterBean Local Enterprise Bean afreq

    3 localejbs/AF_Modules/MessageTransformBean Local Enterprise Bean Plain2XML

    4 CallSapAdapter Local Enterprise Bean sap

    5 AF_Adapters/axis/AFAdapterBean Local Enterprise Bean afresp

    6 AF_Adapters/axis/HandlerBean Local Enterprise Bean xires

    Above sequence worked. I guess I was missing some parameter in content conversion earlier.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Siddhesh,

      a interesting approach.

      I'm looking for a very similar solution where we need to receive a flat file as payload of a SOAP mesg.

      PI will provide the webservice and a soap-client will post the flat file.

      Since PI can only map from XML to XML we need to convert this flat file to an xml format

      and from there we can map to an iDoc for further processing.

      We cannot use the FCC option from the File Adapter.

      I would appreciate if you can provide more details on this solution.

      Examples would be great..

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.