SOAP Axis sender with CSV file attachment

[Former Member]

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

[Former Member]

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.

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