-
1. Re: Problem with using Web Services as Relational Source Model
jdoyle Apr 7, 2010 10:17 AM (in response to dhryvastov)This connector will not work with the preview functionality (the running man). Queries for this connector have to be joins and preview only makes single table queries. So the first thing you would have to do is make a VDB so that you can query with joins.
In order to query this service you have to supply your criteria to the table representing the soap request (soapin) and join this table with the result tables with criteria like ResponseOut = ResponseIn in order to 'feed' the response document to the data table.
This query should work.
select data.MaxTemperatureF
from GetWeatherByPlaceNameSoapIn request, GetWeatherByPlaceName.WeatherData data
where
request.placename = 'Boston' and
request.ResponseOut = data.ResponseIn
There is unfortunatly one defect that the connector that is fixed in the forthcoming release that will block you from getting this service to work. The SOAP-Action is not getting entered in the request document. There is no way to work around this. Please take a look at the next milestone release when it comes out.
~john
-
2. Re: Problem with using Web Services as Relational Source Model
dhryvastov Apr 7, 2010 10:22 AM (in response to jdoyle)Thank you, John!
I will try the steps you described.
I am looking forward for the next release.
- Denys