Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2013-03-27 : 04:19:01
|
| Below is the query to get data from web service but it returns only 2 columns ,xlmns(http://abc.com.sg/abcWebservices/) and ListAppointmentsResponse(blank).I am struggling this issue for days already, can anyone advise what could be wrong in the query ?<Query> <SoapAction>http://abc.com.sg/abcWebservices/ListAppointments</SoapAction> <Method Namespace="http://abc.com.sg/abcWebServices" Name="ListAppointments" > <Parameters> <Parameter Name="Code" Type="String"><DefaultValue>xyz</DefaultValue></Parameter> <Parameter Name="PNo" Type="String"><DefaultValue>12345</DefaultValue></Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="true">*</ElementPath> </Query> |
|
|
|
|
|
webservice in ssrs