(PowerBuilder) Outlook --Download Attachments for a Specific Message

See more Outlook Examples

Demonstrates how to download the attachments for a particular email message.

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

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Http
oleobject loo_SbResponse
string ls_MessageId
integer li_Success
oleobject loo_Json
oleobject loo_SbSavePath
oleobject loo_AttachData
oleobject loo_LastMod
oleobject loo_Fac
integer i
integer li_NumMessages
integer li_SizeInBytes

// 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:
// See the following examples for getting an access token:
//    Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint).
//    Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint).
//    Refresh Access Token (Azure AD v2.0 Endpoint).
//    Refresh Access Token (Azure AD Endpoint).

loo_Http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

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

// Sends:  GET /users/{user_id | userPrincipalName}/messages/{message_id}/attachments
// Note: It is also possible to use the literal string "me" for the current logged-on user.
// For example: GET /me/messages/{message_id}/attachments

loo_Http.ClearUrlVars()
loo_Http.SetUrlVar("userPrincipalName","chilkatsoft@outlook.com")

// Assume we already have a message ID from previously listing the messages in a folder
ls_MessageId = "AAMkADYzZWE3YmZmLWU0YzgtNGNkZC04MGE1LWFiYTFlNTRlY2QwYQBGAAAAAAAu7cUXL5YOTrdsUIw7-v8FBwBUcG0qWqkmQYqWLHQataQxAACnwqJUAABUcG0qWqkmQYqWLHQataQxAACnwrnOAAA="
loo_Http.SetUrlVar("message_id",ls_MessageId)

// Send the request to download the attachments.
li_Success = loo_Http.QuickGetSb("https://graph.microsoft.com/v1.0/users/{$userPrincipalName}/messages/{$message_id}/attachments",loo_SbResponse)
if (li_Success <> 1) AND (loo_Http.LastStatus = 0) then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_SbResponse
    return
end if

// The attachment data is contained within the JSON response.
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_SbResponse)
loo_Json.EmitCompact = 0

Write-Debug "Status code = " + string(loo_Http.LastStatus)
if loo_Http.LastStatus <> 200 then
    Write-Debug loo_Json.Emit()
    Write-Debug "Failed."
end if

// This is a sample JSON response.  The code for parsing and extracting/saving the attachments
// is shown below.

// 	{
// 	  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('chilkatsoft%40outlook.com')/messages('AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAADn68XtMop0TpsYJGpfKXY9AAAAwSju2wAAAA%3D%3D')/attachments",
// 	  "value": [
// 	    {
// 	      "@odata.type": "#microsoft.graph.fileAttachment",
// 	      "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAADn68XtMop0TpsYJGpfKXY9AAAAwSju2wAAAAESABAAft6wtbaSJU6sgQLi98DI0Q==",
// 	      "lastModifiedDateTime": "2017-05-10T00:30:51Z",
// 	      "name": "fishing.pdf",
// 	      "contentType": "application/pdf",
// 	      "size": 295680,
// 	      "isInline": false,
// 	      "contentId": "F861B218BE380F44B16933097FDDACFC@namprd20.prod.outlook.com",
// 	      "contentLocation": null,
// 	      "contentBytes": "JVBERi0xLjMKJcfsj6 ... yZWYKMjk0MzY5CiUlRU9GCg=="
// 	    },
// 	    {
// 	      "@odata.type": "#microsoft.graph.fileAttachment",
// 	      "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAL8huv8AAADn68XtMop0TpsYJGpfKXY9AAAAwSju2wAAAAESABAAXS7qXQ-iRUCYXnhJpN8Ihg==",
// 	      "lastModifiedDateTime": "2017-05-10T00:30:51Z",
// 	      "name": "testCert.cer",
// 	      "contentType": "application/octet-stream",
// 	      "size": 1674,
// 	      "isInline": false,
// 	      "contentId": "5E51FA33EF0F8941ACC8260395CB1A33@namprd20.prod.outlook.com",
// 	      "contentLocation": null,
// 	      "contentBytes": "MIIFRjCCBC6gAwIBA ... 7pt3C5w=="
// 	    }
// 	  ]
// 	}

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

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

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

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

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

    Write-Debug "name: " + loo_Json.StringOf("value[i].name")
    Write-Debug "contentType: " + loo_Json.StringOf("value[i].contentType")
    li_SizeInBytes = loo_Json.IntOf("value[i].size")
    Write-Debug "size: " + string(li_SizeInBytes)

    // Extract the data and save to a file.
    loo_SbSavePath.SetString("qa_output/")
    loo_SbSavePath.Append(loo_Json.StringOf("value[i].name"))

    loo_AttachData.Clear()
    loo_AttachData.AppendEncoded(loo_Json.StringOf("value[i].contentBytes"),"base64")
    loo_AttachData.WriteFile(loo_SbSavePath.GetAsString())

    // Get the last-modified date/time and set the output file's last-mod date/time..
    loo_LastMod.SetFromTimestamp(loo_Json.StringOf("value[i].lastModifiedDateTime"))
    loo_Fac.SetLastModified(loo_SbSavePath.GetAsString(),loo_LastMod)

    Write-Debug "----"

    i = i + 1
loop

// The output of the above loop is:
// 
// 	name: fishing.pdf
// 	contentType: application/pdf
// 	size: 295680
// 	----
// 	name: testCert.cer
// 	contentType: application/octet-stream
// 	size: 1674
// 	----
// 


destroy loo_Http
destroy loo_SbResponse
destroy loo_Json
destroy loo_SbSavePath
destroy loo_AttachData
destroy loo_LastMod
destroy loo_Fac