Message - Trash
Trash a Gmail message using SQL Server
- See SQLHTTP easy setup for Gmail
- See API Call documentation for parameter values and other information
- Create the stored procedure documented below
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
CREATE PROCEDURE usp_Google_User_Message_Trash( @Profile nvarchar(100), @userId varchar(MAX), @id varchar(MAX), @Response nvarchar(MAX) OUTPUT, @StatusCode int OUTPUT, @StatusDescription nvarchar(MAX) OUTPUT) AS DECLARE @URL nvarchar(MAX) DECLARE @HTTPSessionID uniqueidentifier SET @URL = 'https://www.googleapis.com/gmail/v1' EXEC SQLHTTP.net.UrlBuilder @URL OUTPUT, @Profile, 'users', @userId, 'messages', @id, 'trash' EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT EXEC usp_Google_Auth_Header @Profile, @HTTPSessionID EXEC SQLHTTP.net.HTTPRequest @HTTPSessionID, @URL = @URL, @Method = 'POST', @ContentType = 'application/json', @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT, @Response = @Response OUTPUT GO |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
DECLARE @Response nvarchar(MAX) DECLARE @StatusCode int DECLARE @StatusDescription nvarchar(MAX) DECLARE @Profile nvarchar(100) SET @Profile = 'My google' --Google API Bearer Token expires after an hour EXEC usp_Google_Auth_Refresh @Profile EXEC usp_Google_User_Message_Trash @Profile = @Profile, @userId = 'me', @id = '161da0bcbe50d63f', @Response = @Response OUTPUT, @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT IF @StatusCode >= 400 EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response ELSE BEGIN DECLARE @X xml SET @X = SQLHTTP.net.Json_To_Xml(@Response, '0') --The XPath syntax below was easily generated by executing the following commands: --EXEC SQLHTTP.net.XQueryHelper @X --and then executing: --EXEC SQLHTTP.net.XQueryHelper @X, 'JsonObject' -- SELECT T.C.value(N'@id', N'nvarchar(MAX)') AS [id] ,T.C.value(N'@threadId', N'nvarchar(MAX)') AS [threadId] ,T.C.value(N'labelIds[1]/@JsonArrayItem1', N'nvarchar(MAX)') AS [labelId1] ,T.C.value(N'labelIds[1]/@JsonArrayItem2', N'nvarchar(MAX)') AS [labelId2] ,T.C.value(N'labelIds[1]/@JsonArrayItem3', N'nvarchar(MAX)') AS [labelId3] FROM @X.nodes(N'/JsonObject') T(C) END |
|
1 2 3 4 5 |
id threadId labelId1 labelId2 labelId3 ----------------- ----------------- ----------- ------------ ------------------ 161da0bcbe50d63f 161d8edeeaf5fc29 IMPORTANT TRASH CATEGORY_PERSONAL |
- Draft – Delete
- Draft – Fetch
- Draft – Send
- Drafts – Fetch
- Filter – Create
- Filter – Delete
- Filter – Fetch
- Filters – Fetch
- Forwarding Address – Fetch
- Forwarding Addresses – Fetch
- Gmail Notifications – Stop
- History – Fetch
- Imap Settings – Fetch
- Imap Settings – Update
- Label – Create
- Label – Delete
- Label – Fetch
- Label – Update
- Labels – Fetch
- Message – Fetch
- Message – Trash
- Message – Untrash
- Message – Update
- Messages – Delete
- Messages – Fetch
- Messages Labels – Batch Update
- Pop Settings – Fetch
- Pop Settings – Update
- Thread – Delete
- Thread – Fetch
- Thread – Trash
- Thread – Untrash
- Thread – Update
- Threads – Fetch
- User Profile – Fetch
- Vacation Responder Settings – Fetch
- Vacation Responder Settings – Update
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.