Calling database stored procedure

Stored Procedures hit the database directly, of course, so I will point you to this thread on the topic that points out the issues with that practice, and specifically to this post by Bart.

If by Kinetic you mean the web interface, then there is no way to call a stored procedure directly that I’m aware of. Leaving the SQL Server open to access like that is a security nightmare. You could write your own secured API that calls the stored procedure, and if you were in the cloud, use Logic Apps to launch the SP.

And there may be other solutions to the problem that you’re trying to solve…