(PowerBuilder) 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

integer li_rc
integer li_Success
oleobject loo_Http
string ls_UserId
string ls_Url
oleobject loo_Sb
oleobject loo_Json
oleobject loo_JRecord

// 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_Url = "https://www.googleapis.com/gmail/v1/users/{$userId}/labels"

// Get the list of GMail labels as JSON.
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

// 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...
loo_JRecord = loo_Json.FindRecord("labels","name","QA",0)
if loo_Json.LastMethodSuccess = 1 then
    Write-Debug "The id of QA is: " + loo_JRecord.StringOf("id")
    destroy loo_JRecord
end if

loo_JRecord = loo_Json.FindRecord("labels","name","[Gmail]/testFolder",0)
if loo_Json.LastMethodSuccess = 1 then
    Write-Debug "The id of [Gmail]/testFolder is: " + loo_JRecord.StringOf("id")
    destroy loo_JRecord
end if

loo_JRecord = loo_Json.FindRecord("labels","name","questions",0)
if loo_Json.LastMethodSuccess = 1 then
    Write-Debug "The id of questions is: " + loo_JRecord.StringOf("id")
    destroy loo_JRecord
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


destroy loo_Http
destroy loo_Sb
destroy loo_Json