Overview

Skill Level: Any

Prerequisites

This interface creates a Relational Table in Watson Campaign Automation.

Step-by-step

  1. Syntax of the request and response SOAP for CreateTable

    Operation  <CreateTable>         
    Elements  TABLE_NAME  Defines the name of the new table.       
      COLUMNS 

    XML nodes defining the table columns you are inserting/updating.

    Note: Unique key columns must be part of the submission with column names and values. 

         
      Elements  COLUMN       
        Child Elements  NAME  Defines the name of the column.   
          TYPE 

    Defines what type of column to create. The following is a list of valid values:

    TEXT

    YESNO

    NUMERIC

    DATE

    TIME

    COUNTRY

    SELECTION

    EMAIL

    DATE_TIME

    SYNC_ID

     
    ¬† ¬† ¬† IS_REQUIRED¬† Defines whether to create the column as “required”. Valid
    values are True and False. 
     
          KEY_COLUMN  Added to field definition and defines a field as a unique key for the table when set to True. You can define more
    than one unique field for each table. 
     
          DEFAULT_VALUE  Defines the default value of the column if the row does not
    contain a value for this column. 
     
    ¬† ¬† ¬† SELECTION_VALUES¬† Defines values in a drop‚Äźdown list. You must provide at
    least one VALUE element for when TYPE = SELECTION. 
     
    ¬† ¬† ¬† VALUE¬† A single value in a drop‚Äźdown list.¬† ¬†
    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:CreateTable>
    <sil1:TABLE_NAME>Purchase History</sil1:TABLE_NAME>
    <sil1:COLUMNS>
    <sil1:COLUMN>
    <sil1:NAME>Record Id</sil1:NAME>
    <sil1:TYPE>NUMERIC</sil1:TYPE>
    <sil1:IS_REQUIRED>true</sil1:IS_REQUIRED>
    <sil1:KEY_COLUMN>true</sil1:KEY_COLUMN>
    </sil1:COLUMN>
    <sil1:COLUMN>
    <sil1:NAME>Purchase Date</sil1:NAME>
    <sil1:TYPE>DATE</sil1:TYPE>
    <sil1:IS_REQUIRED>true</sil1:IS_REQUIRED>
    </sil1:COLUMN>
    <sil1:COLUMN>
    <sil1:NAME>Product Id</sil1:NAME>
    <sil1:TYPE>NUMERIC</sil1:TYPE>
    <sil1:IS_REQUIRED>true</sil1:IS_REQUIRED>
    </sil1:COLUMN>
    </sil1:COLUMNS>
    </sil1:CreateTable>
    </soapenv:Body>
    </soapenv:Envelope> 
           
    Response  <RESULT>         
    Elements  SUCCESS  TRUE if successful       
      TABLE_ID  Identifies the Id of the relational table created in Watson Campaign Automation.       
    Example¬† <envelope:Envelope xmlns:envelope=”http://schemas.xmlsoap.org/soap/envelope/”>
    <envelope:Header/>
    <envelope:Body xmlns=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <RESULT>
    <SUCCESS>true</SUCCESS>
    <TABLE_ID>131126</TABLE_ID>
    </RESULT>
    </envelope:Body>
    </envelope:Envelope> 
           

Join The Discussion

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