Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

Refresh a Gmail OAuth access token

See more GMail REST API Examples

Use the refresh token and the same Desktop app client that issued it. Run in the private directory used by the authorization example. Preserve the refresh token if Google omits it from the response. Refreshing continues the existing grant. Request additional scopes through interactive authorization.

Google documentation

Chilkat SQL Server Downloads

SQL Server
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @iTmp1 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.

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

    EXEC sp_OAMethod @token, 'LoadFile', @success OUT, 'gmail-token.json'
    IF @success <> 1
      BEGIN

        PRINT 'Could not read gmail-token.json from the private working directory.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    EXEC sp_OAMethod @token, 'JsonTypeOf', @iTmp0 OUT, 'refresh_token'
    EXEC sp_OAMethod @token, 'StringOfEquals', @iTmp1 OUT, 'refresh_token', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN

        PRINT 'Authorize the account for offline access first.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    DECLARE @oauth int
    EXEC @hr = sp_OACreate 'Chilkat.OAuth2', @oauth OUT

    EXEC sp_OASetProperty @oauth, 'TokenEndpoint', 'https://oauth2.googleapis.com/token'
    EXEC sp_OASetProperty @oauth, 'ClientId', 'YOUR_DESKTOP_CLIENT_ID'
    EXEC sp_OASetProperty @oauth, 'ClientSecret', 'YOUR_DESKTOP_CLIENT_SECRET'
    EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'refresh_token'
    EXEC sp_OASetProperty @oauth, 'RefreshToken', @sTmp0
    EXEC sp_OAMethod @oauth, 'RefreshAccessToken', @success OUT
    IF @success <> 1
      BEGIN

        PRINT 'Refresh failed. Check the OAuth client and grant. A revoked or expired grant requires fresh consent.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @oauth
        RETURN
      END
    DECLARE @fresh int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @fresh OUT

    EXEC sp_OAGetProperty @oauth, 'AccessTokenResponse', @sTmp0 OUT
    EXEC sp_OAMethod @fresh, 'Load', @success OUT, @sTmp0
    IF @success <> 1
      BEGIN

        PRINT 'Could not parse the refresh response.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @oauth
        EXEC @hr = sp_OADestroy @fresh
        RETURN
      END
    EXEC sp_OAMethod @fresh, 'JsonTypeOf', @iTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @fresh, 'StringOfEquals', @iTmp1 OUT, 'access_token', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN

        PRINT 'The refresh response did not contain an access token.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @oauth
        EXEC @hr = sp_OADestroy @fresh
        RETURN
      END
    EXEC sp_OAMethod @fresh, 'JsonTypeOf', @iTmp0 OUT, 'refresh_token'
    EXEC sp_OAMethod @fresh, 'StringOfEquals', @iTmp1 OUT, 'refresh_token', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN
        EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'refresh_token'
        EXEC sp_OAMethod @fresh, 'UpdateString', @success OUT, 'refresh_token', @sTmp0
      END
    EXEC sp_OAMethod @fresh, 'HasMember', @iTmp0 OUT, 'scope'
    EXEC sp_OAMethod @token, 'JsonTypeOf', @iTmp1 OUT, 'scope'
    IF (@iTmp0 <> 1) and (@iTmp1 = 1)
      BEGIN
        EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'scope'
        EXEC sp_OAMethod @fresh, 'UpdateString', @success OUT, 'scope', @sTmp0
      END
    EXEC sp_OAMethod @fresh, 'WriteFile', @success OUT, 'gmail-token.json'
    IF @success <> 1
      BEGIN

        PRINT 'Could not save the refreshed credentials.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @oauth
        EXEC @hr = sp_OADestroy @fresh
        RETURN
      END

    PRINT 'Refreshed the access token.'

    EXEC @hr = sp_OADestroy @token
    EXEC @hr = sp_OADestroy @oauth
    EXEC @hr = sp_OADestroy @fresh


END
GO