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.
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.