How to consume the webservice if it returns the data in dataset format

[Former Member]

Dear All,

We have a requirement to consume webservice created in .NET platform. In that webservice they are returning data in dataset format. In this case i am not able to create a proxy. It is showing the following information.

Cannot generate proxy (object schema mis

WSDL, see long text)

<?xml version="1.0" encoding="utf-8" ?>

- <wsdl:definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://tempuri.org/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

- <wsdl:types>

- <s:schema elementFormDefault="qualified" targetNamespace="http://tempuri.org/">

<s:import namespace="http://www.w3.org/2001/XMLSchema" />

- <s:element name="getTaskEffort">

- <s:complexType>

- <s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="SPRProjectId" type="s:string" />

</s:sequence>

</s:complexType>

</s:element>

- <s:element name="getTaskEffortResponse">

- <s:complexType>

- <s:sequence>

- <s:element minOccurs="0" maxOccurs="1" name="getTaskEffortResult">

- <s:complexType>

- <s:sequence>

<s:element ref="s:schema" />

<s:any />

</s:sequence>

</s:complexType>

</s:element>

</s:sequence>

</s:complexType>

</s:element>

</s:schema>

</wsdl:types>

- <wsdl:message name="getTaskEffortSoapIn">

<wsdl:part name="parameters" element="tns:getTaskEffort" />

</wsdl:message>

- <wsdl:message name="getTaskEffortSoapOut">

<wsdl:part name="parameters" element="tns:getTaskEffortResponse" />

</wsdl:message>

- <wsdl:portType name="OntimeWSSoap">

- <wsdl:operation name="getTaskEffort">

<documentation xmlns="http://schemas.xmlsoap.org/wsdl/">This method.</documentation>

<wsdl:input message="tns:getTaskEffortSoapIn" />

<wsdl:output message="tns:getTaskEffortSoapOut" />

</wsdl:operation>

</wsdl:portType>

- <wsdl:binding name="OntimeWSSoap" type="tns:OntimeWSSoap">

<soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document" />

- <wsdl:operation name="getTaskEffort">

<soap:operation soapAction="http://tempuri.org/getTaskEffort" style="document" />

- <wsdl:input>

<soap:body use="literal" />

</wsdl:input>

- <wsdl:output>

<soap:body use="literal" />

</wsdl:output>

</wsdl:operation>

</wsdl:binding>

- <wsdl:service name="OntimeWS">

<documentation xmlns="http://schemas.xmlsoap.org/wsdl/" />

- <wsdl:port name="OntimeWSSoap" binding="tns:OntimeWSSoap">

<soap:address location="http://hts-pcs-0808/OntimeData/Ontime.asmx" />

</wsdl:port>

</wsdl:service>

</wsdl:definitions>

I tried to consume webservice http://student.ohecampus.com/projects/group95/stud17/assignment7/validateEmail.asmx, which will return the data in boolean format. In this case, i am able to create a proxy and it is working fine. Can anyone help me out.

Thanks in advance.

Regards,

Karthick

[Former Member]

Hi All,

After analysing i got one point. With can can anyone suggest me what should i need to do?

I am trying to consume the webservice creted by .Net team. Actually they are returning data in dataset format. In SAP i am not able to create proxy for this. If result is of structured format or boolean type, i am able to create a proxy.

Regards,

Karthick

[Former Member]

Dear Raja,

I checked with webservice owner who created the webservice. They are telling that there is no problem in XML file which they gave. The webservice they provided is consumed in many application and it is working fine. When in SAP, i tried to create a proxy it is showing the in information which i mentioned in earlier posted forum message.

Kindly advice.

Regards,

Karthick

[athavanraja]

<i><b>object schema mis

WSDL, see long text)</b></i>

did you see the long text, it exactly tells you whats the problem with WSDL

Raja