SQL Server Requires Chilkat v11.0.0+
SQL Server
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.
Chilkat SQL Server Downloads
--
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