VS Logic Apps: SQl conenction using Gateway not deployable

Raminder Chima 41 Reputation points

I am using VS2019 to develop Logic Apps. I need to connect to On-Premise SQL server for SQL Task. I am using Gateway to configure the connection.
Whenever I deploy the Logic App to Azure, the connection does not work. I have to delete and recreate it. I have tried specifying connection details during deployment manually as well as using parameter file.

Currently, due to this issue, I am forced to design Logic Apps in Azure designer which is less then ideal.

Thanks for the help in advance.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,982 questions
{count} votes

Accepted answer
  1. Pramod Valavala 20,611 Reputation points Microsoft Employee

    @Raminder Chima I've tried this out and looks like the ARM Template generated doesn't have the gateway and authType set for the API Connection resources.

    As described in this blog, adding a value like this under parameterValues should do the trick

       "authType": "basic",  
       "gateway": {  
           "id": "/subscriptions/{{subscriptionId}}/resourceGroups/{{reosurceGroupName}}/providers/Microsoft.Web/connectionGateways/{{On-Premise DatagatewayName}}"  

0 additional answers

Sort by: Most helpful