Email Notification Issue

Question

Hello Team,

For few pipelines i have configured the email notification. Once the files come and store in the Multiple Container. The Email will send the Notfication.Even i need to show the Path of the files stored in container. How it can be done dynamically.

I have added dynamic content :

{"message":"This is a custom dynamic message from your pipeline with run ID @{pipeline().RunId}.",
"dataFactoryName":"@{pipeline().DataFactory}",
"pipelineName":"@{pipeline().Pipeline}",
"pipelineRunId":"@{pipeline().RunId}",
"Receiver":"@{pipeline().parameters.Receiver}",
"Status": "Success",
"Time":"@{pipeline().TriggerTime}"
}

Ouput received in email :

Data Factory Name: df-dataservices-dev01
Pipeline Name: PL_Pipeline1
Pipeline Run Id: d568f528-eee8-4af7-98b3-fb58e1c6dd81
Message: This is a custom dynamic message from your pipeline with run ID d568f528-eee8-4af7-98b3-fb58e1c6dd81.
Status: Success
Blobpath: "https://Blobsotragename.blob.core.windows.net/containername /FileName1.csv",
Time: 2022-03-01T05:30:00.0658731Z

The FileName1.csv" I need to pass the dynamically. So that for specific pipelines it must mention the Path's and filenames dynamically.

Please advise.

Regrds
RK

Answer 1

Hello @Rohit Kulkarni ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is you want to retrieve "Blobpath", a full URL of some item in your blob storage. However, you have left out what this comes from. My instincts suggest this is in relation to a storage event trigger. If this is not the case, you will need to tell me where you want to tell me more.
Is Blobpath the source of a copy activity? Is Blobpath the sink of a copy activity? Is Blobpath something else?

If Blobpath comes from a storage event trigger, you will need to add a pipeline parameter, then go to your trigger and define the parameters as shown in step-11 of how-to-create-event-trigger. The storage account and container are part of the trigger, and so are not dynamic.

Please do let me if you have any queries.

Thanks
Martin

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators