Records are purged based on the time the record was last modified.
Only one of the elements TABLE_NAME or TABLE_ID are required, not both.
TABLE_NAME - Specifies the folder path and name of the relational table to delete. If you specify TABLE_VISIBILITY, Acoustic Campaign ignores Private/Shared in TABLE_NAME.
TABLE_ID - Specifies the ID of the relational table to delete. Acoustic Campaign does not specify Private/Shared as part of the path.
TABLE_VISIBILITY - Only required if not specified in TABLE_NAME. Defines the visibility of the table you are referencing: 0 (private) or 1 (shared).
DELETE_BEFORE - Specifies a date range to purge data. The timestamp value is reflective of the user’s timezone. Date and timestamp value must be written as mm/dd/yyyy hh:mm:ss
EMAIL - If specified, Acoustic Campaign sends a completion notification to the provided email address.
<Envelope> <Body> <PurgeTable> <TABLE_NAME>WebAnalyticsPurchases</TABLE_NAME> <TABLE_VISIBILITY>0</TABLE_VISIBILITY> <DELETE_BEFORE>07/25/201112:12:11</DELETE_BEFORE> <EMAIL>[email protected]</EMAIL> </PurgeTable> </Body> </Envelope>
<Envelope> <Body> <RESULT> <SUCCESS>TRUE</SUCCESS> <JOB_ID>499600</JOB_ID> </RESULT> </Body> </Envelope>
SUCCESS - True if successful
JOB_ID - Identifies the Acoustic Campaign background job created and scheduled for this table purge.