(SQL Server) Yahoo IMAP Authentication using OAuth2 Access Token

See more Yahoo Mail Examples

Demonstrates how to do IMAP OAuth2 authentication for Yahoo (or any other IMAP mail server supporting OAuth2 authentication). This example assumes an OAuth2 access token was previously obtained.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- See Get Yahoo Mail OAuth2 Access Token for Desktop App 
    -- for sample code showing how to obtain a Yahoo Mail access token.

    -- In this example, our access token was previously saved to the following file which contains JSON like this:
    -- {
    --   "access_token": "kCVQdnOdul...LHucA--",
    --   "refresh_token": "AIenVXETSo0jklFBVkPS8vVm8E.Ej9ToRG.xDbDYmZ65WIs5t6CZhDrD",
    --   "expires_in": 3600,
    --   "token_type": "bearer",
    --   "xoauth_yahoo_guid": "HGDQCVF5JB4YDOWHITQJFBHCWA"
    -- }

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

    DECLARE @success int
    EXEC sp_OAMethod @json, 'LoadFile', @success OUT, 'qa_data/tokens/yahooMail.json'
    IF @success <> 1
      BEGIN

        PRINT 'Failed to load GMail access token file.'
        EXEC @hr = sp_OADestroy @json
        RETURN
      END
    DECLARE @accessToken nvarchar(4000)
    EXEC sp_OAMethod @json, 'StringOf', @accessToken OUT, 'access_token'

    -- Do OAuth2 authentication by using the access token as the password in the Login method below...
    DECLARE @imap int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Imap', @imap OUT

    EXEC sp_OASetProperty @imap, 'Ssl', 1
    EXEC sp_OASetProperty @imap, 'Port', 993

    -- Connect to the Yahoo IMAP server.
    EXEC sp_OAMethod @imap, 'Connect', @success OUT, 'imap.mail.yahoo.com'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @imap, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @imap
        RETURN
      END

    -- Indicate that XOAUTH2 authentication is to be used:
    EXEC sp_OASetProperty @imap, 'AuthMethod', 'XOAUTH2'

    -- Login
    -- Use the email address of the GMail account that granted authorization.
    EXEC sp_OAMethod @imap, 'Login', @success OUT, 'user@yahoo.com', @accessToken
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @imap, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Successfully authenticated with Yahoo IMAP using XOAUTH2!'
      END

    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @imap


END
GO