| 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>
|