acton update list

Update/Merge Act-On List

Version: 17.07

Supported Since: 17.07

Update or Merge Act-On List connector operation provides the ability to perform altering operations on an Act-On List such as appending and merging records.

Parameters

* marked fields are mandatory

List ID *

Basic

The ID of the list to be updated. This can be specified as a constant value or as a combination of placeholder expressions such as @{message.headers.<name>}, @{message.properties.<name>}, @{message.id}, @{mc.id}, @{mc.properties.<name>}, @{variable.<name>}.

Enable Headings

Basic

If specified as true, cells in the first row of the file are treated as headings.

Field Separator

Basic

Character used around fields; valid values: COMMA, TAB, SEMI.

Upload Specification *

Basic

A JSON object to describe the structure of the payload being uploaded when updating the list.

You can learn more about the upload specification here.

Merge Mode *

Basic

Merge mode to be used by Act-On. APPEND is used by default; valid values: APPEND, APPEND_NO_DUPLICATES, UPSERT, UPDATE_ONLY, REPLACE

  • APPEND : simple append

  • APPEND_NO_DUPLICATES : append while skipping duplicates

  • UPSERT - update existing records and insert new records

  • UPDATE_ONLY - update existing records

  • REPLACE - replace the entire contents of the list with the uploaded records. Any records in the list that are not in the uploaded records are deleted.

Merge Key Heading *

Basic

The heading of the column to be used to merge data into the destination list. If not specified, Email column will be used by default.

Quote Character *

Basic

The type of quotes used around field names; valid values: NONE, SINGLE_QUOTE, DOUBLE_QUOTE.

Put Empty Values

Basic

If true, values in the destination list in Act-On will be overwritten by blanks if the source list is blank for the corresponding column.

Response

If this operation was invoked successfully, it will provide a response message with a JSON payload of the following format.

{
    "status": "success",
    "message": "Upload completed",
    "jobId": "11384175"
}
In this topic
In this topic
Contact Us