Hello  @pnelli,

Please review the content below:

Get Stored Procedure used by a Smart Object using the C# API?:

https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Get-Stored-Procedure-used-by-a-Smart-Object-using-the-C-API/td-p/80747

How to show stored procedure based List methods in an Item View method rule action:

https://help.k2.com/kb001455

Adding methods to K2 SmartObjects through the use of SQL Stored Procedures:

https://www.velocity-it.com/adding-methods-to-k2-smartobjects-through-the-use-of-sql-stored-procedures/

CREATE A SMARTOBJECT FROM A STORED PROCEDURE USING VISUAL STUDIO:

https://startrule.com/2016/07/12/create-a-smartobject-from-a-stored-procedure-using-visual-studio/

All the best.

Good day pnelli

Please see the following.

How-To: Using the SQL Server Service Type: https://www.youtube.com/watch?v=xl6ti3T5-0E,

Using SmartObjects to integrate with other systems and technologies: https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#ServiceBrokers/OtherSystems.htm,

K2 SmartObjects - Intermediate: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=9&cad=rja&uact=8&ved=2ahUKEwi2lIfF5JvmAhVlu3EKHRZtBM8QFjAIegQIARAC&url=https%3A%2F%2Fcommunity.k2.com%2Fpfxaw45692%2Fattachments%2Fpfxaw45692%2FK2_blackpearl%2F17682%2F2%2F200.PER%2520-%2520K2%2520SmartObjects%2520-%2520Intermediate.pdf&usg=AOvVaw3mEoW5AbH9fR5wmnIn-mQl,

K2 SmartObjects - Fundamentals: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=5&cad=rja&uact=8&ved=2ahUKEwi2lIfF5JvmAhVlu3EKHRZtBM8QFjAEegQIBhAC&url=https%3A%2F%2Fcommunity.k2.com%2Fpfxaw45692%2Fattachments%2Fpfxaw45692%2FK2_blackpearl%2F18775%2F1%2F100.SYD-K2_SmartObjects-Fundamentals.pdf&usg=AOvVaw0ixgPTZ9J1VrIELUU_Z55J.

Best,

sunrise

You are welcome, ElvisJacob1!