This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
It has been announced [Announcement] that the V1 Actions/Triggers of the SQL Connector for Logic Apps will be deprecated by end of March 2024.![Omar_Abu_Arisheh_0-1708532248805.png Omar_Abu_Arisheh_0-1708532248805.png](https://techcommunity.microsoft.com/t5/image/serverpage/image-id/553750i11E9215D6B359DC7/image-dimensions/289x148?v=v2)
In this article we will be using a PowerShell Script to identify the Logic Apps still using the deprecated SQL Connector's Actions/Triggers so you can manually change them to use their V2 equivalent.
The script can be altered to check if the returned action is a SQL one as some other connectors use a similar path to the one we are relying on to identify the V1 deprecated actions.
Steps:
-
Open CloudShell: My Dashboard - Microsoft Azure
-
Wait until it logs in.
-
Replace the SubscriptionId with yours.
-
Replace the ResourceGroupName with yours (optional).
-
Paste the script into the command window and hit enter when it finishes loading.
-
Take the output and then check the Logic Apps if they are actually using the SQL Connector's deprecated V1 Actions or if it is a different connector.
-
Make sure you take a backup of your Logic Apps before making any changes, always make necessary changes on your Dev/Test environment and validate the changes before moving them to Production/Live environments.
For the code below, we rely on the path parameter of the action/trigger to see if it uses "datasets/default/" for V1 or if it uses "v2/datasets/" for V2 actions. You can test either of these to check if the script is working for you.
You can search in a Subscription scope or you can specify a Resource Group to search. Uncomment the part for the ResourceGroupName to allow the script to search only that Resource Group.
Disclaimer: The code below is provided as is with no liability on the author, please review and use at your own risk.
Another option is to run the below script in Azure Resource Graph Explorer then explore the properties of each result to see if the action/trigger is a SQL one or another kind:
In Azure Resource Graph Explorer:
References:
- SQL Server connector’s V1 actions and triggers will be retired on 31 March 2024 – transition to SQL Server connector’s V2 actions and triggers | Azure updates | Microsoft Azure
- SQL Server - Connectors | Microsoft Learn
- Listing Connectors by Logic App - Microsoft Community Hub
- PS-Scripts---Logic-Apps-Connectors/Local_ListLogicAppsConsumptionConnectors.ps1 at main · PedroAlmeidaMS/PS-Scripts---Logic-Apps-Connectors (github.com)
- Use PowerShell Script to Manage Your API Connection of Logic App (Consumption) Resources - Microsoft Community Hub