In the file created by the pipeline run of synapse, Can I attach a file with errors, or export the contents of a portion of a file and send it via email using a logic application?

NishimuraChinatsu-9854 756 Reputation points
2023-04-05T10:40:48.54+00:00

In the file created by the pipeline run of synapse, Can I attach a file with errors, or export the contents of a portion of a file and send it via email using a logic application?

I know how to send an email with the logic application in synapse, but I don't know how to attach a file or export the contents of a file, so if possible, could you please tell me how to do that?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,891 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,451 questions
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2023-04-11T01:11:40.82+00:00

    Hi @NishimuraChinatsu-9854 , Thanks for using the forum and posting the query.

    As per my understanding you would like to send the either the file as an attachment or the contents of a file as an email using logic apps. Please correct if my understanding is not clear. For sending the contents of the files as an email using logic apps, you may follow the steps described in this SO thread:
    Azure Logic app : How to Send an Email with one or more attachments after getting the content from Blob storage?

    Here is a useful demonstration video from a community volunteer: How to Email File from Azure Blob Storage By using Azure Logic Apps Azure Logic Apps Tutorial 2021

    In case if you want to read the file content and only pass a certain part of the content, then you will have to use a Web activity and get the file content using Azure Storage Blob APIs and then use pipeline expression to transform or select a particular portion of the content from the web activity response and then pass that particular portion of content to Azure Logic in the body section which will send an email.

    Hope this info helps.


0 additional answers

Sort by: Most helpful