Salesforce Marketing Cloud Batch Source
The Salesforce Marketing Cloud batch source plugin is available for Preview in the Hub.
Plugin version: 1.3.2
Reads from one or multiple objects within Salesforce Marketing Cloud depending on the mode values set for this plugin. For Multi Object
mode, the source outputs a record for each row from the object it reads, with each record containing an additional field that holds the name of the object from which the record came from. For Single Object
mode, this additional field will not be in the output. In addition, for each object that is read, this plugin sets pipeline arguments where the key is multisink.[objectname]
and the value is the schema of the object.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Reference Name | No | Required. Name used to uniquely identify this source for lineage, annotating metadata. |
Data Retrieval Mode | Yes | Required. Mode of data retrieval. The mode can be one of two values:
Default is |
Object | Yes | Optional. Specify the object for which data to be fetched. This can be one of following values:
Note: This value is ignored if Data Retrieval Mode is set to Default is |
Object List | Yes | Optional. Specify the list of objects from which to fetch data. This can be one or more values from following possible values:
Note: This value is ignored if Data Retrieval Mode is set to |
Data Extension External Keys | Yes | Optional. Specify the data extension key from which to fetch data. Note, this value is ignored in following cases:
|
Table Name Field | Yes | Optional. The name of the field that holds the object name to which the data belongs to. Must not be the name of any column for any of the objects that will be read. For the Note, the Table Name property value is ignored if the is set to Default is |
Filter | Yes | Optional. The filter selection criteria. For example, |
Client ID | Yes | Required. OAuth2 client ID associated with an installed package in Salesforce Marketing Cloud. |
Client Secret | Yes | Required. TOAuth2 client secret associated with an installed package in Salesforce Marketing Cloud. |
Authentication Base URI | Yes | Required. Authentication Base URL associated for the Server-to-Server API integration. For example, |
SOAP API Endpoint | Yes | Required. The SOAP Endpoint URL associated for the Server-to-Server API integration. For example, |
REST API Base URI | Yes | Required. The REST API Base URL associated for the Server-to-Server API integration. For example, |
Data Type Mappings from Salesforce Marketing Cloud to CDAP
The following table lists out different SFMC data types, as well as the corresponding CDAP types.
SFMC type | CDAP type |
---|---|
string | string |
phone | string |
email_address | string |
local | string |
integer/number | int |
double/decimal | double |
boolean | boolean |
timestamp | timestamp |
Created in 2020 by Google Inc.