CDS链接服务动态json

Question

对于CDS链接的服务，没有办法(从UI(引入参数。但是Microsoft确实在高级设置中为我们提供了方便的"以Json格式指定动态锥"复选框。

有人有这样转换标准链接服务json的例子吗：

{
"name": "cdsCorpPlan",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"annotations": [],
"type": "CommonDataServiceForApps",
"typeProperties": {
"deploymentType": "Online",
"serviceUri": "https://blahblah-dev.crm.dynamics.com",
"authenticationType": "AADServicePrincipal",
"servicePrincipalCredentialType": "ServicePrincipalKey",
"servicePrincipalId": "xxx-xxx-xxx-xxx-xxxxxxxx",
"encryptedCredential": "ew0KICAiVmVyc2lvbiI6ICIyMDE3LTExLTMwIiwNCiAgIlByb3RlY3Rpb25Nb2RlIjogIktleSIsDQogICJTZWNyZXRDb250ZW50VHlwZSI6ICJQbGFpbnRleHQiLA0KICAiQ3JlZGVudGlhbElkIjogIkFERi1MUC1PUkNIRVNUUkFUT1ItREVWX2M0MDYzYjEzLTBkNjYtNDQ2Yi04NjFkLTYyYjJkNjI1MjNlYiINCn0="
}
}
}

转换为参数化版本？

具体来说，如果我想参数化serviceUri和服务主体键，语法会是什么？

Answer 1

我想我想通了。对于那些感兴趣的人：

{
"name": "cdsCorpPlanTCO",
"properties": {
"parameters": {
"SecretName": {
"type": "string"
}
},
"type": "CommonDataServiceForApps",
"typeProperties": {
"deploymentType": "Online",
"serviceUri": {
"type": "AzureKeyVaultSecret",
"store": {
"referenceName": "MyKeyVault",
"type": "LinkedServiceReference"
},
"secretName": {
"value": "@linkedService().SecretName",
"type": "Expression"
}
},
"authenticationType": "AADServicePrincipal",
"servicePrincipalCredentialType": "ServicePrincipalKey",
"servicePrincipalId": "xxxx-xxxx-xxxx-xxxx-xxxxxxxx",
"servicePrincipalCredential": {
"type": "AzureKeyVaultSecret",
"store": {
"referenceName": "MyKeyVault",
"type": "LinkedServiceReference"
},
"secretName": "SPkey"
}
},
"annotations": []
},
"type": "Microsoft.DataFactory/factories/linkedservices"
}