Delete multiple assets in Purview

Question

Delete multiple assets in Purview

Torralba-Resino Javier 61

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-MSFT 59,331 Reputation points Microsoft Employee

2022-04-22T03:49:55.72+00:00
Hello @Torralba-Resino Javier ,

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.

PRADEEPCHEEKATLA-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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

PRADEEPCHEEKATLA-MSFT 59,331 Microsoft Employee

Hello @Torralba-Resino Javier ,

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

Torralba-Resino Javier 61 Reputation points

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-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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.
Torralba-Resino Javier 61 Reputation points

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-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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
Torralba-Resino Javier 61 Reputation points

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-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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-MSFT 59,331 Reputation points Microsoft Employee

2022-04-20T10:33:25.1+00:00
Hello @Torralba-Resino Javier ,

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-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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.
Torralba-Resino Javier 61 Reputation points

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-MSFT 59,331 Reputation points Microsoft Employee

2022-05-04T05:01:07.493+00:00
Hello @Torralba-Resino Javier ,

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.
Torralba-Resino Javier 61 Reputation points

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-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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-MSFT 59,331 Reputation points Microsoft Employee

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

Hello @Torralba-Resino Javier ,

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.

Delete multiple assets in Purview

1 answer

Activity