Hi All, I have a pipeline with object type parameter that is used to parameterize Additional columns property in Copy activity. The value of the object parameter is: [{"name":"ExtractDate","value":"2020-12-14"}] This pipeline is getting executed successfully. But when i am executing this pipeline from another pipeline and providing the same value in Object type parameter, pipeline is failing with the following error: Message=The value of property 'additionalColumns' is in unexpected type 'IList`1'. How to handle this scenario?

Hi @Priya Jha , Thank you for asking this question. In this case, you have to create an objectType pipeline parameter and pass that parameter to the child pipeline (see the screenshots below). Hope this helps. If it does, please don't forget to " accept the answer " and " up-vote "! Thank you!

Error when Object Type parameter is passed through another pipeline

Accepted answer

Nasreen Akter 10,791 Reputation points

2020-12-18T15:47:25.267+00:00

Hi @Priya Jha ,

Thank you for asking this question. In this case, you have to create an objectType pipeline parameter and pass that parameter to the child pipeline (see the screenshots below).

Hope this helps. If it does, please don't forget to "accept the answer" and "up-vote"! Thank you!
Please sign in to rate this answer.

2 people found this answer helpful.
Priya Jha 871 Reputation points

2020-12-21T04:33:30.49+00:00

HI @Nasreen Akter ,

Thank you for your reply and your solution worked.

But i want to further parameterize the value that is passed to another pipeline.

The Actual value for object type parameter is [{"name":"ExtractDate","value":"2020-12-14"}]
But i have an activity that extracts some ExtractDate values and i want to pass that value instead of "2020-12-14"

Can this scenario be achieved?

Nasreen Akter 10,791 Reputation points

2020-12-21T13:22:39.597+00:00

Hi @Priya Jha ,

you can try to use ForEach Activity in the pipeline and for each value use @item() (see the link for details). Please don't forget to "accept the answer" and "up-vote"! Thank you!

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity#:~:text=The%20ForEach%20Activity%20defines%20a,looping%20structure%20in%20programming%20languages.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error when Object Type parameter is passed through another pipeline

0 additional answers

Your answer