(Excel) Create a New GMail Label

Demonstrates how to create a new GMail label.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.AuthToken = "GMAIL-ACCESS-TOKEN"


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

' Create the JSON to be sent in the HTTP request body.
' The name of the new label is "questions".
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("name","questions")
success = json.UpdateString("labelListVisibility","labelShow")
success = json.UpdateString("messageListVisibility","show")

json.EmitCompact = False
Debug.Print json.Emit()

' The JSON contains this:
' {
'   "name": "questions",
'   "labelListVisibility": "labelShow",
'   "messageListVisibility": "show"
' }


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

Set resp = http.PostJson3(url,"application/json",json)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "status = "; resp.StatusCode

' A 200 response status indicate success.
If (resp.StatusCode <> 200) Then
    Debug.Print resp.BodyStr
    Debug.Print "Failed."

    Exit Sub
End If

' A successful repsonse contains JSON that looks like this:

' {
'  "id": "Label_43",
'  "name": "questions",
'  "messageListVisibility": "show",
'  "labelListVisibility": "labelShow"
' }

Debug.Print "response body:"
Debug.Print resp.BodyStr

Debug.Print "GMail label created!"