Overview

Skill Level: Any

Prerequisites

This interface inserts or updates relational data.

For each Row that is passed in:

  • If a row is found having the same key as the passed in row, update the record.
  • If no matching row is found, insert a new row setting the column values to those passed in the request.
  • When rows are inserted or updated in the relational table, all Column values are set based on the values passed in the COLUMN elements.

Note: Only one hundred rows may be passed in a single InsertUpdateRelationalTable call.

Step-by-step

  1. Syntax of the request and response SOAP for InsertUpdateRelationalTable

    Operation  <InsertUpdateRelationalTable>         
    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 inserted or updated.       
      Child
    Elements 
    ROW  XML nodes defining a relational table row and its columns.     
        Child
    Elements 
    COLUMN  The value of the Relational Table Column being inserted or
    updated. 
     
          Attributes  name  The name of the Relational Table Column being
    inserted or updated. 
    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:InsertUpdateRelationalTable>
    <sil1:TABLE_ID>131126</sil1:TABLE_ID>
    <sil1:ROWS>
    <sil1:ROW>
    <sil1:COLUMN name=”Record Id”><![CDATA[15465431]]></sil1:COLUMN>
    <sil1:COLUMN name=”Purchase Date”><![CDATA[01/09/2010]]></sil1:COLUMN>
    <sil1:COLUMN name=”Product Id”><![CDATA[12345]]></sil1:COLUMN>
    </sil1:ROW>
    <sil1:ROW>
    <sil1:COLUMN name=”Record Id”><![CDATA[54646654]]></sil1:COLUMN>
    <sil1:COLUMN name=”Purchase Date”><![CDATA[10/11/2010]]></sil1:COLUMN>
    <sil1:COLUMN name=”Product Id”><![CDATA[7979]]></sil1:COLUMN>
    </sil1:ROW>
    </sil1:ROWS>
    </sil1:InsertUpdateRelationalTable>
    </soapenv:Body>
    </soapenv:Envelope> 
           
    Response  <RESULT>         
    Elements  SUCCESS  True if the request is successfully received and processed.       
      FAILURES  XML node containing FAILURE elements for each row that could NOT be inserted
    or updated. This element and its children will not be included if no failures are
    encountered. 
         
      Child Elements  FAILURE  Provides a type and description of each failure.     
      Attributes  failure_type 

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

    transient

    permanent 

       
        description  The description of the error.     
        Child Elements  COLUMN 

    The value of the Relational Table Column being
    inserted or updated.

    A COLUMN will be
    returned for each field of the record that could
    not be inserted. 

     
        Attributes  name  The name of the Relational Table Column being
    inserted or updated 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 *