How to identify usage of Azure SQL Database 2014-04-01 APIs before retirement

McDonald, Matthew 186

I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version?

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 [aka.ms] any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

I found a similar question from 2022 that offered an answer with a query that could be run to do this, but I am not sure where to run such a query. I tried Azure Monitor > Logs but it failed to run.

HttpIncomingRequests  
| where TIMESTAMP > ago(1d)  
| where targetResourceProvider == 'MICROSOFT.SQL'  
| where subscriptionId == 'xxxxxxxxxxxx'  
| where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"

I tried running this in Azure monitor but it does not know what HttpIncomingRequests is.

User's image

GeethaThatipatri-MSFT 29,382 Reputation points Microsoft Employee

2023-12-04T14:35:45.41+00:00

Hi @McDonald, Matthew Welcome to the Microsoft Q&A platform, thanks for posting the question
As I understand you want to know where to check if the Azure SQL Database is using 2014-04-01 APIs
There are two ways you can follow:

The Query you are seeing can be run on Kusto, am not sure if you have access to execute this Kusto queries. however, this is a reminder for all the customers who have registered for Microsoft.SQL will receive these notifications,

Regards
Geetha
McDonald, Matthew 186 Reputation points

2023-12-04T21:06:22.3366667+00:00

I appreciate the response, but I have no idea what Kusto is or where to access it. Is this in the Azure Data Explorer? I understand that is Kusto based, but when I go there I have no kusto clusters so I'm not sure what I'd be doing here.
GeethaThatipatri-MSFT 29,382 Reputation points Microsoft Employee

2023-12-11T18:27:21.5+00:00

@McDonald, Matthew I dont think you can execute this query, i can check from my end if you can send an email to AzCommunity[at]Microsoft[dot]com with the below details,

Email subject: <Attn - Geetha : Microsoft Q&A Thread title>

Thread URL: <Microsoft Q&A Thread>

Subscription ID: <your subscription id>

Looking forward to your reply.

Regards

Geetha
McDonald, Matthew 186 Reputation points

2023-12-11T18:43:54.6033333+00:00

@GeethaThatipatri-MSFT I tried emailing the address you specified but it was rejected by your servers.

The message I received is as follows:
GeethaThatipatri-MSFT 29,382 Reputation points Microsoft Employee

2023-12-11T19:57:53.46+00:00

@McDonald, Matthew Please try one more time to azcommunity@microsoft.com
McDonald, Matthew 186 Reputation points

2023-12-11T20:33:06.0566667+00:00

That is where I am sending it. It failed again with same error and mentions the same mtmvp@microsoft.com.
Jovin, Srdjan 20 Reputation points

2023-12-13T09:21:19.5433333+00:00

Hello,

I also tried to send an e-mail to azcommunity@microsoft.com but received the same error message as Matthew.

What could be the cause of the issue? Am I doing something wrong?

Thanks and regards

Srdjan
McDonald, Matthew 186 Reputation points

2023-12-15T17:28:25.8233333+00:00

@jovin, srdjan (not sure this will properly notify you), but just an fyi, it turns out the recipient did get the message, even though that error occurs. I can only assume that email address leads to a distribution list and the erroring entity is just one of the recipients but is unable to be sent to.

Edit: It looks like the @ mention system does not know how to properly handle users with commas or spaces in their name or I just don't know how to do it properly. The autofill doesn't seem to find you either.

Accepted answer

GeethaThatipatri-MSFT 29,382 Reputation points Microsoft Employee

2023-12-12T01:23:18.3933333+00:00

Hi, @McDonald, Matthew Thanks for sending the email, I have checked the subscription details which you have shared and I don't see any results It means it's good, no old API calls unless you have an application that ran more than 30 days ago and not at all since then, So if you have some application or pipeline that runs once a year or quarterly, then maybe that might still have issues. But that's very unlikely.

I hope this information helps.

Regards

Geetha
Please sign in to rate this answer.
Marc Rufer 45 Reputation points MVP

2023-12-12T03:31:45.4066667+00:00

@GeethaThatipatri-MSFT how can I Check it for my subscriptions? I habe multiples :S

McDonald, Matthew 186 Reputation points

2023-12-12T19:13:29.41+00:00

@GeethaThatipatri-MSFT Thank you so much!

GeethaThatipatri-MSFT 29,382 Reputation points Microsoft Employee

2023-12-12T20:25:01.64+00:00

@McDonald, Matthew If this answers your question, please consider accepting the solution by hitting the Accept as Solution ‌‌as it helps the community look for answers to similar questions.

Thanks for visiting Microsoft Q&A forum have a great day!

Regards

Geetha

Nishant Tyagi 6 Reputation points

2024-08-27T06:23:02.3566667+00:00

Hi @GeethaThatipatri-MSFT

I have same issue. i have two subscription and needs to be check this. kindly help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

4 additional answers

Jovin, Srdjan 20 Reputation points

2023-12-06T10:25:44.4366667+00:00

Hello Matthew,

Kusto queries are executed in Azure Resource Graph Explorer. To start it, you can search on the

