How do I pass a parameter to a linked service when using it in the External Call Transformation?

Question

How do I pass a parameter to a linked service when using it in the External Call Transformation?

Quentin Baker 21

I want to make sure I am quite clear here: I know how to pass parameters to linked services when they are used as data sources, etc. There is a panel for "linked service properties" where you can pass an env var or similar data to it, like in this screenshot:

My problem is that when using a parameterized service as an external call transformation (https://learn.microsoft.com/en-us/azure/data-factory/data-flow-external-call) This panel does not exist.

How do I pass a parameter to it in this instance?

ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2022-02-16T16:51:26.317+00:00

Hi @Quentin Baker ,

Thank you for posting query in Microsoft Q&A Platform.

I am able to repro this case. I created a linked service which has parameters in it. When I selected that linked service in External call transformation, I am not seeing view to enter values or pass values to linked service parameters.

I am checking more on this internally. I will share updates once I hear back.
Quentin Baker 21 Reputation points

2022-02-16T19:08:36.803+00:00

Thanks for the quick response. I appreciate it!
Jon Cutting 0 Reputation points

2023-03-07T14:14:06.5033333+00:00

@ShaikMaheer-MSFT as a year has now passed since your last comment, and this was being escalated internally, and to be honest it's a serious limitation when building out a re-usable set of components in ADF, would you be able to share any updates for us? Thanks.

Accepted answer

0 additional answers

Your answer

ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2022-02-16T16:51:26.317+00:00

Hi @Quentin Baker ,

Thank you for posting query in Microsoft Q&A Platform.

I am able to repro this case. I created a linked service which has parameters in it. When I selected that linked service in External call transformation, I am not seeing view to enter values or pass values to linked service parameters.

I am checking more on this internally. I will share updates once I hear back.
Quentin Baker 21 Reputation points

2022-02-16T19:08:36.803+00:00

Thanks for the quick response. I appreciate it!
Jon Cutting 0 Reputation points

2023-03-07T14:14:06.5033333+00:00

@ShaikMaheer-MSFT as a year has now passed since your last comment, and this was being escalated internally, and to be honest it's a serious limitation when building out a re-usable set of components in ADF, would you be able to share any updates for us? Thanks.

Answer 1

ShaikMaheer-MSFT 38,516 Microsoft Employee

Hi @Quentin Baker ,

Thank you for posting query in Microsoft Q&A Platform.

As per my understanding, requirement is more related to using parameterized linked service in External call transformation. Feel free to correct if its my the case.

As mentioned in above comment, I reproduced this issue and found that external call transformation not allowing to pass values to linked service parameters. I reached internal team to confirm same. Its confirm that at this moment external call transformation not supports linked service with parameters. PG will be considering this to implement and rollout.

I will be updating thread once feature gets develop and releases.

Hope this helps. Please let us know if any further queries.

-------------

Please consider hitting Accept Answer. Accepted answers helps community as well.

Quentin Baker 21 Reputation points

2022-02-17T21:39:30.807+00:00

Thant is correct, our concern is using the service and passing it parameters from the context of an External Call transformation. It may be more accurate to say the issue is with the External Call transform than with the linked service; it depends on how it is designed.
ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2022-02-21T17:05:41.78+00:00

Yes @Quentin Baker as rightly pointed its limitation with External call transformation. At this moment its not supporting parameterized linked services. Internal team working on having this feature implemented. I will update thread comments once its done.

-------
Please consider hitting Accept Answer. Accepted answers helps community as well.
ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2022-02-23T14:19:20.007+00:00

Hi @Quentin Baker , We have escalated this internally to have implemented asap. I will be closing monitoring this and once functionality implemented will try to update thread as well. Thank you.
ShaikMaheer-MSFT 38,516 Reputation points Microsoft Employee

2022-03-08T08:04:18.097+00:00

Hi @Quentin Baker - I encourage you to also log this feedback item here and up-vote same. PG will closely monitor feedbacks and consider them for future releases.

Please feel free to share feedback link item once you create. So that other community members who are looking for same can up-vote on it.

Share via

How do I pass a parameter to a linked service *when using it in the External Call Transformation*?

0 additional answers