On-prem SQL execute stored procedure in Logic App Standard

Question

When executing a stored procedure using an in-app connector in Logic App Standard (Stateful), the procedure does not return data and continues running, even though it is successful according to application insights. However, if I try the same logic using a Function, it works. Also it's possible to get smaller amount of data using parameters so connection is ok.

I have configured the ServiceProviders.Sql.QueryTimeout to 30 minutes.

Answer 1

I have created a store procedure to retrieve the name from database using Id parameter.

CREATE PROCEDURE GetUserNameByID
    @UserID INT
AS
BEGIN
    SET NOCOUNT ON;

    SELECT Name
    FROM [dbo].[Test] 
    WHERE Id = @UserID;
END;

workflow-

I am able to get the value in output.

Try to check connection string, you will get the output.