unable to set azure sql dataase connection in logic app trhough ARM

Josh 46 Reputation points
2023-02-23T21:12:21.9566667+00:00

i have created a API connection through ARM template and in Second task i'm calling that API connection to set up sql connection. but it is not working.

API connection is successfully created , in the logic app it not showing up

API connetion ARM template

   resources": [
       {
         "type": "Microsoft.Web/connections",
         "apiVersion": "2016-06-01",
         "location": "centralus",
         "name": "DataBase",
         "properties": {
           "api": {
             "id": "[concat(subscription().Id,'/providers/Microsoft.Web/locations/','centralus','/managedApis/sql')]"
           },
           "displayName": "SQLDataBase",
           "parameterValues": {
             "server": "[parameters('SqlServerr')]",
             "database": "[parameters('database')]",
             "username": "[parameters('username')]",
             "password": "[parameters('password')]"
           }
         }
       }
     ],  "variables": {}

Connetcion in logic app**

"parameters": { "$connections": { "value": { "DataBase": { "connectionId": "[concat(subscription().id,'/resourceGroups/',resourceGroup().id,'/providers/Microsoft.Web/connections/DataBase')]", "connectionName": "DataBase", "id": "[concat(subscription().id,'/providers/Microsoft.Web/locations/centralus/managedApis/sql')]" } } } }

Azure Logic Apps
Azure Logic Apps

An Azure service that automates the access and use of data across clouds without writing code.


1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.