question

PeterSharp-4330 avatar image
0 Votes"
PeterSharp-4330 asked KranthiPakala-MSFT commented

Can we get a selector to choose trigger values which can be passed to a pipeline when triggered?

I have a blob creation trigger set and I wanted to be able to move the triggering file once it was processed. After a bit of hunting around, I found that we can pass the name of the file which triggered the storage event to the pipeline.

  1. Create a parameter on the pipeline

  2. Attach a storage trigger to the pipeline

  3. When prompted for 'Trigger run parameters', set the pipeline parameter created in step 1 to '@trigger().outputs.body.fileName'

  4. For pipeline tasks which you want to work with the triggering file, set the file of the dataset to the parameter from step 1

All well and good. So long as you set the container and directory appropriately, you can now work specifically with the triggering file.

My question here is, would it be possible to get a dropdown list of available variables here?

141175-image.png

It would really help make this obvious, and who knows what else might be exposed which could be useful for our pipelines.

That is a little more long term though, so in the interim, is there a resource somewhere that shows exactly what is available to use here?

Thanks,

azure-data-factory
image.png (16.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @PeterSharp-4330,

Welcome to Microsoft Q&A forum and thanks for posting your query.

Here is a public document where we have a list of System Variable that are supported by Azure Data Factory and Azure Synapse. You can use these variables in expressions when defining entities within either service.

Here is the reference document: System variables supported by Azure Data Factory and Azure Synapse Analytics

141549-image.png

141632-image.png


Please note that for Storage event trigger scope, if you are creating your pipeline and trigger in Azure Synapse Analytics, you must use @trigger().outputs.body.fileName and @trigger().outputs.body.folderPath as parameters. Those two properties capture blob information. Use those properties instead of using @triggerBody().fileName and @triggerBody().folderPath.

If you have any feedback regarding product feature request, we encourage you to please log a feedback directly from ADF UI as shown below:

141633-image.png

Hope this info helps. Do let us know if you have further query


  • Please don't forget to click on 130616-image.png and upvote 130671-image.png 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


image.png (64.7 KiB)
image.png (86.9 KiB)
image.png (67.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PeterSharp-4330,

Just checking to see if the above answer was helpful. If it answers your query, please do consider to click 130616-image.png and upvote 130671-image.png for the same as it can be beneficial for other community members. And, if you have any further query do let us know.

Thank you


0 Votes 0 ·

Hi @PeterSharp-4330,

We still have not heard back from you. Just wanted to check if the above info was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·