account.removeRelationalTable
    • 1 Minute to read
    • Dark
      Light

    account.removeRelationalTable

    • Dark
      Light

    Article summary

    General Information

    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 have 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 nor the table_name was 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>

    CODE

    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>


    Was this article helpful?