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

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

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

//  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
li_rc = loo_HtFolderMap.ConnectToNewObject("Chilkat.Hashtable")

loo_SbMap = create oleobject
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
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
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