locked
Dynamically get lookup output property by parameter RRS feed

  • Question

  • Is there anyway to dynamically set the output field name required by using a parsed parameter value (name).

    Eg. activity('lup_CRM').output.firstRow['@{pipeline().parameters.SourceAttribute}']
    Parameter: 
    SourceAttribute (string) = "accounted"

    This should show : activity('lup_CRM').output.firstRow['accountid']

    Tuesday, February 5, 2019 11:55 PM

All replies

  • Hi,

    I don't think there's a direct way to do this. However you can use a custom activity in conjunction with your Lookup activity to parse the result and use it in further activities.

    To read more about custom activities, please refer :

    https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-dotnet-custom-activity

    Hope this helps.


    MSDN

    Thursday, February 7, 2019 12:00 PM