PowerBuilder

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. PowerBuilder

integer li_rc
long li_Success
oleobject loo_Http
string ls_UserId
string ls_Query
string ls_Url
oleobject loo_Sb
oleobject loo_Json
oleobject loo_Json2
long i
long li_NumMessages
string ls_Id
string ls_LabelId
oleobject loo_Resp

li_Success = 0

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

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Http.AuthToken = "GMAIL-ACCESS-TOKEN"

ls_UserId = "me"
loo_Http.SetUrlVar("userId",ls_UserId)

ls_Query = "subject:questions"
loo_Http.SetUrlVar("query",ls_Query)

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

loo_Sb = create oleobject
li_rc = loo_Sb.ConnectToNewObject("Chilkat.StringBuilder")

li_Success = loo_Http.QuickGetSb(ls_Url,loo_Sb)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Sb
    return
end if

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.LoadSb(loo_Sb)
loo_Json.EmitCompact = 0
Write-Debug loo_Json.Emit()

if loo_Http.LastStatus <> 200 then
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_Sb
    destroy loo_Json
    return
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.

loo_Json2 = create oleobject
li_rc = loo_Json2.ConnectToNewObject("Chilkat.JsonObject")

i = 0
li_NumMessages = loo_Json.SizeOfArray("messages")
do while (i < li_NumMessages)
    loo_Json.I = i
    ls_Id = loo_Json.StringOf("messages[i].id")
    loo_Json2.I = i
    loo_Json2.UpdateString("ids[i]",ls_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"
ls_LabelId = "Label_43"
loo_Json2.UpdateString("addLabelIds[0]",ls_LabelId)
loo_Json2.UpdateNewArray("removeLabelIds")

loo_Json2.EmitCompact = 0
Write-Debug loo_Json2.Emit()

//  Send the batchModify
ls_Url = "https://www.googleapis.com/gmail/v1/users/{$userId}/messages/batchModify"
loo_Resp = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

li_Success = loo_Http.HttpJson("POST",ls_Url,loo_Json2,"application/json",loo_Resp)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Sb
    destroy loo_Json
    destroy loo_Json2
    destroy loo_Resp
    return
end if

Write-Debug "status = " + string(loo_Resp.StatusCode)

//  A 204 response status indicate success.
if loo_Resp.StatusCode <> 204 then
    Write-Debug loo_Resp.BodyStr
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_Sb
    destroy loo_Json
    destroy loo_Json2
    destroy loo_Resp
    return
end if

//  The 204 response has an empty response body..

Write-Debug "BatchModify success!"


destroy loo_Http
destroy loo_Sb
destroy loo_Json
destroy loo_Json2
destroy loo_Resp