API reference
Help CenterCommunityDevelopersAcademyStatus

Delete a relational table - DeleteTable

Deletes Acoustic Campaign relational table data

The DeleteTable API allows you to delete table data, the table entity/structure, database/table associations (joins), and relational table queries. However, there are a few instances where you cannot delete a relational table:

  • The table is used by an active group of automated messages.
  • The table is used by an active autoresponder.
  • The table is used by an active sending mailing.
  • When queries exist that reference the table, but are owned by an associated database.

Elements (Required)

TABLE_NAME - Specifies the folder path and name of the relational table to delete. You must specify either the TABLE_NAME or TABLE_ID. Note: If you specify TABLE_VISIBILITY, Acoustic Campaign ignores Private/Shared in TABLE_NAME.

TABLE_ID - Specifies the ID of the relational table to delete. You must specify either the TABLE_NAME or TABLE_ID. Note: Acoustic Campaign does not specify Private/Shared as part of the path.

Elements (Optional)

TABLE_VISIBILITY - Defines the visibility of the table you reference. It is required if you do not specify in the TABLE_NAME: 0 (Private) or 1 (Shared).

EMAIL - The email address notified when the job is complete.

<Envelope>
  <Body>
    <DeleteTable>
      <TABLE_NAME>WebAnalyticsPurchases</TABLE_NAME>
      <TABLE_VISIBILITY>0</TABLE_VISIBILITY>
      <EMAIL>[email protected]</EMAIL>
    </DeleteTable>
  </Body>
</Envelope>

<Envelope>
  <Body>
    <RESULT>
      <SUCCESS>TRUE</SUCCESS>
      <JOB_ID>499600</JOB_ID>
    </RESULT>
  </Body>
</Envelope>

Elements (Results)

SUCCESS - True if successful, False if not.

JOB_ID - Identifies the background job created and scheduled for this table deletion.