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}
⚠Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
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.
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