how to deploy logic app arm template having azure sql connection

Question

i have logic app that gets connected to Azure sql to pull records and then update those records through http post call. i have exported that logic app tempate and trying deploy it another Resource group through azure devops (CI/ Cd), how should i set up the sql sonnection through paramaters .

Answer 1

Hi @Josh - You'll want to have an environment-specific parameters file for connections like SQL, and configure your DevOps pipelines such that it uses the right parameters file for the corresponding environment that it's running deployment to. The guidance in the following doc is important on how to structure your parameters files: Parameters for Consumption versus Standard logic app workflows

Once that part is completed, you'll then want to configure CI/CD with Azure DevOps: Deploy Logic Apps ARM templates via Azure DevOps

Lastly, here are some resources that may help:

• Official ARM sample with SQL connection parameters: https://github.com/Azure/azure-quickstart-templates/tree/master/quickstarts/microsoft.logic/logic-app-sql-proc
• Some "gotchas" from this thread: https://github.com/Azure/logicapps/issues/320

I hope this is helpful. I'm not sure how exactly your workflow is designed, and what its ensuing ARM export structure looks like but if you include them in your post (omitting private details), I'd be happy to help in a more direct way.