如何通过Azure CLI直接传入Properties字符串创建Azure Data Factory SQL链接服务

我尝试通过Azure CLI命令创建Azure Data Factory（ADF）的链接服务，先通过Azure Portal抓包得到请求JSON：

{"name": "sqltest_script","properties": {"annotations": [],"type": "SqlServer","typeProperties": {"connectionString": "Integrated Security=False;Data Source=placeholderServer;Initial Catalog=placeholderDB;User ID=placeholderUser;Password=placeholderPass"},"connectVia": {"referenceName": "placeholderRef","type": "IntegrationRuntimeReference"}}}

根据官方文档要求，创建链接服务时需将Properties以字符串形式传入，于是我提取了其中的type、typeProperties和connectVia部分，按示例转义引号后得到字符串：

"{\"type\": \"SqlServer\",\"typeProperties\": {\"connectionString\": \"Integrated Security=False;Data Source=placeholderServer;Initial Catalog=placeholderDB;User ID=placeholderUser;Password=placeholderPass\"},\"connectVia\": {\"referenceName\": \"placeholderRef\",\"type\": \"IntegrationRuntimeReference\"}}"

将该字符串加入CLI命令：

az datafactory linked-service create --factory-name "placeholderFactory" --properties "{\"type\": \"SqlServer\",\"typeProperties\": {\"connectionString\": \"Integrated Security=False;Data Source=placeholderServer;Initial Catalog=placeholderDB;User ID=placeholderUser;Password=placeholderPass\"},\"connectVia\": {\"referenceName\": \"placeholderRef\",\"type\": \"IntegrationRuntimeReference\"}}" --name "scriptTest" --resource-group "placeholderResource"

执行命令时触发ParserError，我判断是Properties字符串格式有误，但无法确定修正方式，查阅更多文档后仍未解决。

更新 #

我已通过传入JSON文件的方式成功创建链接服务，createProperties.json文件内容如下：

{"type": "SqlServer","typeProperties": {"connectionString": "Integrated Security=False;Data Source=placeholderServer;Initial Catalog=placeholderDB;User ID=placeholderUser;Password=placeholderPass"},"connectVia": {"referenceName": "placeholderRef","type": "IntegrationRuntimeReference"}}

使用的命令为：

az datafactory linked-service create --factory-name "placeholderFactory" --properties createProperties.json --name "scriptTest" --resource-group "placeholderResource"

我仍需解决直接在命令中传入Properties字符串的问题

内容的提问来源于stack exchange，提问作者Jgreene44