You can translate the question and the replies:

SOAP Request is returning full XML strings

Hi all, I am trying to use data from the National Oceanic and Atmospheric Administration’s SOAP web service as a source. I have been able to create the data source, see the operations and create base views. However, I don’t think their web service is set up very well, the returns seem to be full XML strings. There is data in there eventually, I can tell. I have been trying to use a derived view to pull out a list of cities and Lat/Long coordinates from this XML, but aso far haven’t met with any success. Is this data something I can extract using Cast and CreateTypeFromXML functions or is there a better way to do this?
user
02-03-2018 15:45:21 -0500

1 Answer

Hi, First of all, I would create a [SOAP web service source](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/soap_web_service_sources) as you did to get all the data from the source. Second, I would create a [XML data source](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/xml_sources) selecting the “From Variable” option, giving an example of the XML returned by the SOAP web service to create the base view. Once you've created those views, you can create a join between the base view from the SOAP web service and the base view from XML data source using the XML field returned by the first one as input in the second one. In this join view you will have the XML fields as columns. You can find a similar question [here](https://community.denodo.com/answers/question/details?questionId=90670000000blRIAAY&title=how+to+transform+an+xml+output+from+a+webservice+into+a+row-column+format.). Hope this helps!
Denodo Team
05-03-2018 05:52:09 -0500
You must sign in to add an answer. If you do not have an account, you can register here