Azure platform “ Resource Graph Explorer ”. In the query window you can execute Kusto queries (please see the attached screenshot).

It seems but that there is an issue with the query you found. It fails with the following error message:

Query is invalid. Please refer to the documentation for the Azure Resource Graph service and fix the error before retrying. (Code:InvalidQuery)

I tried to query just HttpIncomingRequests but I got this message:

Table HttpIncomingRequests is invalid, unsupported or disallowed.

As it could be a permission problem (I do not have privileges on this table) I took a look at the available Resource Graph tables (Understand the query language - Azure Resource Graph | Microsoft Learn) but the table was not listed. Therefore, I am not sure whether the table, HttpIncomingRequests, is still available.

Probably I will create a support ticket for the issue.

Regards

Srdjan
Please sign in to rate this answer.
McDonald, Matthew 186 Reputation points

2023-12-08T16:05:50.99+00:00

Thanks. I also received that same error.

Art DUNHAM 15 Reputation points

2024-08-27T11:28:24.23+00:00

I also get the same error - surely someone at Microsoft can provide working instructions on how we can tell if our SQL database is affected by the API retirement as per their numerous emails they send warning us that we have until Oct 31 2025 to fix it. The wording of these email make it clear that we are affected 'You’re receiving this email because you use Azure SQL Database APIs.' although reading other comments in the various threads it sounds like we may not be ... so back to the question - how do we tell if we are affected or not?

Art DUNHAM 15 Reputation points

2024-08-28T11:03:23.09+00:00

if you get an error when trying the query it indicates a table error. Apparently the table is not available if you are not using https requests which (I think) is an indication that you are not affected by the retirement of the APIs. https://video2.skills-academy.com/en-us/answers/questions/2006332/problem-retire-older-version-azure-sql-apis

Mark Fletcher 0 Reputation points

2024-09-19T16:18:46.3266667+00:00

Having the same issue, I noted that the filter expression in the provided solution seemed to be causing the error. I personally went back to Azure Resource Graph documentation, started to run a few sample queries in the Azure Resource Graph Explorer to get a feel for it, and eventually created my own query to show which SQL server databases I had and the api version being used. Hope this helps others. I am satisfied that all mine are using supported API!!

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

Art DUNHAM 15 Reputation points

2024-09-19T17:01:10.19+00:00

Mark - thanks for this - definitive answer and query which is what everyone has been asking for - ran it and the apiVersion returned was 2024-05-01-preview so that makes me feel better! Not sure why this couldn't have been included in the original Microsoft email :(

Mark Fletcher 0 Reputation points

2024-09-19T18:06:21.2433333+00:00

Whilst all of us who have tried my query are getting a result of 2024-05-01-preview, I just want to assure you that I got my query inspiration from the first Advanced query samples at https://video2.skills-academy.com/en-us/azure/governance/resource-graph/samples/advanced?tabs=azure-cli

I just added a few where statements!!

I have since gone a stage further and added a few extra columns to help you identify where the DB's are!!

Resources | project name, type, apiVersion, subscriptionId, resourceGroup |where type =~ 'microsoft.sql/servers/databases' |where isnotnull(apiVersion) |order by type asc
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Tom Bulsink | Inspiro 6 Reputation points

2024-08-29T09:56:36.58+00:00

I'm aware that this is a somewhat older thread, but here https://stackoverflow.com/a/78924072 it is suggested that if this query fails, you probably do not use the Azure SQL database APIs (as is the fact in my case) and that the notification can be ignored.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Caleb Magnon 0 Reputation points

2024-09-05T16:05:55.65+00:00

I don't want to create another question here, but we do have an application that connects to the Azure database. How do we go about understanding whether or not we are using API's and if they are going to be depricated?
Please sign in to rate this answer.
Lucas 0 Reputation points

2024-09-10T08:09:28.1966667+00:00

Same here, I cannot find a straight forward answer anywhere. We are using multiple SQL databases that we connect to by using the classic .NET System.Data Library.

From what I understand we would only need to update if we would be using anything like Data API builder or the API of the SQL database / server directly. Can anyone confirm this?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Mark Fletcher 0 Reputation points

2024-09-19T16:42:43.8+00:00
Try this in Azure Resource Graph Explorer - it will at least give you an idea of the api versions installed on your SQL DB's, even if they are not being actively used.

Resources | project name, type, apiVersion |where type =~ 'microsoft.sql/servers/databases' |where isnotnull(apiVersion) |order by type asc
Please sign in to rate this answer.
BlackHawk Datacom 0 Reputation points

2024-09-19T16:50:57.87+00:00

I completed the query and all of the versions came back as '2024-05-01-preview'. Should I assume that since there were no older versions listed as a result of this query that there are no other versions being used?

Mark Fletcher 0 Reputation points

2024-09-19T17:09:03.45+00:00

@BlackHawk Datacom I too got version 2024-05-01 Preview for all of mine. For me at least, this is more information than the original failed query! I am happy to be told otherwise, but for now, I believe the query result!!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to identify usage of Azure SQL Database 2014-04-01 APIs before retirement

4 additional answers

Your answer