question

MikeWright-5141 avatar image
0 Votes"
MikeWright-5141 asked PRADEEPCHEEKATLA-MSFT commented

Incorporating Trigger Parameters at the Start of a Data Factory Pipeline

I am creating a custom Data Factory Pipeline trigger from a custom Event Grid event. I have created the trigger and the pipeline, and the intent is to pass the values from the trigger to the parameters on the pipeline. They are some ID information that is not included in the CSV files in blob storage I ultimately wish to copy.

However, when I try and map the trigger parameters to the pipeline (while adding the trigger to the pipeline):

sellerId int = @triggerBody().event.data.sellerId

I receive an error on publishing that it must be a string. I tried wrapping it in the expression int() and that didn't work either. I suspect there is some minor syntax discrepancy in play here, and any help appreciated.

Thank you.

azure-data-factoryazure-event-grid
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

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

Hello @MikeWright-5141,

Welcome to Microsoft Q&A platform.

Custom data payload what we get from Event grid will be in string type. Hence create your parameters with string Type to resolve issue.

Note: If you need to type caste value in parameter to int in later point of time during execution of pipeline, then use @int() function to achieve same.

Hope this helps. Do let us know if you any further queries.


Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

· 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.

Thank you, that did the trick.

1 Vote 1 ·

Hello @MikeWright-5141,

Glad to know it helped.

0 Votes 0 ·