Execute stored procedure (V2) - Failed to retrieve dynamic inputs

[kpenumarthi]

I am trying to connect to an Azure SQL Database from Logic Apps to execute a stored procedure, but getting error 'Failed to retrieve dynamic inputs. Error details: 'Error occurred while executing the following API parameters: '/v2/$metadata.json/datasets/<Server_Name>,<Database_Name>/procedures/"Procedure_Name>"'.

Below are the steps i followed.

1. Created a Managed Identity in Azure with type 'Microsoft.ManagedIdentity/userAssignedIdentities'
2. Added the managed identity in the logic app's Setting > Identity > User Assigned
3. The Managed Identity exists as an EXTERNAL_USER in the Azure SQL Database
4. The Managed Identity user has CONNECT, EXECUTE, and VIEW DEFINITION permissions on the stored procedure
5. The SQL API Connection is visible in the Azure Resource Group with Status 'Ready'
6. Used the same API Connection in Logic App's 'Execute stored procedure (V2)' connector.

Despite checking and configuring all these, getting the error 'Failed to retrieve dynamic inputs. Error details: 'Error occurred while executing the following API parameters: '/v2/$metadata.json/datasets/<Server_Name>,<Database_Name>/procedures/"Procedure_Name>"'.

As the application is not resolving any names like server name and database name, i provided them as custom values, but it is not recognizing stored procedure name. Please suggest steps to solve this.