|
Title: How to attach .xls file into request? Post by: zxsoap on June 05, 2008, 03:50:43 pm Hi,
How do I attach a *.xls file into one of my soapui request? Thanks, zxsoap Title: Re: How to attach .xls file into request? Post by: omatzura on June 09, 2008, 09:20:47 am Hi!
use the attachments inspector ("Att") at the bottom of the request editor. regards! /Ole eviware.com Title: Re: How to attach .xls file into request? Post by: zxsoap on June 09, 2008, 09:07:12 pm Thank for your reply.
Yes, I did use it. Here's what I got from SOAPUI 2.0.2 MTOM Attachments Processing Failed: Cannot de-serialize the input MIME Stream; value of the 'type' parameter of the 'Content-Type' header of the MIME message is not equal to 'application/xop+xml'</detail> I tried to attached .cvs file to one of three requests. like this: <soapenv:Body> <amac:validateBatchFile> <validateBatchFileRequest> <auditInfo> <sessionID>111</sessionID> <loginName>q111</loginName> </auditInfo> <batchFile>YES</batchFile> </validateBatchFileRequest> </amac:validateBatchFile> </soapenv:Body> Title: Re: How to attach .xls file into request? Post by: omatzura on June 09, 2008, 09:18:50 pm Hi!
have you enabled MTOM for your request? (bottom left property..). If so, can you show the contents of the http-log containing the request and its response? regards! /Ole eviware.com Title: Re: How to attach .xls file into request? Post by: zxsoap on June 10, 2008, 02:27:38 pm I did set those to MTOM/Inline to "TRUE".
Here's log from response: HTTP/1.1 500 Internal Server Error Content-Length: 1842 Set-Cookie: ssnid=489d924036f011dd93c7ab376a150aef; path=/; Content-Type: text/xml <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"></SOAP-ENV:Header><SOAP-ENV:Body xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Fault xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <faultcode xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">SOAP-ENV:Client</faultcode> <faultstring xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">[ISS.0088.9134] Exception occurred while processing the body of the message</faultstring> <faultactor xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">http://dfsap28.kinkosdev.com:7777/ws/amAccountDataServices.services:amServices</faultactor> <detail xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">MTOM Attachments Processing Failed: Cannot de-serialize the input MIME Stream; value of the 'start-info' parameter of the 'Content-Type' header of the MIME message is not equal to 'application/soap+xml'</detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> Here's request: MIME-Version: 1.0 Host: dfsap77.xxxx.com:7777 Content-Length: 1136 SOAPAction: "amAccountDataServices_services_amServices_Binder_validateBatchFile" User-Agent: Jakarta Commons-HttpClient/3.0.1 Content-Type: multipart/related; type="application/xop+xml"; start="<rootpart@soapui.org>"; start-info="text/xml"; boundary="----=_Part_4_6999470.1213111352671" ------=_Part_4_6999470.1213111352671 Content-Type: application/xop+xml; charset=UTF-8; type="text/xml" Content-Transfer-Encoding: 8bit Content-ID: <rootpart@soapui.org> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:amac="http://dfsap28.kinkosdev.com/amAccountDataServices.services"> <soapenv:Header/> <soapenv:Body> <amac:validateBatchFile> <validateBatchFileRequest> <auditInfo> <sessionID>20080610</sessionID> <loginName>qa123</loginName> </auditInfo> <batchFile>YES</batchFile> </validateBatchFileRequest> </amac:validateBatchFile> </soapenv:Body> </soapenv:Envelope> ------=_Part_4_6999470.1213111352671 Content-Type: application/octet-stream Content-Transfer-Encoding: binary Yes,1,GO Co,GO Co,123 High Street,,Houston,TX,75240,US,J XXX, Smith,9725551212,xx.smith@go.com,Yes,Yes,Yes,Yes,Yes,Yes,xxx,Smith,xxx.smith@go.com,Yes,Standard,Yes,Yes,456 Main Street,,Houston,TX,75254,US,John,Smith,2145551212 ------=_Part_4_6999470.1213111352671-- Title: Re: How to attach .xls file into request? Post by: omatzura on June 10, 2008, 10:53:25 pm Hi,
the error message indicates that the server is expecting a SOAP 1.2 compliant MTOM attachment, maybe you have a SOAP 1.2 binding available that you could use instead? Otherwise, try setting the SOAP Version of the interface to 1.2 (bottom left properties when interface is selected) to see if that helps regards! /Ole eviware.com Title: Re: How to attach .xls file into request? Post by: zxsoap on June 16, 2008, 08:35:35 pm Hi,
Can you please show me more detail how to set the property up? I could not able to do it. Thanks, T |