Deletes records from an Acoustic Campaign relational table.
Elements (Required)
TABLE_ID - The ID of the Acoustic Campaign table to update.
ROWS > ROW - XML node containing ROW elements that define a relational table row and its key columns to delete.
KEY_COLUMN -The value of a relational table key column for the a deleted row. If the table has multiple key columns, each ROW has multiple COLUMN elements. All key columns must be provided for each ROW.
name - Attribute of KEY_COLUMN. The name of a relational table key column for the deleted row.
<Envelope>
<Body>
<DeleteRelationalTableData>
<TABLE_ID>56753246</TABLE_ID>
<ROWS>
<ROW>
<KEY_COLUMN name="Record Id">
<![CDATA[GHbjh73643hsdiy]]>
</KEY_COLUMN>
</ROW>
<ROW>
<KEY_COLUMN name="Record Id">
<![CDATA[WStfh73643hsdgw]]>
</KEY_COLUMN>
</ROW>
</ROWS>
</DeleteRelationalTableData>
</Body>
</Envelope>
<Envelope>
<Body>
<RESULT>
<SUCCESS>true</SUCCESS>
<FAILURES>
<FAILURE failure_type="transient" description="Database Deadlock">
<KEY_COLUMN name="RecordId">WStfh73643hsdgw</KEY_COLUMN>
</FAILURE>
<FAILURE failure_type="permanent" description="Row Not Found">
<KEY_COLUMN name="Record Id">GHbjh73643hsdiy</KEY_COLUMN>
</FAILURE>
</FAILURES>
</RESULT>
</Body>
</Envelope>
Elements (Results)
SUCCESS - True if any rows are deleted.
FAILURES - XML node containing FAILURE elements for each row that could not be deleted.
FAILURE - Provides a description of each failure.
failure_type - Attribute of FAILURE. Identifies whether the row could not be deleted for a temporary reason. Valid values are transient or permanent.
description - Attribute of FAILURE. The description of the error.
KEY_COLUMN - A child element of FAILURE. The value of a relational table key column for the deleted row. A KEY_COLUMN returns for each key field of the record that could not be inserted.
name - Attribute of KEY_COLUMN. The name of the unsuccessful, deleted relational table key column.