Azure-docs: Parametrizing Blob Storage Linked Service Is Not Working

Created on 9 Mar 2020  Â·  4Comments  Â·  Source: MicrosoftDocs/azure-docs

I tried to parameterized a blob storage linked service manually through the code editor.

{
    "properties": {
        "type": "AzureBlobStorage",
        "annotations": [],
        "typeProperties": {
            "connectionString": "DefaultEndpointsProtocol=https;AccountName=@{linkedService().Path};EndpointSuffix=core.windows.net;",
            "encryptedCredential": ""
        },
        "parameters": {
            "Path": {
                "type": "String"
            }
        }
    }
}

I pass the parameter value from the pipeline to the dataset and eventually to the linked service. The issue is that the linked service cannot capture the parameter value and it's always empty. I get this error upon running the pipeline that is using this linked service:

{code":"BadRequest","message":"No value provided for Parameter 'Path'","target":"pipeline/Delete files with Azure Data Factory/runid/1c29b7ba-36d2-4f38-a569-e381f33c8269","details":null,"error":null}

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

Pri2 cxp data-factorsvc forum triaged

Most helpful comment

Hi @mirsaeedi These kind of queries are best suited for forums with larger audience visibility. We have our engineers and others who are monitoring them and will be happy to help. One of our engineer is looking into in MSDN forum and will provide an update as soon as we have an update.

Since it is being tracked in MSDN, we will now proceed to close this thread. In case if you think that the document needs an update, please feel free to reopen the issue and tag me in your response. We will be glad to continue the discussion.

MSDN thread: https://social.msdn.microsoft.com/Forums/en-US/4fe557e3-fb06-477a-989d-164bfe390f65/parametrizing-blob-storage-linked-service-is-not-working?forum=AzureDataFactory

All 4 comments

Can you post this question on our MSDN forum? Github issues are generally for doc related bugs or improvements

I thought it might be a bug because in the document it had been mentioned that it's possible to paramterized linked servers through the code editor.

You can parameterize linked services through the code editor. The MSDN forum will allow our customer experience team to investigate the issue and determine if the doc is misleading or not.

The issues looks to be in the passing of the parameter from the linked service, rather than the linked service definition

Hi @mirsaeedi These kind of queries are best suited for forums with larger audience visibility. We have our engineers and others who are monitoring them and will be happy to help. One of our engineer is looking into in MSDN forum and will provide an update as soon as we have an update.

Since it is being tracked in MSDN, we will now proceed to close this thread. In case if you think that the document needs an update, please feel free to reopen the issue and tag me in your response. We will be glad to continue the discussion.

MSDN thread: https://social.msdn.microsoft.com/Forums/en-US/4fe557e3-fb06-477a-989d-164bfe390f65/parametrizing-blob-storage-linked-service-is-not-working?forum=AzureDataFactory

Was this page helpful?
0 / 5 - 0 ratings