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

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

image (2).png

 

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