'privacySetting parameter value is not part of the allowed values - SQL Connection for Azure LogicApps

I have VS2019 and trying to create Logic Apps which includes SQL connection. I deploy this LogicApps with Azure DevOps and getting error. I do not what is purpose of sql_1_privacySetting and what are possible values I could use. Specially I'm wondering how to set values in ARM.

ERROR:

##[error]Deployment template validation failed: 'The provided value 'Microsoft.WindowsAzure.ResourceStack.Frontdoor.Common.Entities.TemplateGenericProperty`1[Newtonsoft.Json.Linq.JToken]' for the template parameter 'sql_1_privacySetting' at line '1' and column '1605' is not valid. The parameter value is not part of the allowed value(s): 'None,Private,Organizational,Public'.'.

LogicApp.parameters.json

"sql_1_encryptConnection": {
  "value": false
},
"sql_1_privacySetting": {
  "value": ""
},

LogicApp.json

{
  "type": "MICROSOFT.WEB/CONNECTIONS",
  "apiVersion": "2018-07-01-preview",
  "name": "[parameters('sql_1_Connection_Name')]",
  "location": "[parameters('logicAppLocation')]",
  "properties": {
    "api": {
      "id": "[concat(subscription().id, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'sql')]"
    },
    "displayName": "[parameters('sql_1_Connection_DisplayName')]",
    "parameterValues": {
      "server": "[parameters('sql_1_server')]",
      "database": "[parameters('sql_1_database')]",
      "username": "[parameters('sql_1_username')]",
      "password": "[parameters('sql_1_password')]",
      "encryptConnection": "[parameters('sql_1_encryptConnection')]",
      "privacySetting": "[parameters('sql_1_privacySetting')]",
      "sqlConnectionString": "[parameters('sql_1_sqlConnectionString')]"
    }
  }
}
azureazure-devopsazure-logic-appsazure-resource-manager


Solution 1:[1]

In my LogicApp.json it has these as the possible privacySetting allowed values:

"sql_1_privacySetting": {
  "type": "string",
  "metadata": {
    "description": "Privacy Setting"
  },
  "allowedValues": [
    "None",
    "Private",
    "Organizational",
    "Public"
  ]
},

Solution 2:[2]

Set the values as follows if you want it blank

"sql_1_privacySetting": {
  "value": "None"
}

Options are

    "None",
    "Private",
    "Organizational",
    "Public"

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 John Mann
Solution 2 Sabel

Related Questions