How to check Microsoft API version for Powershell related codes?

Question

My organisation got an email from Microsoft recently:

Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025

You’re receiving this email because you use Azure SQL Database APIs. To improve performance and security, we’re updating Azure SQL Database APIs. As part of this, all version 2014-04-01 APIs will be retired on 31 October 2025. You’ll need to update your resources, including templates, tools, scripts, and programs, to use a newer API version by then. Any API calls still using the older versions after that date will stop working until you’ve updated them.

Required action

To avoid potential service disruptions, upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

I tried this code, in Azure Resource Graph, but this just shows information about SQL databases API versions.

Resources
| project name, type, apiVersion
|where type =~ 'microsoft.sql/servers/databases'
|where isnotnull(apiVersion)
|order by type asc

My organisation has pipelines that onboard data from on-premise to Azure. But to trigger ADF pipelines we are using PowerShell, which looks like this: (generic format)

Start-AzDataFactoryV2Trigger -ResourceGroupName "YourResourceGroupName" -DataFactoryName "YourDataFactoryName" -Name "YourTriggerName"

Since my knowledge of PowerShell is very limited, can someone let me know whether it is an API call? If so, what exactly should I check in Microsoft regarding APIs?

If you mean the graph API, i think microsoft provided a page where you could see which applications that called these deprecated endpoints, which might help you finding things out. Check their migration docs, it should be there — siggemannen
– siggemannen, Commented Jul 4 at 9:11

Stanislav Zhelyazkov · Accepted Answer · 2025-07-04 05:47:23Z

The above ARG query will not list the APIs that you are using for Azure SQL Database. The above query shows the API that ARG (the services itself) is using to pull the data from Azure SQL Database. There is no straight forward way of finding if somewhere specific API version is used for Azure resources like Azure SQL database. These API versions are usually used within tools like Azure Bicep, TerraForm, Az CLI, Az PowerShell, etc. I see you are mentioning Az PowerShell. If you are using a fairly recent Az PowerShell version you have nothing to worry about. Version 2014-04-01 for Azure SQL database as you can see by its date is quite old and any recent (at least an year ago) version is most likely using higher version. You can check which version is used by using -Debug switch on the cmdlets. There you will see which API version is used to call the Rest API. Note that the version deprecation applies only to microsoft.sql/servers and microsoft.sql/servers/databases resource types. If you use other tools like Bicep or ARM templates in the templates for those you can easily see which version is called.

Collectives™ on Stack Overflow

How to check Microsoft API version for Powershell related codes?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related