ListMergeFields

The merge field (formerly merge vars) for a given list. These correspond to merge fields in MailChimp's lists and subscriber profiles.

Table Specific Information

Select

The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.

MergeId supports the '=' operator.
ListId supports the '=' operator.
Type supports the '=' operator.
Required supports the '=' operator.

SELECT * FROM ListMergeFields WHERE ListId = 'abc'
SELECT * FROM ListMergeFields WHERE Type = 'address'
SELECT * FROM ListMergeFields WHERE Required = true
SELECT * FROM ListMergeFields WHERE ListId = 'abc' and MergeId = '595'

Insert

The Name and ListID are required for INSERTs.

INSERT INTO ListMergeFields (Name, ListID) VALUES ('myNewListMergeField', 'myListID')

Columns


Name	Type	ReadOnly	Description
MergeId [KEY]	Integer	True	An unchanging id for the merge field.
Tag	String	False	The tag used in MailChimp campaigns and for the /members endpoint.
Name	String	False
Type	String	False	The type for the merge field.
Required	Boolean	False	Boolean value for if the merge field is required
DefaultValue	String	False	The default value for the merge field if null.
Public	Boolean	False	Whether or not the merge field is displayed on the signup form.
DisplayOrder	Integer	False	The order on the form where the merge field is displayed.
Options_DefaultCountry	Integer	False	In an address field, the default country code if none supplied.
Options_PhoneFormat	String	False	In a phone field, the phone number type: US or International.
Options_DateFormat	String	False	In a date or birthday field, the format of the date.
Options_Choices	String	False	In a radio or dropdown non-group field, the available options for members to pick from.
Options_Size	Integer	False	In a text field, the default length of the text field.
HelpText	String	False	Any extra text to help the subscriber.
ListId [KEY]	String	False	A string that identifies this merge field collections' list.

Excel Add-In for Mailchimp

ListMergeFields

Table Specific Information

Select

Insert

Columns