Loader Mailkit

Loader Mailkit allows you to load data into Mailkit.

Data In

/data/in/tables/mailing_list.csv

List of possible configurable fields (columns in input file mailing_list.csv):

Field name (column in input CSV file)	Data type
first_name	string
last_name	string
email (required)	string
gender	string
nick_name	string
status	string
phone	string
mobile	string
fax	string
street	string
city	string
state	string
country	string
zip	string
company	string
prefix	string
reply_to	string
vocative	string
custom1 - custom25 (25 custom fields each custom field is represented by a separate column in input CSV file)	string

Data Out

N/A

Learn more: about the folder structure here.

Client ID (required)	Client ID provided by Mailkit
Client MD5 (required)	Client MD5 (API secret key) provided by Mailkit

ID	Mailing list ID (either ID or Name is required)
Name	Mailing list name (either ID or Name is required)
Description	Mailing list description (optional)
Mailing list ID or Mailing list name (required)	If the Mailing list ID is known, the component will check if the Mailing list with the given ID exists. If yes, the component will add email addresses with all fields (in `mailing_list.csv`) to the list. If the contact already exists all fields will be updated. Component ends up with an error if the Mailing list does not exist. If the Mailing list ID is unknown, the Mailing list name is required to create a new list with a defined name and description (optional). All contacts in `mailing_list.csv` are inserted into the newly created list.

1. Warning: Consider the following guidelines when preparing your delimited text (CSV) files for loading: 1. Snowflake loader expects ‘,’ character to be used as a delimiter in the input CSV files. 2. Fields that contain the delimiter character (‘,’) must be enclosed in double quotes (‘"’). If the data contains double quotes, then those quotes must be escaped. 3. Carriage returns are commonly introduced on Windows systems in conjunction with a line feed character to mark the end of a line (\r \n). Fields that contain carriage returns should also be enclosed in double quotes. 4. The number of columns in each row should be consistent.