Data360 Govern

We know how to delete an asset or asset type, and how to delete via API. Can we have advice as to whether it's possible to delete via Bulk Uploader instead? Can't find mention in docs or at https://support.infogix.com/hc/en-us/articles/360038889213-Helpful-Tips-for-Bulk-Loading

It feels like there should be a way to upload e.g. a blank sheet that resets the number of records to zero; however none of the modes (Promotion, Unrelation, etc) seem to clearly offer this. If not possible, please can we have confirmation of that and can it be stated in docs explicitly that Bulk Uploader is intended only for Create/Update and not Delete.

The reason for asking is that we are seeking a way to filter records by a given field (e.g. filter on Domain but can't use Search to achieve this since the items contain mention of the Domain in their name), and then delete them.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Hi Oli - Bulk Uploader is only for create/update, not delete. I'll make sure to have the guide updated to reflect this. As for the bulk delete based on a filter, you can accomplish this through API. We will reach out to discuss this functionality with you.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Hello Oliver,

We have updated our team to make change in Govern documentation 

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Hello Oliver,

We have created Enhancement request regarding the issue with Bulk load Delete functionality and our Product Management team is reviewing your request. 

Would like to add my 'vote' towards having an option in the bulk loader to delete records.  Ideally with an option to automatically cascade those deletes to any related objects.  

But in the meantime - could someone explain to me what the 'unrelation' option in the bulk loader does?  I couldn't find anything in doc.

Thanks, Jim

Hi Jim,

Hope you are well, long time no speak!

The unrelation bulk loader will allow you to upload a list of relationship IDs (the specific relationship between 2 assets) and remove them from Govern.

This can be used if you have a long list of related things that are no longer related in the business. Lets take an example of "Clients" and "Reports". Perhaps you have a long list of client taking a given report or set of reports but then some business change means those clients no longer take those reports.

The report and the client still need to exist in your govern environment but the relationship between them in the thing that need breaking. That's what the unrelation bulk load is for.

Also for the load template for the bulk deletion - the easiest thing to do is do an export and the record you want to delete and then use a very basic excel formula on the far right of the data to create a number of row of JSON you can then copy and paste into the Swagger front end (via Intergration --. API) and test it.

That way you don't need to build an Analyze flow or worry about authentication or anything, just that Excel formula.

The payload look like this:

[
  {
    "Uid": "00000000-0000-0000-0000-000000000000",
    "Cascade": true
  }
]

1st of all, swap the double quotes for single quotes to make the Excel formula easy and make it a single row and remove the square brackets

Like this: { 'Uid': '00000000-0000-0000-0000-000000000000',    'Cascade': true  }

Then create the excel formula to look at the UID for the record you want to delete and then you can copy in down

Like this:  ="{ 'Uid': '" & cellwithrecordUID &"',    'Cascade': true  }"

Once you copy in down you'll get lots rows look the same, highlight all the formulas and paste into the Swagger screen.

You'll need to add your square bracket back at the start and end "[" and "]"

Then just add the Type UID of the type of records you want to delete in the Type UID box 

and then press "Test" and it will delete the record for you