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?