Lookup output parameter passing to execute another pipleline? RRS feed

  • Question

  • Through lookup i am extracting the date value  and  passing the lookup output to another pipeline through execute pipeline.

    In execute pipeline setting, i have created manually parameter called tcheck with value @activity('Lookup1').output.value and in invoke pipeline parameter i am passing date value under cw_items array i tried with @callingpipeline.parameter.tcheck and it's not working. Any advise how to pass the parameter?

    Tuesday, September 18, 2018 7:34 PM

All replies

  • Please check the lookup output reference at https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity

    I suppose you have the firstRow set to false so as to get the @activity('Lookup1').output.value. That would be an array item which can not be directly referred with @callingpipeline.parameter.tcheck as it becomes @activity('Lookup1').output.value.tcheck.

    Either you shall have a foreach activity to go through each row in that output value or you shall set firstRow as true if there is only one row returned.

    Wednesday, September 19, 2018 12:31 AM