Updates a column value for all records in an Acoustic Campaign Restricted database or an Acoustic Campaign query.
Elements (Required)
LIST_ID - The ID of the restricted database or classic query used to determine what contacts to update.
COLUMN_NAME - The name of the database column to update.
ACTION - The action to take on the database column: 0 (Resets the value to 'null' or 0 depending on type), 1 (Updates to the COLUMN_VALUE), or 2 (Increments by 1). Note: Value 1 (Update) requires the element COLUMN_VALUE.
Elements (Optional)
COLUMN_VALUE - The value the database column is set. This element is required when the ACTION is Update.
EMAIL - The email address notified when the job is complete.
<Envelope>
<Body>
<SetColumnValue>
<LIST_ID>140146</LIST_ID>
<COLUMN_NAME>State</COLUMN_NAME>
<COLUMN_VALUE>GA</COLUMN_VALUE>
<ACTION>1</ACTION>
<EMAIL>[email protected]</EMAIL>
</SetColumnValue>
</Body>
</Envelope>
<Envelope>
<Body>
<RESULT>
<SUCCESS>TRUE</SUCCESS>
<JOB_ID>98784</JOB_ID>
</RESULT>
</Body>
</Envelope>
Elements (Results)
*SUCCESS - True if successful, False if not.
JOB_ID - Identifies the Acoustic Campaign background job created to update the column values.