(PowerBuilder) BatchModify - Add a Label to each Message in Search Results

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

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

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

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
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
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_Sb.ConnectToNewObject("Chilkat.StringBuilder")

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

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
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
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
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 = loo_Http.PostJson3(ls_Url,"application/json",loo_Json2)
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Sb
    destroy loo_Json
    destroy loo_Json2
    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_Resp
    destroy loo_Http
    destroy loo_Sb
    destroy loo_Json
    destroy loo_Json2
    return
end if

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

Write-Debug "BatchModify success!"


destroy loo_Http
destroy loo_Sb
destroy loo_Json
destroy loo_Json2