I am encountering an issue with the Microsoft Purview API, which extracts schema classification from Purview. Previously, using the same API, I was able to retrieve the data, but now the response code is 200, and the response is null value.

Damodaram Chinna Swamulu 0

API :
"https://{purviewaccountName}.purview.azure.com/catalog/api/atlas/v2/search/advanced?api-version={apiVersion}"

apiVersion : "2021-05-01-preview"

I used the above API for extracting schema classification from a Purview account (using Azure SQL Database and scanning some of the tables inside the database). Two months ago, I was able to extract the schema classification, but now I am encountering an issue where the response code is 200, but the response is null value from the API.

I tried the same API with new Purview accounts and the same scanning process, but I am still getting the same null value as response. We have added all necessary settings and permissions from Purview.

I tried with the latest apiVersion = "2023-01-01-preview" and received a response code of 200, but the response from the API is null value.

Ganesh Gurram 4,335 Reputation points Microsoft Vendor

2025-02-21T20:52:44.95+00:00

Hi @Damodaram Chinna Swamulu

Thank you for posting your query!

It seems like the API is returning a 200 OK status, but with no data in the response. There could be a few different things happening here, so I’d recommend checking a few things to help troubleshoot:

Check Scan Status - Make sure the scan for your Azure SQL Database tables has finished successfully. Sometimes, if the scan hasn’t completed or there's a problem with it, the data won’t be available in the catalog. You can manually trigger a scan to make sure everything is up to date.

Permissions and Endpoint - Check Double-check that the API endpoint is correct, including the account name and the API version you’re using. Also, ensure that the account or service principal has the necessary permissions to access the data (such as the Purview Data Reader role).

Adjust the Search Query - It's possible that the search query you're using might not match any available data. Try using broader search parameters or testing different resource types to see if any results come back. This will help ensure the issue isn’t with the query itself.

Test with Older API Version -You mentioned trying the newer API version (2023-01-01-preview), but it still returned null. You might want to try the version you were using previously (2021-05-01-preview), just to rule out any changes in the newer API.

Look at Purview Logs - It’s also a good idea to check the Purview logs in the Azure portal. These logs could give more insight into what might be going wrong, whether there are issues with scanning or any errors during the process.

For more details refer: https://docs.azure.cn/en-us/purview/datamap-troubleshoot-request-timeout

I hope this information helps.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Share via

I am encountering an issue with the Microsoft Purview API, which extracts schema classification from Purview. Previously, using the same API, I was able to retrieve the data, but now the response code is 200, and the response is null value.

Your answer