Provision a Mobile App with a SQL Database
{"type": "microsoft.web/serverfarms", "apiversion": "2019-08-01", "name": "[variables('hostingplanname')]", "location": "[parameters('location')]", "sku": {"name": "[parameters('hostingplansettings').skuname]", "tier": "[parameters('hostingplansettings').tier]", "capacity": "[parameters('hostingplansettings').capacity]"}, "properties": {"numberofworkers": 1}}{"apiversion": "2019-08-01", "type": "microsoft.web/sites", "name": "[variables('uniqueappname')]", "location": "[parameters('location')]", "kind": "mobileapp", "properties": {"name": "[variables('uniqueappname')]", "serverfarmid": "[resourceid('microsoft.web/serverfarms", variables('hostingplanname'))]"}, "dependson": ["[variables('hostingplanname')]"], "resources": [{"apiversion": "2019-08-01", "name": "appsettings", "type": "config", "dependson": ["[variables('uniqueappname')]"], "properties": {"ms_mobileservicename": "[variables('uniqueappname')]", "ms_notificationhubname": "[variables('notificationhubname')]"}}, {"apiversion": "2019-08-01", "name": "connectionstrings", "type": "config", "dependson": ["[variables('uniqueappname')]", "[variables('notificationhubname')]", "[variables('databasename')]"], "properties": {"ms_tableconnectionstring": {"value": "[concat('data source=tcp:", reference(resourceid('microsoft.sql/servers", variables('databaseservername'))).fullyqualifieddomainname, ",1433;initial catalog=", variables('databasename'), ";user id=", parameters('sqlserveradminlogin'), "@", variables('databaseservername'), ";password=", parameters('sqlserveradminpassword'), ";')]", "type": "sqlserver"}, "ms_notificationhubconnectionstring": {"value": "[listkeys(resourceid('microsoft.notificationhubs/namespaces/notificationhubs/authorizationrules", variables('notificationhubnamespace'), variables('notificationhubname'), "defaultfullsharedaccesssignature'), "2017-04-01').primaryconnectionstring]", "type": "custom"}}}, {"apiversion": "2019-08-01", "type": "providers/links", "name": "microsoft.resources/sitetohub", "dependson": ["[variables('uniqueappname')]", "[variables('notificationhubname')]"], "properties": {"targetid": "[resourceid('microsoft.notificationhubs/namespaces/notificationhubs", variables('notificationhubnamespace'), variables('notificationhubname'))]"}}]} 