How can I convert the result object XML to CURSOR

[TOGORO]

Hi, I have the result from a WEB Service but I don't know how to reference it to convert it to cursor.

loWS = CREATEOBJECT("MSSOAP.SoapClient30")

loWS.MSSoapInit("

http://srvsar4/Ws_Incapacidades/SERV.asmx?WSDL")

loResult = loWS.Busca_Incapacidad_Expediente(Expe1)

then loResult.???????


THE WEB SERVICE IS DEFINED :

<?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="Busca_Incapacidad_Expediente">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="sExpediente" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="Busca_Incapacidad_ExpedienteResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="Busca_Incapacidad_ExpedienteResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="Busca_Incapacidad_RT_Expediente">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="sExpediente" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="Busca_Incapacidad_RT_ExpedienteResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="Busca_Incapacidad_RT_ExpedienteResult">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="Busca_Incapacidad_Expediente_Fecha">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="sExpediente" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="sFechaInicio" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="sFechaFinal" type="s:string" />
</s:sequence>
</s:complexType>
</s:element>
- <s:element name="Busca_Incapacidad_Expediente_FechaResponse">
- <s:complexType>
- <s:sequence>
- <s:element minOccurs="0" maxOccurs="1" name="Busca_Incapacidad_Expediente_FechaResult">
- <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="Busca_Incapacidad_ExpedienteSoapIn">
<wsdlart name="parameters" element="tns:Busca_Incapacidad_Expediente" />
</wsdl:message>
- <wsdl:message name="Busca_Incapacidad_ExpedienteSoapOut">
<wsdlart name="parameters" element="tns:Busca_Incapacidad_ExpedienteResponse" />
</wsdl:message>
- <wsdl:message name="Busca_Incapacidad_RT_ExpedienteSoapIn">
<wsdlart name="parameters" element="tns:Busca_Incapacidad_RT_Expediente" />
</wsdl:message>
- <wsdl:message name="Busca_Incapacidad_RT_ExpedienteSoapOut">
<wsdlart name="parameters" element="tns:Busca_Incapacidad_RT_ExpedienteResponse" />
</wsdl:message>
- <wsdl:message name="Busca_Incapacidad_Expediente_FechaSoapIn">
<wsdlart name="parameters" element="tns:Busca_Incapacidad_Expediente_Fecha" />
</wsdl:message>
- <wsdl:message name="Busca_Incapacidad_Expediente_FechaSoapOut">
<wsdlart name="parameters" element="tns:Busca_Incapacidad_Expediente_FechaResponse" />
</wsdl:message>
- <wsdlortType name="SERVSoap">
- <wsdlperation name="Busca_Incapacidad_Expediente">
<documentation xmlns="

http://schemas.xmlsoap.org/wsdl/">Busca

las Incapacidades del Empleado, por Expediente</documentation>
<wsdl:input message="tns:Busca_Incapacidad_ExpedienteSoapIn" />
<wsdlutput message="tns:Busca_Incapacidad_ExpedienteSoapOut" />
</wsdlperation>
- <wsdlperation name="Busca_Incapacidad_RT_Expediente">
<documentation xmlns="

http://schemas.xmlsoap.org/wsdl/">Busca

las Incapacidades RT del Empleado, por Expediente</documentation>
<wsdl:input message="tns:Busca_Incapacidad_RT_ExpedienteSoapIn" />
<wsdlutput message="tns:Busca_Incapacidad_RT_ExpedienteSoapOut" />
</wsdlperation>
- <wsdlperation name="Busca_Incapacidad_Expediente_Fecha">
<documentation xmlns="

http://schemas.xmlsoap.org/wsdl/">Busca

las Incapacidades del Empleado, por Expediente y Fechas</documentation>
<wsdl:input message="tns:Busca_Incapacidad_Expediente_FechaSoapIn" />
<wsdlutput message="tns:Busca_Incapacidad_Expediente_FechaSoapOut" />
</wsdlperation>
</wsdlortType>
- <wsdl:binding name="SERVSoap" type="tns:SERVSoap">
<soap:binding transport="

http://schemas.xmlsoap.org/soap/http"

style="document" />
- <wsdlperation name="Busca_Incapacidad_Expediente">
<soapperation soapAction="

http://tempuri.org/Busca_Incapacidad_Expediente"

style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdlutput>
<soap:body use="literal" />
</wsdlutput>
</wsdlperation>
- <wsdlperation name="Busca_Incapacidad_RT_Expediente">
<soapperation soapAction="

http://tempuri.org/Busca_Incapacidad_RT_Expediente"

style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdlutput>
<soap:body use="literal" />
</wsdlutput>
</wsdlperation>
- <wsdlperation name="Busca_Incapacidad_Expediente_Fecha">
<soapperation soapAction="

http://tempuri.org/Busca_Incapacidad_Expediente_Fecha"

style="document" />
- <wsdl:input>
<soap:body use="literal" />
</wsdl:input>
- <wsdlutput>
<soap:body use="literal" />
</wsdlutput>
</wsdlperation>
</wsdl:binding>
- <wsdl:service name="SERV">
<documentation xmlns="

http://schemas.xmlsoap.org/wsdl/"

/>
- <wsdlort name="SERVSoap" binding="tns:SERVSoap">
<soap:address location="

http://srvsar4/Ws_Incapacidades/SERV.asmx"

/>
</wsdlort>
</wsdl:service>
</wsdl:definitions>

 

[dbMark]

loWS = CREATEOBJECT("MSSOAP.SoapClient30")
(enable MS Soap)
loWS.MSSoapInit("

http://srvsar4/Ws_Incapacidades/SERV.asmx?WSDL")

(initiate the hook into the object, your Visual FoxPro DLL)
loResult = loWS.Busca_Incapacidad_Expediente(Expe1)
(make a call to one of the procedures or functions in your project's DLL where the procedure or function is named "Busca_Incapacidad_Expediente" and the parameter sent to it is the contents of the variable "Expe1". loRusult will hold the returned value.)

The WSDL file contains all the references necessary for the incoming request to be sent to the correct function within the DLL.

Does that answer your question?

Please be aware that XML wants you to use DLLs not EXEs. (Don't worry too much, a DLL can call an EXE if you need to run a report form or something else that *may* require user interaction or notification. DLLs do not allow screen/display access.)

 

[dbMark]

You want to put loResult into a cursor? What data type is it? It could be a string, number, array, or a number of other data types. Depending on the data type, yes the result can be placed in a cursor/table. Here is how you determing the data type:

? TYPE("loResult")

? VARTYPE(loResult)

 

[TOGORO]

Thanks a lot, maybe I wasn´t so explicit, I have resolved my problem with the next instructions in Vfp 9.0

loResult = ObjXML.Busca_Incapacidad_Expediente(Expe1)

" my problem was WHAT NEXT to convert it to CURSOR "

DataXML = loResult.item(0).parentNode.xml

LOCAL oXA as xmladapter
oXA = CREATEOBJECT("XMLAdapter")
oXA.loadxml(DataXML,.F.,.T.)

IF (USED("ResulXML"))
USE IN ResulXML
ENDIF

oXA.tables[1].tocursor(.F.,"ResulXML")
BROWSE

VOILA, RESOLVED

I found it in

http://www.programmersheaven.com/2/FoxPronetwebservices

THANKS A LOT