Overview

Skill Level: Intermediate

Prerequisites

You can purge all data or specify a date range by using “Delete Before”.¬†Note: Records are purged based on the time the record was last modified.

Step-by-step

  1. Syntax of the request and response XML for PurgeTable

    Operation <PurgeTable>
    Elements TABLE_NAME Parameter to specify the folder path and name of the Relational Table you are deleting. Note: Requires either TABLE_NAME or TABLE_ID. If you specify TABLE_VISIBILITY, Acoustic Campaign ignores Private/Shared in TABLE_NAME.
      TABLE_ID Parameter specifying the ID of the Relational Table you are deleting. Note: Requires either TABLE_NAME or TABLE_ID. Acoustic Campaign does not specify Private/Shared as part of the path.
      TABLE_VISIBILITY Parameter defining the visibility of the table you are referencing. Required if not specified in TABLE_NAME.

    • 0 – Private
    • 1 – Shared
    ¬† DELETE_BEFORE Optional Timestamp Value is reflective of User’s Timezone. Date and Timestamp value must be written as mm/dd/yyyy hh:mm:ss
      EMAIL Optional If specified, Acoustic Campaign sends notification to the provided email address when the job is complete.
    Example
    <Envelope>
      <Body>
        <PurgeTable>
          <TABLE_NAME>WebAnalyticsPurchases</TABLE_NAME>
          <TABLE_VISIBILITY>0</TABLE_VISIBILITY>
          <DELETE_BEFORE>07/25/201112:12:11</DELETE_BEFORE>
          <EMAIL>user@silverpop.com</EMAIL>
        </PurgeTable>
      </Body>
    </Envelope>
    

    Response <RESULT>
    Elements SUCCESS True if successful
      JOB_ID Identifies the Acoustic Campaign background job that is created and scheduled for this table purge.
    Example
    <Envelope>
      <Body>
        <RESULT>
          <SUCCESS>TRUE</SUCCESS>
          <JOB_ID>499600</JOB_ID>
        </RESULT>
      </Body>
    </Envelope>
    

2 comments on"Purge data from a relational table"

  1. What does that mean by purge data?

    • Hello Louie,
      Purge data means to get rid of, or delete the data.

      Thank you
      jeri

Join The Discussion

Your email address will not be published. Required fields are marked *