Any plans for parameter support for the Azure Function Linked Service?

Brian Jones 31 Reputation points
2021-09-27T18:05:47.177+00:00

In several of the other Linked Services, you can pass in parameters that can be used in the dynamic content for URLs, Secret Names, etc.

Azure Function does not seem to support this currently. Is there a workaround or plans to support this feature?

Thanks in advance.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,071 questions
{count} vote

2 additional answers

Sort by: Most helpful
  1. Elliott Johnson 11 Reputation points
    2021-12-02T19:32:29.803+00:00

    Just wanted to point out that the provided custom answer is also not a correct answer, at least as far as I can tell. It is possible to parameterize the Azure Functions Linked Service through the above method, but I believe it's impossible to actually pass parameters to the linked service through an Azure Functions action. The GUI definitely doesn't give you the option to, so the only way to do it would be to manually change the JSON spec of your pipeline. For example:

    "name": "Merge Entities",  
        "description": "Get data from SQL Server and merge it into the Azure Table.",  
        "type": "AzureFunctionActivity",  
        "typeProperties": {  
            "functionName": "CopyAmenitiesFromAzureSqlToAzureTable",  
            "method": "GET"  
        },  
        "linkedServiceName": {  
            "referenceName": "func_dw_prod_centralus_merge",  
            "type": "LinkedServiceReference"  
        }  
    

    According to the spec, the place to do this would be in the linkedServiceName section by adding a "parameters" key. For example:

            "linkedServiceName": {  
                "referenceName": "func_dw_prod_centralus_merge",  
                "type": "LinkedServiceReference",  
                "parameters": {  
                    "environment": "@pipeline().globalParameters.environment"  
                }  
            }  
    

    Unfortunately, when saving the pipeline, it automatically strips out the "parameters" tag we've added, leaving us right back where we started. So this is either impossible, or the method to do it isn't documented... like everything else in Azure.

    2 people found this answer helpful.
    0 comments No comments

  2. PRADEEPCHEEKATLA-MSFT 84,936 Reputation points Microsoft Employee
    2021-09-28T06:58:44.447+00:00

    Hello @Brian Jones ,

    Welcome to the Microsoft Q&A platform.

    Yes, Azure Function does not support parameterization.

    Currently, these are the linked service types are supported for parameterization.

    135806-image.png

    For more details, refer to Parameterize linked services in Azure Data Factory and Azure Synapse Analytics.

    Thank you for sharing the feedback [parameter support for the Azure Function Linked Service]. We appreciate it. We will share and elevate your feedback with the Azure Data Factory/Synapse Analytics product team.

    Regarding service general availability, I would suggest to keep an eye on Azure updates.

    Azure updates provide information about important Azure product updates, roadmap, and announcements.

    Hope this will help. Please let us know if any further queries.

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

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators