I am using a SQL Server "Execute Stored Procedure V2" connector in my logic app and the extraction does not create parameters for the "path" value in this logic app connector. It does properly parameterize the sql connection, but the V2 connectors also have a "hardcoded" path value that contains the name of the sql server, like this:
I am using a SQL Server "Execute Stored Procedure V2" connector in my logic app and the extraction does not create parameters for the "path" value in this logic app connector. It does properly parameterize the sql connection, but the V2 connectors also have a "hardcoded" path value that contains the name of the sql server, like this:
"host": { "connection": { "name": "@parameters('$connections')['sql_1']['connectionId']" } }, "method": "post", "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('my_DEV_SQL_Server.database.windows.net'))},@{encodeURIComponent(encodeURIComponent('my_database_name'))}/procedures/@{encodeURIComponent(encodeURIComponent('[SAGE].[usp_my_stored_proc_name'))}" }
In the snippet above... the value for "my_DEV_SQL_Server" is what I need to have parameterized during the logic app extraction.