Overview

Skill Level: Any

Prerequisites

This interface supports programmatically deleting Relational Table data from Watson Campaign Automation. You can purge all data or specify a date range using “Delete Before”.

Step-by-step

  1. Syntax of the request and response SOAP 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, Watson Campaign Automation 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. Watson Campaign Automation 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  If included, only data last modified before the specified date/time
    will be purged. 
      EMAIL  Optional  If specified, Watson Campaign Automation sends notification to the provided email address
    when the job is complete. 
    Example¬† <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/”
    xmlns:sil=”SilverpopApi:EngageService.SessionHeader”
    xmlns:sil1=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <soapenv:Header>
    <sil:sessionHeader>
    <sil:sessionid>6502C4C303939946C0A14683DAAF8EC5</sil:sessionid>
    </sil:sessionHeader>
    </soapenv:Header>
    <soapenv:Body>
    <sil1:PurgeTable>
    <sil1:TABLE_ID>131126</sil1:TABLE_ID>
    <sil1:DELETE_BEFORE>07/25/2009 12:12:11</sil1:DELETE_BEFORE>
    <sil1:EMAIL>somebody@silverpop.com</sil1:EMAIL>
    </sil1:PurgeTable>
    </soapenv:Body>
    </soapenv:Envelope> 
       
    Response  <RESULT>     
    Elements  SUCCESS  TRUE if successful   
      JOB_ID  Identifies the Watson Campaign Automation Background Job created and scheduled for this table purge.   
    Example¬† <envelope:Envelope xmlns:envelope=”http://schemas.xmlsoap.org/soap/envelope/”>
    <envelope:Header/>
    <envelope:Body xmlns=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <RESULT>
    <SUCCESS>true</SUCCESS>
    <JOB_ID>2496711</JOB_ID>
    </RESULT>
    </envelope:Body>
    </envelope:Envelope> 
       

Join The Discussion

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