Programmatically delete Acoustic Campaign relational table data.
Notes
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.
Elements (Required)
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).
Elements (Optional)
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>
Elements (Results)
SUCCESS - True if successful
JOB_ID - Identifies the Acoustic Campaign background job created and scheduled for this table purge.