Unable to trigger mssql stored procedure

[nandhaece07]

@jjm , @armab , @cognifloyd , @LindsayHill , @blag
I attempted to execute a stored procedure using the sql.query action by entering the command "query = exec {sp_name}." However, upon checking the last execution of the stored procedure, it appeared to have been executed but did not result in any changes to the database tables.

Could you please advise if I am following the correct method for executing the stored procedure? Additionally, would you be able to suggest a workaround for this issue?