Overview

Skill Level: Intermediate

Step-by-step

  1. Syntax of the request and response XML for DeleteRelationalTableData

    Operation <DeleteRelationalTableData>
    Elements TABLE_ID The ID of the Acoustic Campaign Table that is updated.
      ROWS XML node that contains ROW elements for each row that is deleted.
      ChildElements ROW XML nodes that define a relational table row and its key columns.
        ChildElements KEY_COLUMN The value of a Relational Table Key Column for the row that is being
    deleted. If the table has multiple columns that are defined as key columns, each ROW has multiple COLUMN elements. All Key Columns must be provided for each ROW.
          Attributes name The name of a Relational Table Key Column for the row that is being deleted.
    Example
    <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>
    
    Response <RESULT>
    Elements SUCCESS True if any rows are deleted.
      FAILURES XML that contains FAILURE elements for each row that could not be deleted.
      ChildElements FAILURE Provides a description of each failure.
      Attributes failure_type

    Identifies whether the row could not be deleted for a reason that is temporary. Valid values
    are:

    • transient
    • permanent
        description The description of the error.
        ChildElements KEY_COLUMN The value of a Relational Table Key Column for the row that is being
    deleted. A KEY_COLUMN is returned for each key field of the record that could not be inserted.
        Attributes name The name of the Relational Table Key Column being deleted that was
    not successful.
    Example
    <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>
    

Join The Discussion

Your email address will not be published. Required fields are marked *