ACS - erase all records from custom resources

[acc_acs]

Hi there!

I have a custom resource. I know that to delete a record, I can use pkey. But I want to delete the entire table at once. Question. Is it possible, with one command, to clear the entire table?

Regards

[SatheeskannaK]

Hi @acc_acs,

You can do either using query activity that is pointing to custom resource and have update activity with operation as delete to clear the entire table or you can do re-draft on the custom resource by following this documentation https://experienceleague.adobe.com/docs/campaign-standard/using/developing/adding-or-extending-a-res... to keep resource definition alone available by removing the entire data.

Thanks!

[acc_acs]

Hi @SatheeskannaK 

Thanks for your reponse! Sorry if I've not clear enough about my question. I'll like mantain the custom resource. I'd like just erase all data records, because I'll use this resource for next time when I'll need.

Regards

[SatheeskannaK · Accepted solution]

Hi @acc_acs,

In this case you can go with first option to clear the records. Before doing make sure to verify the links you have between any other custom resource and the behavior definition when you delete any record on custom resource how it will react on linked resource.

Thanks!

[acc_acs]

Thanks!

[_abhishek_]

Hi @acc_acs,

We can easily do it by clicking on "draft" button where we add field details in the data model.

Basically it will unpublish the table. Once the table is unpublished means data is deleted. Whenever the table is required again, you can draft it, which means you can publish the table.