Overview

Skill Level: Any

Prerequisites

The Delete Table API supports programmatically deleting Relational Table data from Watson Campaign Automation. You cannot delete the Relational Table in any of the following cases:

  • When the table is in use by active Group of Automated Messages.
  • If the table is in use by an active Autoresponder.
  • If the table is in use by an active Sending mailing.
  • When queries exist that reference the table, but are owned by an associated database.

You can delete the following:

  • Table data
  • The table entity/structure
  • Database/Table associations (joins)
  • Relational Table queries

Step-by-step

  1. Syntax of the request and response SOAP for DeleteTable

    Operation  <DeleteTable>     
    Elements  TABLE_NAME 

    Optional parameter to specify the folder path and name of the Relational Table
    you are deleting. Either TABLE_NAME or TABLE_ID is required.

    Note: If you specify TABLE_VISIBILITY, Watson Campaign Automation ignores Private/Shared in TABLE_NAME. 

     
      TABLE_ID 

    Optional parameter specifying the ID of the Relational Table you are deleting.
    Either TABLE_NAME or TABLE_ID is required.

    Note: Watson Campaign Automation does not specify Private/Shared as part of the path. 

     
      TABLE_VISIBILITY 

    Optional field defining the visibility of the table you are referencing. Required if not
    specified in TABLE_NAME.

    0 ‚Äď Private

    1 ‚Äď Shared

     

     
      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:ses=”SilverpopApi:EngageService.SessionHeader”
    xmlns:user=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <soapenv:Header>
    <ses:sessionHeader>
    <ses:sessionid>16FE7B75445E6C704707025B1B7BBEE5</ses:sessionid>
    </ses:sessionHeader>
    </soapenv:Header>
    <soapenv:Body>
    <user:DeleteTable>
    <user:TABLE_NAME>Shared/Product</user:TABLE_NAME>
    <user:EMAIL>somebody@domain.com</user:EMAIL>
    </user:DeleteTable>
    </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 deletion.   
    Example¬† <envelope:Envelope xmlns=”SilverpopApi:EngageService.ListMgmt.UserActions”
    xmlns:envelope=”http://schemas.xmlsoap.org/soap/envelope/”>
    <envelope:Header/>
    <envelope:Body>
    <RESULT>
    <SUCCESS>TRUE</SUCCESS>
    <JOB_ID>503533</JOB_ID>
    </RESULT>
    </envelope:Body>
    </envelope:Envelope> 
       

Join The Discussion

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