(Excel) MedTunnel: Get Message Attachment

See more MedTunnel Examples

Get a specific attachment of a message. The MessageId and AttachmentId are obtained from the "Get Mailbox Messages" example.

For more information, see https://server.medtunnel.com/apidocs/html/M_MedTunnelMsg_Controllers_MessageController_GetAttachment.htm

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl -X GET -k 
'         -H "Authorization:PutAuthorizationTokenHere" 
'         https://server.medtunnel.com/medtunnelmsg/api/Message/GetAttachment?messageid=989448&attachmentid=424857&setreadflag=false

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

http.SetRequestHeader "Authorization","PutAuthorizationTokenHere"

' The messageId and attachmentId are contained in the response from reading the mailbox messages.
Dim success As Boolean
success = http.SetUrlVar("messageId","989448")
success = http.SetUrlVar("attachmentId","424857")
success = http.SetUrlVar("setReadFlag","false")

' Download the attachment data into bd.
Dim bd As Chilkat.BinData
Set bd = Chilkat.NewBinData
success = http.QuickGetBd("https://server.medtunnel.com/MedTunnelMsg/api/Message/GetAttachment?messageid={$messageId}&attachmentid={$attachmentId}&setreadflag={$setReadFlag}",bd)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


respStatusCode = http.LastStatus
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastHeader
    ' For errors, the response body contains an error message instead of the actual attachment data.
    Debug.Print "Response Body:"
    Debug.Print bd.GetString("utf-8")
    Debug.Print "Failed."
    Exit Sub
End If

' Save the attachment data.
' The attachment filename is also contained in the response from reading the mailbox messages.
success = bd.WriteFile("qa_output/starfish.jpg")
If (success <> True) Then
    Debug.Print "Failed to save attachment file."
Else
    Debug.Print "Success."
End If