Hello Domo experts,
We are trying to find a way to use the API, or other non-UI approach, to purge all the data from any existing Domo dataset.
A little background may help...
Our company (Anonomatic) provides an add-on to Domo called PII Vault. What it enables is for Domo customers to get full Domo functionality but never have to load customer/patient/etc. personal identifiers (PII) into Domo.
That process works just find and we have healthcare and financial services customers happily using it. However, we recently had some requests from our Domo customers to enable them to take data which is already in a Domo dataset (Dataset A) which has PII in it and run it through our process to create Dataset B which will not have PII. Because of what we do, Dataset B can be made available to basically anyone in their organization without worrying about data privacy issues and they can still do everything else they would do with Dataset A.
The problem is that once we create Dataset B, the data in Dataset A is still there and so the data privacy issue is not fully resolved.
Deleting Dataset A is not an option. They have existing jobs that populate it and they do not want to have to change them. Instead, they want our process to run after it is populated and then clean it out once we are done.
So back to my question. Is this possible? We have scoured the Domo API documentation but there does not seem to be any way to delete records from an existing dataset.
We even tried importing a single blank row into the source dataset but because the dataset was not created via API, it cannot be modified via API.
Thank you all,
