Overview

Skill Level: Any

Prerequisites

This interface deletes records from a relational table.

Step-by-step

  1. Syntax of the request and response SOAP for DeleteRelationalTableData

    Operation  <DeleteRelationalTableData>         
    Elements  TABLE_ID  The Id of the Watson Campaign Automation Table that will be updated.       
      ROWS  XML node containing ROW elements for each row being deleted.       
      Child Elements  ROW  XML nodes defining a relational table row and its key columns.     
        Child
    Elements
    KEY_COLUMN  The value of a Relational Table Key Column for
    the row being deleted. If the table has multiple
    columns defined as key columns, each ROW
    will have multiple KEY_COLUMN elements. All Key Columns must be provided for each ROW. 
     
          Attributes  name  The name of a Relational Table
    Key Column for the row being
    deleted. 
    Example¬† <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/”
    xmlns:sil=”SilverpopApi:EngageService.SessionHeader”
    xmlns:sil1=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <soapenv:Header>
    <sil:sessionHeader>
    <sil:sessionid>6502C4C303939946C0A14683DAAF8EC5</sil:sessionid>
    </sil:sessionHeader>
    </soapenv:Header>
    <soapenv:Body>
    <sil1:DeleteRelationalTableData>
    <sil1:TABLE_ID>131126</sil1:TABLE_ID>
    <sil1:ROWS>
    <sil1:ROW>
    <sil1:KEY_COLUMN name=”Record Id”><![CDATA[15465431]]></sil1:KEY_COLUMN>
    <sil1:KEY_COLUMN name=”Record Id”><![CDATA[54646654]]></sil1:KEY_COLUMN>
    </sil1:ROW>
    </sil1:ROWS>
    </sil1:DeleteRelationalTableData>
    </soapenv:Body>
    </soapenv:Envelope> 
           
    Response  <RESULT>         
    Elements  SUCCESS  True if any rows are deleted.       
      FAILURES  XML node containing FAILURE elements for each row that could NOT be deleted.       
      Child Elements  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.     
        Child Elements  KEY_COLUMN  The value of a Relational Table Key Column
    for the row being deleted. A KEY_COLUMN
    will be 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:Envelope xmlns:envelope=”http://schemas.xmlsoap.org/soap/envelope/”>
    <envelope:Header/>
    <envelope:Body xmlns=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <RESULT>
    <SUCCESS>true</SUCCESS>
    <FAILURES></FAILURES>
    </RESULT>
    </envelope:Body>
    </envelope:Envelope> 
           

Join The Discussion

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