ACS - erase all records from custom resources | Community
Skip to main content
acc_acs
acc_acs
Level 3
October 21, 2021
Solved

ACS - erase all records from custom resources

  • October 21, 2021
  • 2 replies
  • 2170 views

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

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by SatheeskannaK

    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!

    2 replies

    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    October 21, 2021

    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-resource/deleting-a-resource.html?lang=en to keep resource definition alone available by removing the entire data.

     

    Thanks!

    Thanks, Sathees
    acc_acs
    acc_acsAuthor
    Level 3
    October 21, 2021

    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
      Community Advisor
      SatheeskannaKCommunity AdvisorAccepted solution
      Community Advisor
      October 21, 2021

      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!

      Thanks, Sathees
        _abhishek_
        _abhishek_
        Level 3
        October 22, 2021

        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.

         

        Terms & ConditionsAccessibility statement

        Loading footer...