Update or merge a list

Update or Merge to an existing Act-On list.


Name Parameter
Data Type Description
Authorization: Header False Required String (Bearer {access token}) Pass the authentication token that was granted when you authorized access.
listid Path False Required String The id of the list to be updated--{listid} in path above.
headings Form False Optional String "Y" or "N" for if the first row of the file are headings. Default value is "Y". Any non-null value other than "Y" will be treated as "N".
fieldseparator Form False Optional String Specify either "COMMA" or "SEMI" as the separator. If not specified then the field separator value is determined by inspecting the file upload data.
quotecharacter Form False Required String Specify the type of quotes used around field names. Valid values: "NONE", "SINGLE_QUOTE", "DOUBLE_QUOTE"
uploadspecs Form False Required String When using the update/merge endpoint uploadspecs is a JSON string that provides Act-On information about the columns in the destination list in Act-On for the merge.*
mergespecs Form False Required String mergespecs is a JSON string that controls how the list is merged.*
putEmptyValues Form False Optional String If "Y" is specified, values in the destination list in AO will be overwritten by blanks if the source list is blank for the corresponding column. Default value is "N". Any non-null value other than "Y" or if this parameter is not included will be treated as "N". Parameter name is case sensitive.
file Body False Required File The output file in CSV format.

*Note: You can learn more about uploadspecs here and mergespecs here.



Following is an example HTTP request:


When a file is uploaded as a parameter for updating a list, a job id is returned. You can then obtain an upload status by querying the job id.

A successful request results in an HTTP 200 response with a JSON object like the following:

Code Examples


Grant Type Password
Grant Type Code
Grant Type Refresh
Account API
Get account information
Create new account user
Delete account users
Delete account user
Get email senders
Fact API
Upload custom events
Get upload custom event status
List API
Get listing of lists
Download a list
Create a new list
Update or merge a list
Get list upload status
Get rejected records from an upload
Delete a list
Delete records from a list
Get hard bounce list
Get spam complaint list
Get Opt-Out List
Update Out-Out List
Get Subscription Opt-Outs by 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 new footer
Delete a footer
Update a footer
Get image list
Get an image
Add an image
Replace 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 promotional form URLs
Get page list
Get page
Delete page
Get promotional 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 view report
Get a media timeline report
Get form report
Get page report
Get spam complaint list
Get hard bounce list
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 contents
Contact API
Add a contact
Get contact record
Upsert a contact record by email
Update a contact by record ID
Delete a contact
Get contact record ID based on cookie value
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