Delete multiple assets in Purview

Question

Delete multiple assets in Purview

Anonymous

Hello,

I have a collection in Purview with more than 700 assets that I want to delete. The problem is that I don't see any way to delete multuiple assets, I can only do it one by one, and deleting the collection is not also the solution because it has assets related.

I have found an option to move multiple assets to another collection, but not to delete it. Can you help?

Thanks,

PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-22T03:49:55.72+00:00
Hello @Anonymous ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

2 answers

Your answer

PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-22T03:49:55.72+00:00

Hello @Anonymous ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

Answer 1

Stefan Strube 10 MVP

I found out by navigating Microsoft Purview that it is possible to start a bulk delete of assets in the user interface. If you navigate to the level of SQL Server instance then the deletion of this entity type will delete the child items as well. See my blogpost: Bulk delete assets in Microsoft Purview via the user interface.
And I've create a Power AUtomate flow to automate the deletion of assests in Microsoft Purview: Bulk Delete assets in Microsoft Purview with Power Automate flow.

Answer 2

PRADEEPCHEEKATLA 90,596

Hello @Anonymous ,

Thanks for the question and using MS Q&A platform.

Currently, there is no way to delete multiple assets from the Purview UX.

The only way to delete multiple assets from the catalog is through REST APIs.

Steps to delete an Asset in Purview using REST API:

From this document, follow the steps to Use the Postman client to call the REST APIs.

Step1: Get Token

 POST https://login.microsoftonline.com/<your-tenant-id>/oauth2/token

Step2: How to find a guid of an asset in Azure Purview Studio. Select any asset and you will find the guid in the url section:

Step3: Entity - Delete By Guid – Used to delete single asset by using associated Guid:

Syntax: DELETE {Endpoint}/catalog/api/atlas/v2/entity/guid/{guid}

Sample URL: DELETE {Endpoint}/catalog/api/atlas/v2/entity/guid/fd279eb4-f6c3-1b0b-ad67-e4f8abd2972f

Step4: Entity - Delete By Guids – Used to delete mulitple asset by using associated Guid:

Syntax: DELETE {Endpoint}/catalog/api/atlas/v2/entity/bulk?guids={guids}

Sample:

DELETE {Endpoint}/catalog/api/atlas/v2/entity/bulk?guids=[  
      
      "18e06957-e265-967a-07f1-e14e2ab8940f",  
      
      "cc0730ba-9b30-41f0-6953-559d17626d2b"  
      
    ]

Hope this helps. Do let us know if you any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Anonymous

2022-04-11T09:00:59.99+00:00

Hello,
I’m trying to do it but I’m getting an error:

I think that may be the Endpoint is not correct. Can you explain me where I can fount it?

There is a way to obtain a list of Guid’s?

Thanks,
PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-12T09:13:23.817+00:00

Hello @Anonymous ,

You can use Types - Get All Type Definitions - Get all type definitions in Atlas in bulk.

Note: You can save the response and filter all the guids from the response output.
Anonymous

2022-04-12T15:14:51.56+00:00

Hello,

I have several problems trying to delete the assets. First of all, the URL used to delete multyple assets doesn't works:

I have found another version with the guid's separated by "&", but it doesn't work neither:

In the other hand, the second request you said me to obtain the guid list doesn't return guids that reference the assets in purview (I supose that the assets are not the only element identified by a guid). There is a way to obtain the list of the asset's guid in Purview by using the "Get all types definition" request?
PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-13T09:06:22.547+00:00

Hello @Anonymous ,

Before you try to delete the assets, I would suggest you try to get the Entity- List By Guids and then run Entity - Delete By Guids.

Could you please check this REST API to get all list of guids:- Discovery - Query - REST API (Azure Purview) | Microsoft Learn
Anonymous

2022-04-13T13:47:17.363+00:00

Good morning,

The GET request works

But the DELETE one is not worinking

The URL request is the same, isn't? I mean, I only need to modify the GET by a DELETE in Postman.

Also, the "Discovery - Query" is not working neither:
PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-18T06:12:28.767+00:00

Hello @Anonymous ,

We are reaching out to the internal team to get the more details on this ask. I will be update you once I hear back from the team.
PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-20T10:33:25.1+00:00
Hello @Anonymous ,

To resolve this issue, you need to add the below Headers:

HTTP header Content-Type: application/json

HTTP header api-version: 2022-03-01-preview

I works as excepted once you add the above Headers:

Hope this helps. Do let us know if you any further queries.
PRADEEPCHEEKATLA 90,596 Reputation points

2022-04-25T05:13:00.777+00:00

Hello @Anonymous ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Anonymous

2022-05-03T14:14:40.557+00:00

Hello,

Yes, adding the header makes the DELETE works, thanks for that. However, I still need to know how to obtain the GUID's associated to the assets. I have to use the "Get all types definition" request? Which are the arguments I have to use?

Thanks.
PRADEEPCHEEKATLA 90,596 Reputation points

2022-05-04T05:01:07.493+00:00
Hello @Anonymous ,

You can use the “Discovery” APIs

Browse - https://learn.microsoft.com/en-us/rest/api/purview/catalogdataplane/discovery/browse

Query - https://learn.microsoft.com/en-us/rest/api/purview/catalogdataplane/discovery/query

Hope this helps. Do let us know if you any further queries.
Anonymous

2022-05-04T09:41:34.147+00:00

Hello,

Both request fail:

Anyway, checking the responses shown in the documentation, I suppose that these requests will give me a list of GUID’s. However, I need to know which one of these are assets, I mean, I need to filter the assets to delete them with the other request.

Thanks.
PRADEEPCHEEKATLA 90,596 Reputation points

2022-05-05T09:32:13.967+00:00

Hello @Anonymous ,

BROWSE – Looking at your screenshot, you appear to be missing the required JSON payload in the Body. Working example below. For more examples on how to construct the JSON, refer to the docs.

QUERY - Similar problem for the Query endpoint. Working example below. For more examples on how to construct the JSON, refer to the docs.

Hope this helps. Do let us know if you any further queries.
PRADEEPCHEEKATLA 90,596 Reputation points

2022-05-10T06:02:55.197+00:00

Hello @Anonymous ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Sunita Gannavarapu 66 Reputation points Microsoft Employee

2023-11-06T17:07:22.7133333+00:00

Hi @PRADEEPCHEEKATLA : I am using the bulk delete URL you mentioned above for bulk delete. Problem I am facing is, it is deleting assets for which I am not sending the GUID's.

Example my URL contains 10 GUID's, then it is deleting 20 assets, additional 10 assets whose GUID is not sent in the URL.

Any suggestion ?

Share via

Delete multiple assets in Purview

2 answers

Your answer