Examine HTTP Request and Response Headers

Demonstrates how to examine the HTTP request and response headers after doing an HTTP GET (also works for POST, PUT, DELETE, etc.)

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

    --  Send the HTTP GET and return the content in a string.
    --  (cknotes.com is the Chilkat blog.)
    DECLARE @html nvarchar(4000)

    EXEC sp_OAMethod @http, 'QuickGetStr', @html OUT, 'http://www.cknotes.com/'
    IF @html Is NULL 
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  This example is about examining the request/response headers, so we're ignoring the html received...

    --  Show the HTTP request header:
    EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT

    PRINT @sTmp0

    --  Show the HTTP response header:
    EXEC sp_OAGetProperty @http, 'LastResponseHeader', @sTmp0 OUT

    PRINT @sTmp0


END
GO