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)
 Retrieve XML via URL within a stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-03-18 : 08:19:44
David writes "We are making us of a web service that returns XML based upon parameters in a URL. For example I can send www.webservice.com/index.asp?fname=David&phone=5555551212 and I will get back an XML doc with reverse look-up information.

I know how to query for and retrieve the XML doc with ASP but I am wondering if it is possible to do this directly within SQL Server? Can I execute and load the results of the http query from within a SQL Server stored procedure?

I look forward to your comments."

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-18 : 08:24:54
You might have a look at using using ServerXMLHTTP Directly:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk30/htm/xmobjxmldomserverxmlhttp_using_directly.asp

The following link demos this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30519&SearchTerms=xml

Though this may better be handled in another tier...
Go to Top of Page
   

- Advertisement -