(PowerBuilder) Outlook -- Delete Email

Demonstrates how to delete email using the Microsoft Graph API.

Note: This example requires Chilkat v9.5.0.68 or greater.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Http
oleobject loo_HtFolderMap
oleobject loo_SbMap
string ls_FolderId
integer li_Success
oleobject loo_Json
oleobject loo_SbResponse
string ls_Resp
string ls_MessageId
integer i
integer li_NumEmails

// 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

// Use your previously obtained access token here:
loo_Http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

// This example will search /Inbox for a message we want to delete.
// First we need to get the folder ID for /Inbox.
// Then we'll search for messages based on some criteria, and delete the matching messages.

// Get the folder ID for /Inbox from the folder map created by this example 
loo_HtFolderMap = create oleobject
// Use "Chilkat_9_5_0.Hashtable" for versions of Chilkat < 10.0.0
li_rc = loo_HtFolderMap.ConnectToNewObject("Chilkat.Hashtable")

loo_SbMap = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbMap.ConnectToNewObject("Chilkat.StringBuilder")

loo_SbMap.LoadFile("qa_data/outlook/folderMap.xml","utf-8")
loo_HtFolderMap.AddFromXmlSb(loo_SbMap)

// Get the ID for the "/Inbox" folder:
ls_FolderId = loo_HtFolderMap.LookupStr("/Inbox")
if loo_HtFolderMap.LastMethodSuccess <> 1 then
    Write-Debug "Folder ID not found"
    destroy loo_Http
    destroy loo_HtFolderMap
    destroy loo_SbMap
    return
end if

li_Success = 1
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.EmitCompact = 0

// Search for emails in this folder with the phrase "Amazon SES" in the subject, and return only the id and subject.
loo_Http.SetUrlVar("folder_id",ls_FolderId)
loo_Http.SetUrlVar("select","id,subject")
loo_Http.SetUrlVar("filter","contains(subject,'Amazon SES')")

loo_SbResponse = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponse.ConnectToNewObject("Chilkat.StringBuilder")

li_Success = loo_Http.QuickGetSb("https://graph.microsoft.com/v1.0/me/mailFolders/{$folder_id}/messages?$filter={$filter}&$select={$select}",loo_SbResponse)
if li_Success <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_HtFolderMap
    destroy loo_SbMap
    destroy loo_Json
    destroy loo_SbResponse
    return
end if

loo_Json.LoadSb(loo_SbResponse)
// Show the results..
Write-Debug loo_Json.Emit()

// Sample results:

// 	{
// 	  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/mailFolders('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgAuAAADsVyfxjDU406Ic4X7ill8xAEA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA')/messages(id,subject)",
// 	  "value": [
// 	    {
// 	      "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AAA1jyl6\"",
// 	      "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_AAAAA=",
// 	      "subject": "Amazon SES Address Verification Request in region US West (Oregon)"
// 	    },
// 	    {
// 	      "@odata.etag": "W/\"CQAAABYAAADn68XtMop0TpsYJGpfKXY9AAA1jyl7\"",
// 	      "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_EAAAA=",
// 	      "subject": "Amazon SES Address Verification Request in region US West (Oregon)"
// 	    }
// 	  ]
// 	}
// 

// ------------
// Proceed to delete each of the above emails...

i = 0
li_NumEmails = loo_Json.SizeOfArray("value")
do while i < li_NumEmails
    loo_Json.I = i

    ls_MessageId = loo_Json.StringOf("value[i].id")
    loo_Http.SetUrlVar("message_id",ls_MessageId)
    Write-Debug "Deleting " + ls_MessageId
    ls_Resp = loo_Http.QuickDeleteStr("https://graph.microsoft.com/v1.0/me/messages/{$message_id}")
    if loo_Http.LastMethodSuccess <> 1 then
        Write-Debug loo_Http.LastErrorText
        destroy loo_Http
        destroy loo_HtFolderMap
        destroy loo_SbMap
        destroy loo_Json
        destroy loo_SbResponse
        return
    end if

    // A 204 response indicates success.
    if loo_Http.LastStatus = 204 then
        Write-Debug "Message deleted."
    else
        Write-Debug "Message not deleted."
        Write-Debug ls_Resp
    end if

    i = i + 1
loop

// Sample output:

// Deleting AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_AAAAA=
// Message deleted.
// Deleting AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEMAAAA5_vF7TKKdE6bGCRqXyl2PQAAADLHd_EAAAA=
// Message deleted.
// 


destroy loo_Http
destroy loo_HtFolderMap
destroy loo_SbMap
destroy loo_Json
destroy loo_SbResponse