Delete records from a relational table - DeleteRelationalTableData

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.