Overview

Skill Level: Beginner

Prerequisites

This interface updates a column value for all records in a Restricted database or a Classic query. If a Classic query is specified, contact in the parent database is updated if they are in the Classic query.

Step-by-step

  1. Syntax of the request and response XML for SetColumnValue

    Operation <SetColumnValue>
    Elements LIST_ID The ID of the Restricted database or Classic query that is used to determine what contacts to update.
      COLUMN_NAME The name of the database column that is being updated.
      COLUMN_VALUE Optional The value the database column is set to. This element is required when the ACTION is
    Update.
      ACTION The action to take on the database column. Possible values for ACTION are:

    • 0 – Reset (sets the value to ‘null’ or 0 depending on type).
    • 1 – Update (set to the VALUE passed in).
    • 2 – Increment (increment by 1)
      EMAIL Optional If specified, this email address receives notification when the job is complete.
    Example
    <Envelope>
      <Body>
        <SetColumnValue>
          <LIST_ID>140146</LIST_ID>
          <COLUMN_NAME>State</COLUMN_NAME>
          <COLUMN_VALUE>GA</COLUMN_VALUE>
          <ACTION>1</ACTION>
          <EMAIL>somebody@domain.com</EMAIL>
        </SetColumnValue>
      </Body>
    </Envelope>
    

    Response <RESULT>
    Elements SUCCESS TRUE if successful.
      JOB_ID Identifies the Acoustic Campaign Background Job that is created to set column values.
    Example
    <Envelope>
      <Body>
        <RESULT>
          <SUCCESS>TRUE</SUCCESS>
          <JOB_ID>98784</JOB_ID>
        </RESULT>
      </Body>
    </Envelope>
    

Join The Discussion

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