January 13, 2006 at 7:58 am
I know in 2005 we can use SQL as a web service directly via endpoints etc. But can I reverse it and use SQL as the client requesting the web service? I'm trying to take advantage of Yahoo's newly released geocoding API, which can be accessed through a URL, and then returns XML that must be parsed.... for example....
Is there a way from SQL to hit this URL, get the XML back, parse it and put it into a table?
January 16, 2006 at 8:00 am
This was removed by the editor as SPAM
January 16, 2006 at 9:37 am
Sure, using a SQLCLR object (a stored procedure or function implemented in a .NET language) you can access webservices. The assembly containing the object needs to be registered with EXTERNAL_ACCESS permission set. There should be samples included with SQL Server 2005 that show how to do it, or search online.
January 17, 2006 at 9:06 am
The SQLCLR team's blog has a good post showing this:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply