SQL Server - Execute stored procedures action show list of table-valued function
When I connect a "SQL Server - Execute stored procedures" action to an on-premises database, it will return a list of table-valued functions. Is this by design? If yes, why name this action "Execute stored procedure"?
And also if yes, this action will not return a list of items like the "Get rows" action. I have not found out how to use this action and return a resultset to a HTTP response, while with the "Get rows" action it is easy.
Is there a solution to this?
Do they read this feedback?
I have the same question... why is there no Get_Rows(V2) for stored procedure results?
Kevin McDonnell commented
Not sure if others have encountered this issue but I found that it was caused by the account used not having permissions to execute stored procedures rather than an issue with the Logic Apps Connector.