Add or update relational table data - InsertUpdateRelationalTable

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 insert or update.

COLUMN - The value of the relational table column to insert or update.
name - The name of the relational table column to insert or update.

<Envelope>
  <Body>
    <InsertUpdateRelationalTable>
      <TABLE_ID>86767</TABLE_ID>
      <ROWS>
        <ROW>
          <COLUMN name=”Record Id”>
            <![CDATA[GHbjh73643hsdiy]]>
          </COLUMN>
          <COLUMN name=”Purchase Date”>
            <![CDATA[01/09/1975]]>
          </COLUMN>
          <COLUMN name=”Product Id”>
            <![CDATA[123454]]>
          </COLUMN>
        </ROW>
        <ROW>
          <COLUMN name=”Record Id”>
            <![CDATA[WStfh73643hsdgw]]>
          </COLUMN>
          <COLUMN name=”Purchase Date”>
            <![CDATA[02/11/1980]]>
          </COLUMN>
          <COLUMN name=”Product Id”>
            <![CDATA[45789]]>
          </COLUMN>
        </ROW>
        <ROW>
          <COLUMN name=”Record Id”>
            <![CDATA[Yuhbh73643hsfgh]]>
          </COLUMN>
          <COLUMN name=”Purchase Date”>
            <![CDATA[05/10/1980]]>
          </COLUMN>
          <COLUMN name=”Product Id”>
            <![CDATA[4766454]]>
          </COLUMN>
        </ROW>
      </ROWS>
    </InsertUpdateRelationalTable>
  </Body>
</Envelope>

<Envelope>
  <Body>
    <RESULT>
      <SUCCESS>true</SUCCESS>
      <FAILURES>
        <FAILURE failure_type="permanent" description="Invalid Date Value in column:
          Purchase Date">
          <COLUMN name="Record Id">WStfh73643hsdgw</COLUMN>
        </FAILURE>
        <FAILURE failure_type="permanent" description="Invalid Number in column: Price">
          <COLUMN name="Record Id">GHbjh73643hsdiy</COLUMN>
        </FAILURE>
      </FAILURES>
    </RESULT>
  </Body>
</Envelope>

Elements (Results)

SUCCESS - True if successful.

FAILURES - XML node that contains FAILURE elements for each row that cannot be inserted or updated. This element and its children are not included if no failures are encouraged.

FAILURE - Provides a description of each failure.
failure_type - Attribute of FAILURE. Identifies whether the row could not be inserted or updated for a temporary reason. Valid values are transient or permanent.
description - Attribute of FAILURE. The description of the error.

COLUMN - A child element of FAILURE. The value of a relational table column being inserted or updated. A COLUMN returns for each field of the record that could not be inserted.
name - Attribute of COLUMN. The name of the unsuccessful, inserted or updated relational table column.