I have moderate experience with CF, but none with webservices. Now I
have the task of consuming an external service for the purpose of not
only adding data to, but also to delete and most im****tantly update via
a compare and append query.
I am able to add the service into the components of CF and have also
added in some basic test records. Where I am currently stuck is getting
any kind of return on all the records in a specific table/dataset.
Here is a copy of the relavent calls
- <s:element name="GetAllEmployees">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="email" type="s:string"
/>
<s:element minOccurs="0" maxOccurs="1" name="pwd" type="s:string" />
- <s:element minOccurs="0" maxOccurs="1" name="dsData">
- <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="GetAllEmployeesResponse">
- <s:complexType>
- <s:sequence>
<s:element minOccurs="1" maxOccurs="1" name="GetAllEmployeesResult"
type="s:boolean" />
- <s:element minOccurs="0" maxOccurs="1" name="dsData">
- <s:complexType>
- <s:sequence>
<s:element ref="s:schema" />
<s:any />
</s:sequence>
</s:complexType>
</s:element>
</s:sequence>
</s:complexType>
</s:element>
I know that the email and pwd are valid and pass authetication for
other calls within the service, so I dont think it is that.
The one thing I see different here is that there is no return varialble
as I have seen with other calls. My counterpart who wrote the WSDL file
in .Net tells me that the call for her in .Net is
GetAllEmployees(byval email as string, byval pwd as stromg, byref
dsdata as dataset) as boolean
Any ideas on how to translate that into CF ??? I suspect that the
dsdata is what should be the returned recordset.
Any help would be great
T