From the course: Building a Web Application on Microsoft Azure

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Modifying the existing Logic App to add a custom SQL Query

Modifying the existing Logic App to add a custom SQL Query - Azure Tutorial

From the course: Building a Web Application on Microsoft Azure

Start my 1-month free trial Buy for my team

Modifying the existing Logic App to add a custom SQL Query

“

- [Instructor] We need to modify this Azure Logic App to send the breed name to Melissa. So let's jump right in. Let's click on Edit. And here, I need to add an additional action. Since this when an item is created trigger is only telling me about what happened to the pets table. However, the breed name is inside the breeds table. That's why we need an additional action. So let's click on this command and then add an action. And here, I want to select SQL Server. Specifically I want to use execute a SQL query, and let's select the SQL Server, the database, and finally the query. So I can type the entire query here. One important thing is that, as you can see, there's no need for me to configure the SQL Server again since those configurations are stored in the same resource group. Okay, so let's specify the query, which I happen to have here in the notepad to expedite this process. So as you can see, I'm obtaining name…

Contents