Overview

Skill Level: Any

Step-by-step

  1. Syntax of the request and response XML for CreateTable

    Operation <CreateTable>
    Elements TABLE_NAME Defines the name of the new table.
      COLUMNS XML nodes that define the table columns that 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. This 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
    <Envelope>
      <Body>
        <CreateTable>
          <TABLE_NAME>Purchases</TABLE_NAME>
          <COLUMNS>
            <COLUMN>
              <NAME>RecordId</NAME>
              <TYPE>NUMERIC</TYPE>
              <IS_REQUIRED>true</IS_REQUIRED>
              <KEY_COLUMN>true</KEY_COLUMN>
            </COLUMN>
            <COLUMN>
              <NAME>PurchaseDate</NAME>
              <TYPE>DATE</TYPE>
              <IS_REQUIRED>true</IS_REQUIRED>
            </COLUMN>
            <COLUMN>
              <NAME>ProductId</NAME>
              <TYPE>NUMERIC</TYPE>
              <IS_REQUIRED>true</IS_REQUIRED>
            </COLUMN>
          </COLUMNS>
        </CreateTable>
      </Body>
    </Envelope>
    
    Response <RESULT>
    Elements SUCCESS True if successful.
      TABLE_ID Identifies the ID of the relational table that is created in theAcoustic Campaign.
    Example
    <Envelope>
      <Body>
        <RESULT>
          <SUCCESS>TRUE</SUCCESS>
          <TABLE_ID>499600</TABLE_ID>
        </RESULT>
      </Body>
    </Envelope>
    

Join The Discussion

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