Apr 5, 2020 · My goal was to define a LogicApp what can be called via HTTP request, query a SQL database with a select count query and return the result as text on the HTTP response body. This is how my workflow looks like:

Feb 21, 2022 · My logic app works when I do "get rows" action for postgresql it returns all 12 rows in my user table. Is it possible to do a where clause so I don't have to select all rows. An Azure service that automates the access and use of data across clouds without writing code.

Dec 26, 2020 · I run this simple query in Logic App using the "Execute a SQL query (V2)" connector to find out if a number exists in my table. select count(*) from users where user_number='724-555-5555'; If the number exist, I get this JSON , but somehow I cant parse it.

Aug 6, 2024 · This how-to guide shows how to access your SQL database from a workflow in Azure Logic Apps with the SQL Server connector. You can then create automated workflows that run when triggered by events in your SQL database or in other systems and run actions to manage your SQL data and resources.

Apr 19, 2018 · I am trying to implement several Azure Logic Apps that query/update an Azure SQL Server Database. The queries return either one value or a table with several rows. I prefer not to create stored procedures, but instead use the 'Execute SQL Query' Connector.

Dec 25, 2019 · Instead of using GetRows, you can use Execute Query or Execute Stored Procedure to get the Result set and then use Action control to iterate over the result set and send an email then. Here is an example that you can consider.

Apr 1, 2025 · To construct a single output such as a JSON object from multiple inputs, use the action named Compose. Your inputs can have various types such as integers, Booleans, arrays, JSON objects, and any other native type that Azure Logic Apps supports, for …

Data Available Query | For trigger support | SQL statement to determine whether any data is available for polling a SQL Server database table. This should return a numeric value representing the number of rows of data available. Example: …

Jul 23, 2020 · Learn to set up On-Premises Gateways and the Azure Logic App that uses the gateway to connect and return customer data using an HTTP request & response. Skip Navigation Menu

Using a stored procedure to retrieve data from SQL in a Logic App is a powerful way to manage complex queries and operations. Here’s a step-by-step guide to help you set this up: