(VBScript) Find a Label ID by Name

Lookup the ID of a GMail label by the label name.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")
http.AuthToken = "GMAIL-ACCESS-TOKEN"

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

url = "https://www.googleapis.com/gmail/v1/users/{$userId}/labels"

' Get the list of GMail labels as JSON.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sb = CreateObject("Chilkat.StringBuilder")
success = http.QuickGetSb(url,sb)
If (success <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
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

' The JSON returned looks like this:
' {
'   "labels": [
'     {
'       "id": "Label_5",
'       "name": "QA",
'       "messageListVisibility": "show",
'       "labelListVisibility": "labelShow",
'       "type": "user"
'     },
'     {
'       "id": "Label_21",
'       "name": "[Gmail]/testFolder",
'       "type": "user"
'     },
'     {
'       "id": "CATEGORY_PERSONAL",
'       "name": "CATEGORY_PERSONAL",
'       "type": "system"
'     },
' 	...

' The name of the label is generally known because it's what we visually see.
' The id is what we need to get.  Assuming the name is unique,
' find the JSON record having name=<desired name>
' For example...
' jRecord is a Chilkat.JsonObject
Set jRecord = json.FindRecord("labels","name","QA",0)
If (json.LastMethodSuccess = 1) Then
    outFile.WriteLine("The id of QA is: " & jRecord.StringOf("id"))

End If

' jRecord is a Chilkat.JsonObject
Set jRecord = json.FindRecord("labels","name","[Gmail]/testFolder",0)
If (json.LastMethodSuccess = 1) Then
    outFile.WriteLine("The id of [Gmail]/testFolder is: " & jRecord.StringOf("id"))

End If

' jRecord is a Chilkat.JsonObject
Set jRecord = json.FindRecord("labels","name","questions",0)
If (json.LastMethodSuccess = 1) Then
    outFile.WriteLine("The id of questions is: " & jRecord.StringOf("id"))

End If

' Output:

' The id of QA is: Label_5
' The id of [Gmail]/testFolder is: Label_21
' The id of questions is: Label_43

outFile.Close