Loader Salesforce Marketing Cloud

This component is used for importing contacts (email addresses with attribute values) to Salesforce Marketing Cloud Data Extension.

Data In/ Data Out

Data In

Loader requires imports.csv file in directory /data/in/tables/imports.csv.

imports.csv file must contain column: email (required) which contains email addresses of contacts to upsert in Salesforce Marketing Cloud loader Data extension.

The rest of the columns (first_name, last_name, attribute1, attribute2, ...) in imports.csv file are considered as attributes to upsert.

The structure of the imports.csv file must correspond with the definition of data extension in Salesforce Marketing Cloud. Each Data Extension must have email column as PRIMARY KEY for successful upsert.

Example:

email	first_name	last_name	attribute1	attribute2
john.doe@email.com	Joe	Doe	hello
jane.doe@email.com	Jane	Doe		hello
foo@bar.com			Foo	Bar

Data Out

N/A

Learn more: about the folder structure please go to this article.

Parameters

client_id (required)	ID of installed OAuth application for the client.
client_secret (required)	Secret key of installed OAuth application for the client.

Remember: Both information can be found in Salesforce Marketing Cloud with the following steps:
Setup -> Platform tools -> Installed Packages -> {{YOUR_APPLICATION_NAME}}

Data extension key

data_extension_key (required)	ID (key) of Data Extension where audience from `import.csv` file will be imported.

data_extension_key (required)

ID (key) of Data Extension where audience from import.csv file will be imported.

Remember: Data Extension key can be found in Salesforce Marketing Cloud with the following steps:
Email Studio -> Email -> Subscribers -> All Subscribers -> Data Extensions -> {{YOUR_DATA_EXTENSION}}

Authentication and Rest URIs

authentication_base_uri (required)	URI used for refreshing access token.
rest_api_base_uri (required)	URI for REST API endpoint call.

Remember: Both information can be found in Salesforce Marketing Cloud: Setup -> Platform tools -> Installed Packages -> {{YOUR_APPLICATION_NAME}}

Remember: Data given in imports.csv will be loaded to Salesforce Marketing Cloud using the UPSERT method. Data of existing email (in Data Extension) will be rewritten.