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 an email column as PRIMARY KEY for a 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 (required)

ID (key) of Data Extension where the 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}}

Learn more: about documentation for creating data extension: here

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 the Salesforce Marketing Cloud using the UPSERT method. Data of existing email (in Data Extension) will be rewritten based on the email.