Overview

Skill Level: Any

Prerequisites

This interface supports associating a Database with a Relational Table. You must specify a table (name or ID) and database (name or ID) along with the contact columns making the association.

Step-by-step

  1. Syntax of the request and response SOAP for JoinTable

    Operation  <JoinTable>     
    Elements  TABLE_NAME 

    Optional parameter to specify the folder path and name of the Relational Table you are associating. Either TABLE_NAME or TABLE_ID is required.

    Note: If you specify TABLE_VISIBILITY, Watson Campaign Automation will ignore Private / Shared in TABLE_NAME. 

     
      TABLE_ID 

    Optional parameter to specify the ID of the Relational Table you are joining. Either TABLE_NAME or TABLE_ID is required.

    Note: Private/Shared is not specified as part of the path. 

     
      TABLE_VISIBILITY 

    Optional field defining the visibility of the table you are referencing. Required if not
    specified in TABLE_NAME.

    0 ‚Äď Private

    1 ‚Äď Shared¬†

     
      LIST_NAME 

    Optional parameter specifying the folder path and name of the database you are
    associating. Either LIST_NAME or LIST_ID is required.

    Note: If you specify LIST_VISIBILITY, Engage will ignore Private / Shared in LIST_NAME. 

     
      LIST_ID  Optional parameter to specify the ID of the database you are associating. Either
    LIST_NAME or LIST_ID is required. 
     
      LIST_VISIBILITY 

    Optional field defining the visibility of the database you are referencing. Required if not specified in LIST_NAME.

    0 ‚Äď Private

    1 ‚Äď Shared¬†

     
      REMOVE  Optional Boolean element used to remove the relationship between a database and a Relational Table. If specified, Watson Campaign Automation ignores any MAP_FIELD elements.   
      EMAIL  Optional parameter to specify an email address for notification of job completion or errors.   
    Child
    Element 
    MAP_FIELD     
      Child Elements  LIST_FIELD  Contains the field name in the Watson Campaign Automation database. 
        TABLE_FIELD  Contains the field name in the Relational Table. 
    Example¬† <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/”
    xmlns:ses=”SilverpopApi:EngageService.SessionHeader”
    xmlns:user=”SilverpopApi:EngageService.ListMgmt.UserActions”>
    <soapenv:Header>
    <ses:sessionHeader>
    <ses:sessionid>50F4F411A048A4DDA159ABE2954E4610</ses:sessionid>
    </ses:sessionHeader>
    </soapenv:Header>
    <soapenv:Body>
    <user:ImportTable>
    <user:MAP_FILE>Pets_Table.xml</user:MAP_FILE>
    <user:SOURCE_FILE>Pets_Table.csv</user:SOURCE_FILE>
    </user:ImportTable>
    </soapenv:Body>
    </soapenv:Envelope> 
       
    Response  <RESULT>     
    Elements  SUCCESS  TRUE if successful   
      JOB_ID  Identifies the Watson Campaign Automation Background Job created and scheduled for this process.   
    Example¬† <envelope:Envelope xmlns=”SilverpopApi:EngageService.ListMgmt.UserActions”
    xmlns:envelope=”http://schemas.xmlsoap.org/soap/envelope/”>
    <envelope:Header/>
    <envelope:Body>
    <RESULT>
    <SUCCESS>TRUE</SUCCESS>
    <JOB_ID>273287</JOB_ID>
    </RESULT>
    </envelope:Body>
    </envelope:Envelope> 
       

Join The Discussion

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