Azure SQL: can we grant 'execute' permission for stored procedure to API connections in logic app?

I want to execute the stored procedures from the logic app.

I have added an SQL connector for it. but in the 'Procedure name' dropdown, that particular procedure is not visible to me.

do I need to get permission from the admin, to grant execute permission for the stored procedure for a particular API connection? or do I have to get permission for any other objects/azure services?

I added permission to the logic app resource group but still, a stored procedure is not visible in the dropdown.

Thanks in advance!

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum