Gmail (Google)

Interact with the Gmail API using SQL Server

  • Install the SQLHTTP database on your SQL Server
  • Select and enable a Google API
  • Proceed to select or create a new project and a new application
  • Add new “OAuth2 Client ID” Web application credentials and set the “Authorized redirect URIs” to http://localhost:53200 (or another port)
  • Record your Client ID and Client Secret.
  • Create the stored procedures documented below
  • Determine which Permissions Scope will be needed. Permissions Scopes are incremental
  • Execute the following SQL statement:

Stored Procedures:

Available API Calls:

s

IMPORTANT DISCLAIMER

CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.

USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.

USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.