Send Ping to Yahoo! when RSS Feed is Updated

How to ping Yahoo! when an RSS feed has been updated, using the REST interface.

Download Chilkat HTTP ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    --  Any string unlocks the component for the 1st 30-days.
    EXEC sp_OAMethod @http, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        RETURN
      END

    --  Yahoo indicates that The REST interface:
    --  URL: http://ping.feeds.yahoo.com/rss/ping
    --  Parameter(s): u=<site or feed url>
    --  HTTP method: GET

    --  The RSS2 feed URL for blog.chilkatsoft.com is:
    --  http://blog.chilkatsoft.com/?feed=rss2

    --  Send the HTTP GET and return the content in a string.
    DECLARE @responseText nvarchar(4000)

    EXEC sp_OAMethod @http, 'QuickGetStr', @responseText OUT, 'http://ping.feeds.yahoo.com/rss/ping?u=http://blog.chilkatsoft.com/?feed=rss2'


    PRINT @responseText
END
GO