ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Loader Mailkit

Loader Mailkit allows you to load data into Mailkit.

Data In/ Data Out

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.

Parameters

Screenshot 2021-08-20 at 9.30.36 AM.pngScreenshot 2021-08-20 at 9.30.36 AM.png

Credentials

Client ID (required)

Client ID provided by Mailkit

Client MD5 (required)

Client MD5 (API secret key) provided by Mailkit 

Mailing list

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.