Mergespecs Overview

mergespecs direct Act-On to handle specifics when merging data into an existing list. When you append or update an existing list, mergespecs is required.

Parameters

NameParameter TypeRequired/OptionalData TypeDescription
mergeModeactionRequiredStringOne of the following modes to use in implementing merge:
- APPEND; simple append
- APPEND_NO_DUPLICATES; append while skipping duplicates
- UPSERT; update existing 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.
dstListIdidRequiredStringId of the list being updated
columnMapRequiredArray ListcolumnMap is not currently supported and this functionality will be added in a planned v2 revision of this endpoint. columnMap must currently be specified as "columnMap": [] and your source and destination lists must have a 1:1 column index.
createSegmentOptionalStringIf set to 1, creates a segment from records merged into the destination list.
mergeKeyHeadingOptionalStringheading name in the source data used to merge data into the destination list. If this is not specified, it uses the identified EMAIL column.

(default = EMAIL)