title: Use Azure ARM Template to create Service Bus Topic Subscription with Sql Filter?
body: <p>I've been able to figure out how to setup an Azure ARM Template that creates/manages an Azure Service Bus Namespace, Topic and Subscription to receive all messages. However, the Microsoft documentation is extremely lacking still on ARM Tempates, and I am unable to figure out how to define a SqlFilter for the Subscription within the template that you can manage using the .NET SDK.</p>
  
  <p>Does anyone know how to add a Sql Filter to a Service Bus Topic Subscription within an ARM Template?</p>
  
  <p>Here's a link to the ARM Template I have for creating the Service Bus Topic and Subscription without Sql filter:</p>
  
  <p><a href="https://github.com/crpietschmann/azure-quickstart-templates/blob/101-servicebus-topic-subscription/101-servicebus-topic-subscription/azuredeploy.json" rel="nofollow">https://github.com/crpietschmann/azure-quickstart-templates/blob/101-servicebus-topic-subscription/101-servicebus-topic-subscription/azuredeploy.json</a></p>
  
  <p>Also, here's the source of the ARM Template I'm referring to:</p>
  
  <pre><code>{
    "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "parameters": {
      "serviceBusNamespaceName": {
        "type": "string",
        "metadata": {
          "description": "Name of the Service Bus Namespace"
        }
      },
      "serviceBusTopicName": {
        "type": "string",
        "metadata": {
          "description": "Name of the Service Bus Topic"
        }
      },
      "serviceBusTopicSubscriptionName": {
        "type": "string",
        "metadata": {
          "description": "Name of the Service Bus Topic Subscription"
        }
      }
    },
    "variables": {
      "sbVersion": "2015-08-01"
    },
    "resources": [
      {
        "apiVersion": "[variables('sbVersion')]",
        "name": "[parameters('serviceBusNamespaceName')]",
        "type": "Microsoft.ServiceBus/namespaces",
        "location": "[resourceGroup().location]",
        "properties": {
        },
        "resources": [
          {
            "apiVersion": "[variables('sbVersion')]",
            "name": "[parameters('serviceBusTopicName')]",
            "type": "Topics",
            "dependsOn": [
              "[concat('Microsoft.ServiceBus/namespaces/', parameters('serviceBusNamespaceName'))]"
            ],
            "properties": {
              "path": "[parameters('serviceBusTopicName')]"
            },
            "resources": [
              {
                "apiVersion": "[variables('sbVersion')]",
                "name": "[parameters('serviceBusTopicSubscriptionName')]",
                "type": "Subscriptions",
                "dependsOn": [
                  "[parameters('serviceBusTopicName')]"
                ],
                "properties": {
                },
                "resources": [
                ]
              }
            ]
          }
        ]
      }
    ],
    "outputs": {
    }
  }
  </code></pre>