are you able to use a data flow expression for the parameter instead of a pipeline expression?
How do I pass an array parameter into an ADF Dataflow
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.
2 answers
Sort by: Most helpful
-
MarkKromer-MSFT 5,211 Reputation points Microsoft Employee
2020-11-23T21:48:19.963+00:00 -
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)