Overview

Skill Level: Any

Prerequisites

You must specify a table (name or ID) and database (name or ID) along with the contact columns that make the association.

Step-by-step

  1. Syntax of the request and response XML 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, Acoustic Campaign ignores 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 that defines the visibility of the table you are referencing. Required if not specified in TABLE_NAME. 0 РPrivate 1 РShared
      LISTNAME Optional parameter that specifies 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, Acoustic Campaign ignores 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 that defines the visibility of the database you are referencing. Required if not specified in LIST_NAME.

    • 0 – Private
    • 1 – Shared
      REMOVE Optional Boolean element that is used to remove the relationship between a database and a Relational Table. If specified, Acoustic Campaign 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 Acoustic Campaign
    database.
        TABLE_FIELD Contains the field name in the Relational Table.
    Example
    <Envelope>
      <Body>
        <JoinTable>
          <TABLE_NAME>Shared/WebAnalytics/Purchases</TABLE_NAME>
          <LIST_ID>65745</LIST_ID>
          <MAP_FIELD>
            <LIST_FIELD>ItemID</LIST_FIELD>
            <TABLE_FIELD>ItemID</TABLE_FIELD>
          </MAP_FIELD>
          <MAP_FIELD>
            <LIST_FIELD>PurchPrice</LIST_FIELD>
            <TABLE_FIELD>Purchase Price</TABLE_FIELD>
          </MAP_FIELD>
        </JoinTable>
      </Body>
    </Envelope>
    
    Response <RESULT>
    Elements SUCCESS TRUE if successful.
      JOB_ID Identifies the Acoustic Campaign background job that is created and scheduled for this process.
    Example
    <Envelope>
      <Body>
        <RESULT>
          <SUCCESS>TRUE</SUCCESS>
          <JOB_ID>108518</JOB_ID>
        </RESULT>
      </Body>
    </Envelope>
    

Join The Discussion

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