Description
Allows marketers to delete a Relational Table from their account.This will delete both the table and the data within the table.
Arguments
| Field | Description | Field Type | Required | Example |
|---|---|---|---|---|
| table_id | The table_id that was returned when created using the account.addRelationalTable method. This identifies the table you'd like to have removed. NOTE: This will delete both the table info and the data within the table | Number | Yes (when table_name is null) | 132 |
| table_name | The table_name value of a previously created table to be removed. NOTE: This will delete both the table info and the data within the table | String | Yes (when table_id is null) | concert_info |
Response
| Field | Description | Example |
|---|---|---|
| table_id | The table_id of the table just removed/deleted | 132 |
| table_name | The table_name of the table just removed/deleted | concert_info |
Response Codes
| Error Condition | responseCode | responseText |
|---|---|---|
| Successful operation. Table and table data has been removed | 631 | The relational table has been removed |
| The table_id value passed does not exist in the system | 632 | Action not taken, invalid table_id |
| The table_name value passed does not exist in the system | 633 | Action not taken, invalid table_name |
| Neither the table_id or the table_name were passed | 635 | Action not taken, table_id or table_name is required |
Example Post
<methodCall>
<methodName>account.removeRelationalTable</methodName>
<table_name>full_contacts_test</table_name>
</methodCall>
Example Response
<methodResponse>
<item>
<methodName><![CDATA[account.removerelationaltable]]></methodName>
<responseCode><![CDATA[631]]></responseCode>
<responseText><![CDATA[This relational table has been removed]]></responseText>
<responseData>
<table_id><![CDATA[2]]></table_id>
<table_name><![CDATA[full_contacts_test]]></table_name>
</responseData>
<responseNum><![CDATA[1]]></responseNum>
</item>
</methodResponse>
Example Error
<methodResponse>
<item>
<methodName><![CDATA[account.removerelationaltable]]></methodName>
<responseCode><![CDATA[632]]></responseCode>
<responseText><![CDATA[Action not taken, invalid table_id]]></responseText>
<responseData>
<table_id></table_id>
<table_name></table_name>
</responseData>
<responseNum><![CDATA[1]]></responseNum>
</item>
</methodResponse>