How do I pass an array parameter into an ADF Dataflow

Mike McLean (Shell) 1 Reputation point
2020-11-20T13:03:51.64+00:00

See here for full details: https://stackoverflow.com/questions/64929282/how-to-pass-an-array-parameter-into-an-adf-dataflow

But roughly speaking, I'm trying to pass in values to an int array parameter of a (Mapping) dataflow.

The pipeline "validates", but when I run it, it says:
{
"StatusCode": "DFExecutorUserError",
"Message": "Job failed due to reason: at Filter 'IdentifyTradesToDelete'Parameter 'TradeIdentityIds'(Line 35/Col 22): Parameter value for TradeIdentityIds missing",
"Details": "at Filter 'IdentifyTradesToDelete'Parameter 'TradeIdentityIds'(Line 35/Col 22): Parameter value for TradeIdentityIds missing"
}

Even though the debug logs confirm that values WERE passed in, from the pipeline.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,808 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. MarkKromer-MSFT 5,211 Reputation points Microsoft Employee
    2020-11-23T21:48:19.963+00:00

    are you able to use a data flow expression for the parameter instead of a pipeline expression?


  2. Ranjan Pradeep 1 Reputation point
    2020-11-25T21:14:56.393+00:00

    dataflow expects array parameters to be encased in quotes (as a string) while pipeline array parameters are not encased as such. To fix this issue while using pipeline parameters you can try encasing them in the @string function.

    That is, instead of using @pipeline().parameters.parameterName use @string(pipeline().parameters.parameterName)

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.