将Azure Blob从Azure Function附加到PowerShell中的电子邮件

Question

我有一个用PowerShell编写的Azure函数，其输入和输出绑定为相同的Blob存储，用于存储输入和输出csv文件。我能够从带有blob附件的函数发送电子邮件，但电子邮件具有文件类型而不是csv的附加文件。因此，我必须下载并手动添加.csv扩展名。如何发送附件中带有扩展名的输出csv文件？我的电子邮件代码如下：

# Send Email using SendGrid with file attachment
$username ="Username"
$password = ConvertTo-SecureString "Password" -AsPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential $username, 
$password
$SMTPServer = "smtp.sendgrid.net"
$emailFrom = "[e-mail]"
[string[]]$emailTo = "some-email"
$subject = "Sending sample email using SendGrid Azure and PowerShell"
$body = "This is sample email sent using Sendgrid account create on Microsoft 
Azure. The script written is easy to use."
$attachment = $outputBlob
Send-MailMessage -smtpServer $SMTPServer -Credential $credential -Usessl - 
Port 587 -From $emailFrom -To $emailTo -Subject $subject -Body $body - 
BodyAsHtml -Attachments $attachment

我用相同的代码创建了输出文件，但是我不确定如何将它附加到电子邮件中。

outputBlob是一个名为outputfile.csv的csv文件，它存储在与inputfile相同的容器中。我在这个脚本中创建了这个输出文件。我的容器名是“mycsvcontainer ”,我的blob在Azure函数绑定中的路径是“mycsvcontainer/output file . CSV”。blob的名称是outputBlob，我在上面的脚本中使用了它。类似的还有inputBlob的名字。

Answer 1

        $StorageAccountName = 'mystorageaccount'
        $StorageAccountKey = "storageaccountkey"
        $StorageContext = New-AzureStorageContext $StorageAccountName -StorageAccountKey $StorageAccountKey
        $FileName = 'filename'
        $ContainerName  = 'mycontainer'

        #Get attachment from blob storage
        $a = Get-AzureStorageBlobContent -Container $ContainerName -Blob $FileName -Context $StorageContext
        $attachment = $a.Name

        $MyCredential = "SendEMail" 
        $EmailBody = "Test"
        $Body = $EmailBody.replace("|","`n`r")
        $subject = "Tets"
        $userid= "[e-mail]"
        $emailTo = "[e-mail]"

        #Get the PowerShell credential 
        $Cred = Get-AutomationPSCredential -Name $MyCredential 


        Send-MailMessage `
        -To $emailTo `
        -Subject $subject `
        -Body $Body `
        -UseSsl `
        -Port 587 `
        -SmtpServer 'smtp.sendgrid.net' `
        -Attachments $attachment `
        -From $userid `
        -Credential $Cred `