(Excel) Get a List of Message IDs in GMail User's Mailbox

Demonstrates how to get a list of message IDs in a GMail mailbox. The "userId" can be either the user's email address or the special value "me" to indicate the authenticated user.

For more information, see https://developers.google.com/gmail/api/v1/reference/users/messages/list

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 = "ACCESS_TOKEN"

http.Accept = "application/json"


Set resp = http.QuickRequest("GET","https://www.googleapis.com/gmail/v1/users/userId/messages")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: "; resp.StatusCode

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
Dim success As Boolean
success = jsonResponse.Load(resp.BodyStr)
jsonResponse.EmitCompact = False
Debug.Print jsonResponse.Emit()

If (resp.StatusCode <> 200) Then
    Debug.Print "Failed."

    Exit Sub
End If

' {
'   "messages": [
'     users.messages Resource
'   ],
'   "nextPageToken": string,
'   "resultSizeEstimate": unsigned integer
' }


resultSizeEstimate = jsonResponse.IntOf("resultSizeEstimate")

i = 0

count_i = jsonResponse.SizeOfArray("messages")
Do While i < count_i
    jsonResponse.I = i
    id = jsonResponse.StringOf("messages[i].id")
    threadId = jsonResponse.StringOf("messages[i].threadId")
    i = i + 1
Loop