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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  OPENXML Vs SOAP response

Author  Topic  REDDY Starting Member 43 Posts Posted - 2005-08-09 : 11:40:23 Dear experts I would like to Extract the data from a soap reponse(xml Web service reply) using OPENXML. I am passing the soap response from ASP to SQL server stored procedure. Do I need to delete the soap related tags using the DOM (document object Model) from ASP and then send the data to sql server or can I use the OPENXML directly within sql?? If I use the soap response directly within SQL server I will have the folowing soap ralted tags extra within the data which creates a problem for OPENXML <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soap:Body> <xmlfeed_GetxmlResponse xmlns="http://www.abcd.com/webservice"> --Actual xml data </xmlfeed_GetxmlResponse> </soap:Body> </soap:Envelope> Thanks Reddy