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.

It uses the parameters listed in the following table.

mergespecs parameters

Name Parameter Type Allow Multiple Required/
Data Type Description
mergeMode action N Required String one 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.
dstListId id Required String id of the list being updated.
columnMap Required array list columnMap 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.
createSegment Optional String if set to 1, creates a segment from records merged into the destination list.
mergeKeyHeading Required String heading name in the source data used to merge data into the destination list. If this is not specified, it uses the identified EMAIL column.


Example of mergespecs:

Grant Type Password
Grant Type Code
Grant Type Refresh
Account API
Get Account Information
Create New Account User(s)
Delete Account User(s)
Delete Account User by Email
Get email senders
Fact API
Upload Custom Event
Get Custom Event Upload Status
List API
Get List of Assets
Download a List
Create a New List
Update a List
Get List Upload Status
Get List Rejected Records
Delete a List
Delete Records from List
Get Hard Bounce List
Get Spam Complaint List
Get Opt-Out List
Update Out-Out List
Get Opt-Outs by Subscription Category
Content API
Get Logo List
Get a Logo
Add a Logo
Update a Logo
Delete a Logo
Get Header List
Get a Header
Add a Header
Update a Header
Delete a Header
Get Footer List
Get a Footer
Add a Footer
Delete a Footer
Update a Footer
Get Image List
Get an Image
Add an Image
Update an Image
Delete an Image
Get Media List
Get Media File
Add a Media File
Add a Media Link
Update Media File
Delete a Media Object
Get Form List
Get Classic Form URLS
Get Landing Page List
Get Landing Page
Delete Landing Page
Get Landing Page URLs
Get List of Programs
Reporting API
Get Message Report
Get Message Report Drilldown
Get Message Report by Time Period
Get Media Report
Get Media Message Report
Get a Media Report Drilldown
Get a Media Timeline Report
Get Form Report
Get Landing Page Report
Email Campaign API
Get Message List
Send a Message
Resend a Message
Add New Template or Draft Message
Update Template or Draft Message
Delete a Message
Get Message Report
Get Message Report Drilldown
Get Message Report by Time Period
Get Message HTML
Contact API
Add a Contact
Get Contact Record
Update Contact Record by Email
Update Contact by Record ID
Delete a Contact
Get Record ID Based on Cookie
Get contact from list based on cookie ID or e-mail
Get contact fact and score data
Get subscription categories
Opt in/Opt out subscription category by email address
Get subscription category opt-ins by email
Opt in/Opt out multiple subscription categories by email address
Get SEO keywords
Get a new SEO report
Frequently Asked Questions