Unable to get stored procedure names in the dropdown using SQL authentication in azure logic app

1
votes

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!

1
azure-logic-apps
I was able to get SP names after deleting api connection and adding a new one. Is that the only solution? It seems a bad solution everytime I refresh permissions, I need to create a new connection and reconnect sql from all actions in the logic app. Any other alternative? - Mm77
please mark the answer below or update your question if it does not provide guidance - Alex Gordon

1 Answers

0
votes

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.