header
header
Main Menu
Home
Eviware Store
Downloads
Products
News
Forum
Eviware Blog
Search
FAQs
Customer Area
Support
Documentation
Tutorials
CookBook
Downloads
Forum
Login Form
Welcome, Guest. Please login or register.
January 09, 2009, 12:05:46 am
Username: Password:
Login with username, password and session length

Forgot your password?
 
How to attach .xls file into request?
Welcome, Guest. Please login or register.
January 09, 2009, 12:05:46 am
Home Help Search Login Register
News: The Forums are up! Welcome to eviware.

+  Eviware Forum
|-+  soapUI
| |-+  soapUI
| | |-+  How to attach .xls file into request?
« previous next »
Pages: [1] Print
Author Topic: How to attach .xls file into request?  (Read 545 times)
zxsoap
Newbie
*
Posts: 19


« on: June 05, 2008, 03:50:43 pm »

Hi,

How do I attach a *.xls file into one of my soapui request?

Thanks,
zxsoap
Logged
omatzura
Administrator
Hero Member
*****
Posts: 1,666


« Reply #1 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
Logged
zxsoap
Newbie
*
Posts: 19


« Reply #2 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>
Logged
omatzura
Administrator
Hero Member
*****
Posts: 1,666


« Reply #3 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
Logged
zxsoap
Newbie
*
Posts: 19


« Reply #4 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--
Logged
omatzura
Administrator
Hero Member
*****
Posts: 1,666


« Reply #5 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
Logged
zxsoap
Newbie
*
Posts: 19


« Reply #6 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
Logged
Pages: [1] Print 
« previous next »
Jump to:  


Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
header header
header
header