Azure logic app on premise sql stored proc with output parameter limitation

cenko2 41 Reputation points
2023-10-02T17:39:33.87+00:00

We have an Azure Logic App with an Execute stored procedure (V2) action connected to an on-premise SQL server calling a stored procedure with input and output parameters. The output parameter is a JSON nvarchar(max). When executed, the Execute stored procedure (V2) action output result returns empty and we found out about a limitation in invoking a stored procedure in on-premise SQL Server with an output parameter.

User's image

User's image

Has anyone encountered this and is there a work around to this issue? Any feedback is appreciated.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,855 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Urnun 9,676 Reputation points Microsoft Employee
    2023-10-27T02:45:15.85+00:00

    Hello @cenko2 - Sorry for the late reply. As you've already discovered, this is a known limitation. The connector support team recommends altering the stored procedure to return the data in the payload rather than through an output parameter which can be accomplished by wrapping the stored procedure in a new one.

    Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.