VBScript

BatchModify - Add a Label to each Message in Search Results

See more GMail REST API Examples

Searchs GMail for messages meeting a criteria and adds a label to each message found. VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

set http = CreateObject("Chilkat.Http")
http.AuthToken = "GMAIL-ACCESS-TOKEN"

userId = "me"
success = http.SetUrlVar("userId",userId)

query = "subject:questions"
success = http.SetUrlVar("query",query)

url = "https://www.googleapis.com/gmail/v1/users/{$userId}/messages?q={$query}"

set sb = CreateObject("Chilkat.StringBuilder")
success = http.QuickGetSb(url,sb)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

set json = CreateObject("Chilkat.JsonObject")
success = json.LoadSb(sb)
json.EmitCompact = 0
outFile.WriteLine(json.Emit())

If (http.LastStatus <> 200) Then
    outFile.WriteLine("Failed.")
    WScript.Quit
End If

' If successful, the received JSON looks like this:
' {
'   "messages": [
'     {
'       "id": "166f583051d36144",
'       "threadId": "166f583051d36144"
'     },
'     {
'       "id": "166f5815e1f36144",
'       "threadId": "166f5815e1f36144"
'     },
' 	...
'     {
'       "id": "166f580639e36144",
'       "threadId": "166f580639e36144"
'     },
'     {
'       "id": "15dbc2e28ec789c6",
'       "threadId": "15dbc2e28ec789c6"
'     }
'   ],
'   "nextPageToken": "13434766102274844688",
'   "resultSizeEstimate": 103
' }
' 

' Next, we'll be sending an HTTP POST to add the label "questions" to each message in the
' search results.  The JSON to be sent for the batchModify is this:

' 	{
' 	  "ids": [
' 	    string
' 	  ],
' 	  "addLabelIds": [
' 	    string
' 	  ],
' 	  "removeLabelIds": [
' 	    string
' 	  ]
' 	}

' We'll omit "removeLabelIds" because we're not removing any labels.
' We are parsing the JSON search results, and at the same time building the batchModify JSON.

set json2 = CreateObject("Chilkat.JsonObject")

i = 0
numMessages = json.SizeOfArray("messages")
Do While (i < numMessages)
    json.I = i
    id = json.StringOf("messages[i].id")
    json2.I = i
    success = json2.UpdateString("ids[i]",id)
    i = i + 1
Loop

' We need the id of the label (not the name).
' I know the name of the label is "questions", but I need to know the id.
' See this example: Get Label Id by Name
' The id of my label named "questions" is "Label_43"
labelId = "Label_43"
success = json2.UpdateString("addLabelIds[0]",labelId)
success = json2.UpdateNewArray("removeLabelIds")

json2.EmitCompact = 0
outFile.WriteLine(json2.Emit())

' Send the batchModify
url = "https://www.googleapis.com/gmail/v1/users/{$userId}/messages/batchModify"
set resp = CreateObject("Chilkat.HttpResponse")
success = http.HttpJson("POST",url,json2,"application/json",resp)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine("status = " & resp.StatusCode)

' A 204 response status indicate success.
If (resp.StatusCode <> 204) Then
    outFile.WriteLine(resp.BodyStr)
    outFile.WriteLine("Failed.")
    WScript.Quit
End If

' The 204 response has an empty response body..

outFile.WriteLine("BatchModify success!")

outFile.Close