'Unable to get stored procedure names in the dropdown using SQL authentication in azure logic app
I am not able to retrieve stored procedure names in the dropdown if I use SQL Server authentication.
I can view/execute stored procedure from SSMS using the SQL Server account credentials. Login user has view/execute access for stored procedures.
I see the error shown here when I try to execute stored procedure step from a logic app :
Could not retrieve values. BadGateway. Client request id:
Any help is appreciated!
Solution 1:[1]
According to some test, the latest permission will take some time to take effect(about 5-10 minutes). After a few minutes, you can go to the API connection and click "Refresh" button. Then go to logic app click "Change connection" and choose another API connection and then click "Change connection" again to choose back to the API connection. Then it will take effect. I test it with allow/not allow ip to connect to sql server.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Hury Shen |